Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 loading SSIS in activeXscript within SSIS

Author  Topic 

freesoul
Starting Member

35 Posts

Posted - 2008-04-09 : 09:34:53
I am trying to load a dtsx file in the SSIS package ActiveXscript.
But i am getting the following error

Error retreiving the filename for a component failed

In DTS the syntax was
LoadFromStorageFile(UNCFile,Password,[PackageID],[VersionID],[Name],[pVarPersistStgOfHost])

and for SSIS Sql Server 2005 its :
app.LoadPackage("C:\Projects\TestPackage.dtsx", Nothing)

some how its not working for me.Is it because of me using ActiveX scipt
Please help
Thanks in advance.

nr
SQLTeam MVY

12543 Posts

Posted - 2008-04-09 : 13:23:26
Think it should work.
There's a third boolean parameter - try setting it to false.

Do you have VB - I always develop in VB and the convert to vbscript.


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -