Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sohrabkhan1000
Starting Member
2 Posts |
 Posted - 2012-06-12 : 02:14:38
|
| dear all,i have devoloped ssis package it retrive data from one sql source to another it execute fine with same user and also it can be executed from sql sever,and i have devoloped asp.net application to execute package like follwing: Package package = new Package(); Application app = new Application(); DTSExecResult packageresult = new DTSExecResult(); package = app.LoadFromSqlServer("packagename", "servername", "username", "password",null); packageresult = package.Execute(); when i run application localy it execute fine when i debug application in another machine the package not execting and not i am getting error.sohrab |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-06-12 : 04:26:53
|
| Does the load work?Does the other machine yoou are running it on have access to the connections?Have yoou enabled logging to see if anything happens?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-06-12 : 15:39:29
|
| whats error? is it error in fetching package itself from location or is it error in execution? Also whats protection level you've chosen for package? Is application using proxy account or logged in user account for running package?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
SSIS