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 |
|
JeffK627
Yak Posting Veteran
50 Posts |
 Posted - 2010-07-12 : 19:02:15
|
| I have an SSIS package that reads flat text files into tables for about 30 objects that are undergoing data cleansing. Each object has three flat files and three tables that those files are read into.One of the objects fails when the job runs on the server at its scheduled time. However, when I go in and run that data flow task manually, it succeeds. Even weirder, if I run the entire package from my local machine, the task fails again. Only one out of the three flat files gets successfully read into its table.I have confirmed the presence of the flat files in the expected directory and that they are formatted correctly. What could cause one data flow task out of 30 similar ones to fail when the SSIS package is run as a whole but NOT fail when the task is run alone?Any ideas would be appreciated! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Odd SSIS Failure