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 |
|
alwaysram
Starting Member
5 Posts |
 Posted - 2008-08-07 : 11:15:44
|
| HiI need some experts advise. I am uploading 100s of csv files, each of 512kb files through SSIS in BIDS. Package execution is stopping itself for every 60-70 files(some times after 500 files), with message "SSIS package ETLAll.dtsx finished: Cancelled." in output window. It does not give any other information, even in log files. After thorough observation, I noticed that a small DOS black windows (C:\programfiles\..90\shared\SQLDumper.exe) flashes for a second, cancelling the package execution. Also, the package execution doesn't stop at any particular dataflow task, it varies. Consumption of memory and cpu is not more than 40% while execution. Any suggestions or advise, to stop it happening is much appreciated. thanksRamesh |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-07 : 22:39:23
|
| Did you see any dump file in log directory? Any error in windows event logs? |
 |
|
|
alwaysram
Starting Member
5 Posts |
Posted - 2008-09-14 : 18:35:49
|
| Thanks rmiao for your time. I managed to resolve the issue. The issue was caused because I was using the initial RTM version of SQL2005. Upgrading to latest version along with SP2, resolved the issue. May be the fix was addressed in later versions. Thanks |
|
|
|
|
|
|
SQLDumper stopping SSIS package execution