Interesting.... do you know if this work with SQL Server 2005 dtsx packages though? Or does it only work for SQL Server 2000 dts ones?


>Hi,
>
>You might also try...
>
>

>oPkg=createobject([dts.package])
>opkg.LoadFromSQLServer( "YourServerName", "<userid>", "<password>",256, "", "", "", "YourDtsPkg")
>opkg.Execute
>

>
>Replace "YourServerName" with the SQL server you wish to access and "YourDtsPkg" with the dts package you wish to run.
>
>"userid" and "password" should remain just the way they are. At least that's the way it works for me. I do not have to supply userid and password.