Hello, I am actualy working on a SSIS package that use a custom COM dll with an activeX script task. the script call the CreateObject() function against the dll. in order to use the dll component I Regsvr32 on the dll file and execute the package from management studio. It has worked fine. Now, with Visual Studio, I execute the same package in order to visualize the execution flow and the activex task failed. the error message is ""[ActiveX Script Task] Error: Retrieving the file name for a component failed with error code 0x1BF8BCC8. " do u see any reason for that ? did i missed something ? thanks for any help Stéphane

any idea ? :-)

Perhaps the placement of the Main route matters, see this thread: http://social.msdn.microsoft.com/Forums/sr-Latn-CS/sqlintegrationservices/thread/8f43a6e9-b0e9-4113-af9f-44a3363e4a11 As a general suggestion try not using the ActiveX task (it is superseded by the Script Task).Arthur My Blog

thanks for the answer but i already read this thread. the script is OK because the package execute properly when lunched from management studio. the problem is when I execute the package from Visual studio in order to see the red or green boxes... please any other suggestion ?

Hi Stephane Guilleminot, Have you configure your ActiveX Script Task in visual studio? Could you please take the following link and check the configurations of ActiveX Script Task. ActiveX Script Task: http://msdn.microsoft.com/en-us/library/ms137525(v=SQL.90).aspx SQL SERVER: SSIS - ActiveX Task: http://sqlyoga.com/2009/10/sql-server-ssis-activex-task.html Thanks, Eileen Forum Support Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

Hi Eileen Zhao, I checked the configuration as describe in the first URL I tested the script provide with the second URL and it has worked fine. You should also know that the SSIS package works fine when launched from management studio. The problem is only appearing when using Visual Studio to execute the package Stéphane

something new mayby that could help for solving this problem : this T-SQL statements failed with the same error : DECLARE @SSIS_BATCH_COMMAND AS VARCHAR(100) SET @SSIS_BATCH_COMMAND='DTEXEC /SQL "MY_SSIS_PACKAGE"' Exec xp_cmdshell @SSIS_BATCH_COMMAND Error: 2011-09-08 05:37:52.93 Code: 0xC0048006 Source: LOG - PACKAGE ERROR ActiveX Script Task Description: Retrieving the file name for a component failed with error code 0x1B3B39E8. End Error when the same package is executed from management studio connected on SSIS server it works fine

I also tryed to launch dtexec through cmd line and the execution failed with the same error. What is the problem ?