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 |
|
qman
Constraint Violating Yak Guru
442 Posts |
 Posted - 2010-10-14 : 10:47:05
|
| I have a simple SSIS package containing two steps.The first is a SQL Task, which truncates table data.The second, is a Data Flow Task, which connects to DB2 to read data, and populates a SQL Server table.Simple enough....When I press the debug button, the package does not get past the validation. It says "SSIS package "Package.dtsx" finished: Canceled.".Each step works fine if I execute individually.If I run the process without debugging, it works....What gives, has anyone seen this behavior before?How am I supposed to run the process as a whole using debug? |
|
|
qman
Constraint Violating Yak Guru
442 Posts |
Posted - 2010-10-14 : 14:07:15
|
| I set DelayValidation to True. I am now able to pass validation via debug. |
 |
|
|
|
|
|
Odd SSIS Behavior, ahhhhh!