question

vishu avatar image
vishu asked

Error while retriving data from DB2 using SSIS

I am extracting data from DB2 into SQL Server 2005 using IBM OLEDB provider for DB2. Source table have only 2 columns both are decimal in type. It has only one row for testing. While extracting data using SSIS I am getting following message

SSIS package “Package1.dtsx” starting.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Information: 0×40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0×40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning. SSIS package “Package1.dtsx” finished: Canceled.
The program ‘[3796] Package1.dtsx: DTS’ has exited with code 0 (0×0).

sql-server-2005ssiserror-message
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.