December 8, 2004 at 5:06 pm
Recent install of SQL Server 2k sp3a. Client Access ( IBM ) V5R2 installed ( for DB2 driver ). When DTS package is created to create a table with the structure of the DB2 table ( 30 ) fields, only the first 9 fields are captured.
Anyone else with a similar experience and or solution?
December 12, 2004 at 1:53 pm
I am using V5R1 for the last 2 years and that has been fine. I normally use the ODBC driver. Have you tried that or was it the OLE DB?
When you create the job, have you clicked CREATE Table in the destintaion tab?
In the ODBC DSN, make sure you have the checkbox ticked for Translation/Convert Binary Data(CCSID 65535) to text.
Under General/Connection options I Never prompt for SQL Connect and Do not use SSL.
Under Server/Advance/Commit mode use Commit immediate.
Fred
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply