March 5, 2009 at 4:30 pm
I have a simple SSIS package to copy data from a DB2 database into SQL Server. I've successfully copied data in the other direction so I know my connections are good. The query selecting the data shows rows in "Preview Results" so I know the data is selected correctly.
When I run the package, the Data Transformation task stays yellow even after the package says it has completed. The Execution Results tab does not show any errors. But it doesn't show "number of rows copied" like I would expect. And the destination table is empty.
I have no idea how to proceed and need to complete this project ASAP. Please tell me you've seen this behavior before and know how to deal with it.
TIA, Cindy
March 5, 2009 at 4:54 pm
I found a little more information that might help. This is what's in my Output window even though I did not cancel the execution. I'm still in Debug mode. Is there something possibly cancelling it that I don't know about?
SSIS package "Package.dtsx" starting.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning.
SSIS package "Package.dtsx" finished: Canceled.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply