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 |
|
anilpinnamaneni
Starting Member
1 Post |
 Posted - 2009-10-26 : 12:46:20
|
| Hi,I am running in to a strange issueI 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 errori am using Provider=IBMDADB2Please help me out Thanks&RegardsAnil |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-11-03 : 11:47:03
|
| Anil,Are you sure those fields have values in the source database?<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
|
|
|
Problem with DB2 Source in SSIS