Oh my! Phew! I have got to slow down on the "Red Stripes"! hehe.
After all that work (see below), I discovered that you could download a
Microsoft OLEDB Provider for DB2 and you don't need to convert varchar
columns. Ouch! Hehe.

http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4
479-9b91-9e8b9d835cdc&displaylang=en

File: X86 Package (DB2OLEDB.exe) - 8276 KB


It should be Fridayyyyyyyyy! Partyyyyyyyyyyy! Hehe.





Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Dr. Eric J. Smith is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Edwards, Ed
Sent: Tuesday, February 19, 2008 10:41 AM
To: LazyDBA Discussion
Subject: FROM SQL SERVER 2005 (SSIS - OLE DB SOURCE - OLE DB
DESTINATION) TO DB2 (WINDOWS)
Importance: High

To All,
Oh my! Phew! Ouch! Hehe. I have been drinking mucho "Red Stripes"
trying to figure it how to move data from a SQL Server 2005 table to a
DB2 database, using SSIS components (OLE DB SOURCE and OLE DB
DESTINATION). I kept getting the old famous "Cannot convert between
Unicode and non-unicode string data types" error messages.

Then I tried "the COKE" and it started thundering, lightning, and
raining! We were having a thunderstorm! Hehe. But, I got an idea:
"Create a new SQL Server 2005 table from the original SQL Server 2005
table and change all the varchar columns to nchar". Next, I had to
select "NEW" in SQL Server 2005 SSIS OLE DB DESTINATION component and
ensure in the "CREATE TABLE" statement that the datatype for DB2 was
varchar and not nchar.

Oh my! Phew! It's worked! Hehe. Ouch! Now me be "ORACLE DBA"! So I
say to myself (between some more "Red Stripes") "Which is worse "SQL
Server or DB2"? hehe.


It's Fridayyyyyyy! Partyyyyyyy! Hehe.


Have a great Day!


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

DB2 & UDB email list listserv db2-l LazyDBA home page