Click to See Complete Forum and Search --> : Need help in Accessing the DTS package from VB.net


nevu
04-07-2004, 11:46 AM
Hi,

Can any one help in how to resolve my error.

I am trying to access the DTS package which I created in SQL Server 2000 and here is the code.

myPkg.LoadFromSQLServer(pserverName, pserverUser, ppassword, myDTSFlags.DTSSQLStgFlag_Default, "", "", "", pnameDTS, pVarPersustStgOfHost)

As soon as I finish this line, I get the following error in the Catch.




When I am trying to execute the code I get follwoing error.

Error NUmber 2147217843
invalid username qleonard