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