Error Retrieving The File Name For A Component Failed
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error: Retrieving the file name for a component failed with error code 0x03B98F74 up vote -1 down vote favorite I have simple SSIS ActiveX Script task that is returning with the above error when executing: I've cut all the code down to just an empty function: function main end function And have ensured the EntryMethod property of the component is main Any suggestions? sql-server-2005 ssis share|improve this question edited Jan 21 '10 at 10:43 asked Jan 21 '10 at 10:24 James Wiseman 21.3k962133 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote I came across this same error and found that a connection in the activex script was referencing a dsn name that didn't exist. I added the DSN through control panel -> administrative tools -> Data sources (ODBC) and the issue was resolved. share|improve this answer answered Feb 17 '12 at 13:53 Brandon leach 1304 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged sql-server-2005 ssis or ask your own question. asked 6 years ago viewed 1272 times active 4 years ago Related 1SQL Server 2005 SSIS job that w
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2005 » SQL Server 2005 Integration Services » [ActiveX Script Task] Error: Retrieving the... [ActiveX Script Task] Error: Retrieving the file name for a component failed with error code 0x000F0EE4. Rate Topic Display Mode Topic Options Author Message asd-503476asd-503476 Posted Thursday, November http://stackoverflow.com/questions/2108390/error-retrieving-the-file-name-for-a-component-failed-with-error-code-0x03b98f7 29, 2007 11:04 AM Forum Newbie Group: General Forum Members Last Login: Wednesday, April 8, 2015 12:14 PM Points: 2, Visits: 134 Hi I am using 2 connection managers in my ssis package pointing to same server.I used activex script to select server and assign it to connection managers.I declared 2 variables(package scope http://www.sqlservercentral.com/Forums/Topic427624-148-1.aspx ).here is my code Function Main() DTSGlobalVariables("DBServer").Value = "devserver" DTSGlobalVariables("DBName").Value = "aa" ' DTSGlobalVariables("DBServer").Value = "proserver" ' DTSGlobalVariables("DBName").Value = "aa" With DTSGlobalVariables.Parent.Connections("connectionmanager1") .DataSource = DTSGlobalVariables("DBServer").Value .Catalog = DTSGlobalVariables("DBName").Value End With With DTSGlobalVariables.Parent.Connections("connectionmanager2") .DataSource = DTSGlobalVariables("DBServer").Value .Catalog = DTSGlobalVariables("DBName").Value End With Main = DTSTaskExecResult_SuccessEnd FunctionWhen I execute this task my connection managers should get connected to my devserver.but i got error?Can anybody help me woth this. Post #427624 Michael Earl-395764Michael Earl-395764 Posted Friday, November 30, 2007 5:25 AM SSCrazy Group: General Forum Members Last Login: Tuesday, August 10, 2010 5:07 AM Points: 2,661, Visits: 23,078 You really need to look at expressions and package configurations in books online. You should be very hard pressed to find any reason to use a script task to set properties on SSIS components at run-time. Post #428035 « Prev Topic | Next Topic » Permissions You cannot post new topics. You cannot post topic replies. You cannot post new polls. You c
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask https://www.experts-exchange.com/questions/23432362/SSIS-Error-in-Active-x-Script-Error-0xC0048006-at-ActiveX-Script-Task-Retrieving-the-file-name-for-a-component-failed.html for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today http://sqlrowcount.blogspot.com/2012/02/activex-script-task-error-retrieving.html Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > SSIS Error in Active x Script: Error: 0xC0048006 at error retrieving ActiveX Script Task, Retrieving the file name for a component failed. Want to Advertise Here? Solved SSIS Error in Active x Script: Error: 0xC0048006 at ActiveX Script Task, Retrieving the file name for a component failed. Posted on 2008-05-26 MS SQL Server Web Components MS SQL Server 2005 1 Verified Solution 3 Comments error retrieving the 2,958 Views Last Modified: 2013-11-30 Hi Experts, I have problems running a simple activex Script in a SSIS Job. The Script: '********************************************************************** ' Visual Basic ActiveX Script '************************************************************************ Function Main() Dim fso, f, strFilePath, retVal strFilePath = "C:\...\SSIS\ImportData\Log.csv" Set fso = CreateObject("Scripting.FileSystemObject") Set f = fso.OpenTextFile(strFilePath,1) retVal = f.readall int i = retVal f.Close End Function This script throws this error: It is running fine if I start it in a "Non-SSIS-Context". Error: 0xC0048006 at ActiveX Script Task, ActiveX Script Task: Retrieving the file name for a component failed with error code 0x03A2E1A4. Thanks a lot for help! 0 Question by:arthrex Facebook Twitter LinkedIn Google Best Solution byarthrex hi cs97jjm3, unfortunately it didn't help. but thanks anyway. I use now the new "script task"-shapes with .net. No "ActiveX Script Task" any more. I read the "ActiveX Script Task" won't exist in Go to Solution 3 Comments LVL 31 Overall: Level 31 MS SQL Server 19 MS S
Retrieving the file name for a component failed with error code 0x001B6438.Anybody know how to troubleshoot these errors? I can't find anything on this error code. The same script works in DTS. I have got the same error, the code is different but couldn't figure out what to do...|||Hi Igor, This isn't much of an answer but it is true: you should try to move away from the ActiveX Script Task and use the Script Task instead.Hope this helps,Andy|||Script Task does mean that there is a different scripting language? I tryed a different thing: I moved all the script from a SSIS task to a SQL Server job (a job with one "activeX script" step).It sounds great, but I have a different error in the step that says that "The command script does not destroy all the objects that it creates. Revise the command script. (Microsoft SQL Server, Error: 14277)"I am not a VB programmer, so I think I have to ask someone to revise the script.Thanks for the help|||ActiveX scripts in SQL Jobs (all versions) appear to have a major bug in that they report Error: 14277 whenever the string "createobject(" appears more than once anywhere in the script. It does not matter whether the string is just part of a character expression such as: sTemp = "..... createobject( ...."; whether it appears in a comment or whether it is used to actually create an object. Any combination of the above that puts "createobject(" in the script more than once will cause the 14277 error to appear when you try to close the Job modifier.There is a trick that I have found to overcome this. That is, to create any and all objects in a single common subroutine. Even in this subroutine, you have to trick the system into thinking that you have just destroyed the object that you are trying to create.The subroutine is cobj. It takes the variable that will become the object and a string that defines the activex control. The "set ... = Nothing" that appears after the "Exit Sub" is the trick that makes the system think that the object is destroyed within the scope of cobj. Note: be sure to destroy the object in the scope where the object variable was defined.Here is a code sample that sends an email using ASPMAIL, which contains data from an ADO SQL query. '*********************************************' ActiveX Script - no 14277 error'*********************************************MailMe readSQL(1006), "mymail@.mail.com"Sub cobj(newobj, ax) Set newobj = createobject(ax) ' only appears once, he