July 21, 2009 at 6:14 am
Hello All.
I have a fairly simple package that gives me trouble. I start with 2 execute sql tasks that never give me a problem and then to a data flow task. I have a connection to a DB2 database that inserts records (2-3 million) into a SQL 2005 table. That insert will not always run. WHat happens is i get a very quick flash of a DOS screen...disappears and then the package claims it is finished with the data flow box still yellow. i have let it sit for a while and nothing. No error message. The strange part is that sometimes it runs, most of the time it doesn't.
Not sure if it's timing out or what.
I believe we have SP2 installed.
I have seen similar posts on the web with no solutions
Thanks
July 21, 2009 at 10:38 am
I am getting the same thing, what I noticed is the post execute gets to 25% and the package ends with a status of canceled.
The data flow ran meaning the data was read, transformed, and written successfully and all data flow components are green but the data flow container is yellow and package is done.
Now on this particular data flow I had an OnError event that would set the Propagate variable to false, that appears to be when the problem started. I deleted that event and the problem continued.
I added a new data flow task, copied all data flow components to this new task and the data flow runs fine and the task completes.
I can't find any differences between the two, all properties are the same (except the name) and there are no events for either task.
July 21, 2009 at 10:49 am
thanks for the input.
I stuck in a where clause that significantly limits the data from a few million rows to a few thousand and it runs just fine.
As i mentioned before, this package has run successfully before so i don't understand the limit all of a sudden AND it works fine against the AS400 and not the DB2 database.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply