Re: DTS package not executing from within a webservice

"Kannan.V [MCSD.net]" <KannanVMCSDnet@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:E2063E7F-3C62-46D9-B792-892953A2292F@xxxxxxxxxxxxxxxx
Hi all,

Am facing this issue for the last couple of days and hope I get a solution
here, did a lot of googling and havent yet fixed the issue.

I have a client windows App in vb.net, this app has a button that invokes a
method on the Server A which has a web method, Am trying to execute a DTS
package from within this webmethod to import data into the SQL tables.

I am using DTS.dll, created a wrapper and using the methods of the DTS.dll
to load the file and execute it.

When this executes i get the following error message
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.

I feel that since we use a wrapper for the COM component, the credentials
are not passed somehow,


This is the most probable problem. To resolve it impersonate your web service from an account that has access to the SQL Server. Look in this group for detailed description.

HTH,

--
Martin Kulov
http://www.codeattest.com/blogs/martin

MVP, MCT, MCSD.NET Early Achiever

.