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 |
|
suresha_b
Yak Posting Veteran
82 Posts |
 Posted - 2009-05-26 : 03:26:47
|
| One of our team members has created a SSIS package. It runs on development server without any issue.On production server it runs only if we login to the server and run the package.It does not run from SQL Agent job.It does not run if we run it from a PC using SSMS.It give different error messages.Why does it run when we login to the server and run the package?Why it does not run when we run it from a PC? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-26 : 03:58:39
|
Could be a number of issues.The best start would be to read and interpret the error message you get.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-05-26 : 05:32:01
|
| Does it use anything out of the ordinary like a 3rd party object or a mapped drive?Enable full logging and that should tell you where the problem is.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
suresha_b
Yak Posting Veteran
82 Posts |
Posted - 2009-05-26 : 06:09:57
|
| Thanks NR,It does not use any 3rd party object.It uses an Excel file stored in a shared folder.How to enable full logging?Regards. |
|
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2009-05-26 : 11:37:13
|
| Is the Server a 64 Bit machine or is the Development server 32 Bit machine? check that first.Secondly it must the configuration variables..check whether they are using Environment variables or File systemUse the BidsHelper on Codeplex to identify the configuration variables.http://www.codeplex.com/bidshelperhttp://www.sqlserver007.com |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-05-26 : 11:42:37
|
| It's under ssis in the designer.You'll have to add a og provider.I usually log to text files.>> It uses an Excel file stored in a shared folder.If you're trying to access that as a mapped drive then it won't work unless you are logged in or map it before running the package. Try copying it locally to see if it works. You should be passing in the location via a variable or config entry.==========================================Cursors are useful if you don't know sql.DTS 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 - 2009-05-26 : 12:06:39
|
| how did you migrate the package to production server? what security settings did you give? |
|
|
|
|
|
|
SSIS package running issue.