May 26, 2008 at 5:18 pm
Hey All,
I have an SSIS package that inserts data into a table on the db2 database from SQL server 2005 through SSIS & an oledb provider, except for a small problem.
Iam not able to insert any text/character data on the destination table(on db2 database). The package executes without any errors. All the decimal data is uploaded successfully but the text columns have blank values.
Could someone pls share their experience in resolving this kind of issue or any pointers on same would be of great help.
Also, i have tried inserting data with open query which works successfully but via package is when i get a problem.
I tried changing the package data type but that did not help too :hehe:
Someone pls guide me in resolving this as i am not able to find any relevant posts talking about the same.
Thanks a ton!
May 27, 2008 at 12:36 am
What are the datatypes on your source and destination, and what are the datatypes you are using in SSIS?
SSIS is very finicky about datatypes
May 27, 2008 at 9:57 am
Hi Mr and Mrs. 500,
The data type at the destination (i.e on db2 database) is of type text or character. I do have the liberty to modify the data type at the source(i.e sql server), so i have made to text or character too but i still have a problem in uploading the data 🙁
May 29, 2008 at 12:27 am
Hey,
What I meant is the actual type(i.e char(200) or varchar(200), is it nullable, is it unicode)?
Can I make a small suggestion? Why dont you set your SQL side to be exactly the same as your DB2, and then re-define your source. It will provide you with the necessary SSIS datatype required when you create an OLE DB connection
~PD
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply