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-05-10 : 18:27:25
|
| Hi - I hope someone can help me figure this out, it's driving me crazy.I have an SSIS package that runs 20 consecutive Data Flow tasks. Each task loads 3 flat files into 3 database tables (1 file to each table). All the tasks are succeeding except for the last one, which fails every time the package is run. However, if I go in and click "Execute Task" on that same Data Flow, it succeeds. I have checked and all the flat files were in the expected location with the correct file names when the package was run. I can find no difference in the way this task is set up compared to the ones that succeed.The step following this task is just a simple Scripting Task that writes a message to a log file. Can anyone offer any ideas as to why the task is failing in the package but succeeding when run alone?EDIT: I'm running SQL Server 2005 if that's any help. |
|
|
|
|
|
Mystery Data Flow Task Failure