
April 22nd, 2008, 07:24 AM
|
|
Registered User
|
|
Join Date: Apr 2008
Posts: 2
Time spent in forums: 27 m 17 sec
Reputation Power: 0
|
|
|
SSIS Execution Failure While executing it with Webservice:
Scenario Configuration : VB.net 2005 Code, WebService for Executing SSIS on Server, SSIS deployed on the Database Server
Problem Description : We are developing windows applicaiton in which we call webservice which was deployed on the same server where SSIS packages are deployed.
Now from Code we are passing FilePath name in variable and execute the Package. But the SSis result says that
The file name "\\computername\fol1\fol2\fol3\fol4\abc.txt" specified in the connection was not valid. Expression was evaluated successfully but "ConnectionString" property can not be set to expression.
More Information:
1. Full Permission are given on this network folder.
2. Package executes successfully from SSIS development solution (BIS solution)
3. Deployed packed executes successfully from the Database Server.
4. From Development pc packege executes successfully.
There is one special case in which this error comes: when we execcuted the package from webservice then and only this error comes.. if we directly try to execute the code from vb.net application at this time they gets executed sucessfully.
Detailed Info: We have deployed webservice on the server where Database serve is installed...! in web service i 've created ont function which calls the Package and executes it..! Now i've given web refrence of this webservice in to my application and passing prameters to webmethods...!
can any one have any idea why this was not working? as before few days this was running successfully....!
|