DTS package not executing from within a webservice

[Kannan.V [MCSD.net]]

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,

Is there a way to solve this issue or am i missing something here,

Thanks in advance for all the inputs.
--
Kannan.V
Home : http://www.kannanv.com
Blog : http://kannanv.blogspot.com
Blog : http://spaces.msn.com/members/visitkans
Web : http://www.dotnetlounge.net

 

[Martin Kulov [MVP]]

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,

 

[Kannan.V [MCSD.net]]

Hi Martin,

Thanks for the response, I have impersonated the web service in the App
server with an admin account that has full rights on the app server as well
as on the SQL server, but still the user is comming up as null when the call
to the execute DTS is made.

--
Kannan.V
Home : http://www.kannanv.com
Blog : http://kannanv.blogspot.com
Blog : http://spaces.msn.com/members/visitkans
Web : http://www.dotnetlounge.net