Post reply

Problem with DB2 Source in SSIS

  • October 26, 2009 at 9:03 am

    #212616

    Hi,

    I am running in to a strange issue

    I am extracting the data from the DB2.I am pulling three columns from the source table.Their data types is varchar,varchar and dbdatetime.

    The source is having some thing around 12,000 rows.After pulling the 9000 change records i am getting a wired problem like column a and column b which are varchars are getting empty values and date time value is getting some weird value 0000-00-00 00:00:00 and due to this my package is failing.

    The package is running fine in local BIDS.The only problem is when i am running this package in the server i am getting error

    i am using Provider=IBMDADB2

    Please help me out

  • November 16, 2009 at 9:59 pm

    #1080023

    At what point is the package failing, is it failing at the source or further down? If it is at the source then you will have to modify your query to handle those values, if it happens further down then you can do a derived column task to manipulate it.

    I had a similar issue with the DB2 drivers a LONG time ago and I can't remember for sure how I fixed it..

    CEWII

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply