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 |
|
benking9987
Posting Yak Master
124 Posts |
 Posted - 2012-02-06 : 10:36:00
|
| I have an SSIS package that imports files within a folder and once they are imported, it moves the files into a "Done" folder. The package is working 100% when I test it through the visual studio.HOWEVER, once I run it as a step within a job in my SQL Agent, then it doesn't complete all the steps in the package. Step 1: Importing the data to a table occurs normally, but Step2: moving the files to the "Done" folder doesn't occur.Any ideas why this might be happening? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-06 : 11:49:57
|
| whats error thrown by job? are the paths specified inside package UNC paths? are paths accessible from server where package is stored under the account which sql server agent uses ?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
benking9987
Posting Yak Master
124 Posts |
Posted - 2012-02-08 : 09:59:20
|
| Oops. Stupid on my part. One of the parts of the destination file settings was not a UNC path. Thanks for pointing me in the right direction. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-08 : 14:16:40
|
| ok no probshope you got it sorted out!------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Package not executing properly through SQL Agent