DTS Table Package Wizard PostgreSQL - MSSQL 2000

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

DTS Table Package Wizard PostgreSQL - MSSQL 2000

Postby mbare0 » Fri Oct 02, 2009 1:48 pm

Using driver to move a table from PostgreSQL to MSSQL 2000, with DTS export Wizard. PostgreSQL table and MSSQL 2000 tables were created with the same structure. One of the columns is text. Some of the text columns are over 500k in size. The largest is 650k in size. Testing trial version, and just purchased a licensed version today. My concern is on the rows with large text columns. I'm getting below error, in DTS, on a ten row test insert, for large text columns -

data for source column 2 (test) is too large for the specified buffer size.

Any suggestions on why the driver is having an issue on larger test column sizes?

Thanks,

Mark
mbare0
 
Posts: 2
Joined: Fri Oct 02, 2009 1:39 pm

Re: DTS Table Package Wizard PostgreSQL - MSSQL 2000

Postby mbare0 » Fri Oct 02, 2009 2:34 pm

FYI, tried the same test with MSSQL 2005 inport wizard, and it worked with the large text column rows.

Best regards,

Mark
mbare0
 
Posts: 2
Joined: Fri Oct 02, 2009 1:39 pm

Re: DTS Table Package Wizard PostgreSQL - MSSQL 2000

Postby admin » Sun Oct 04, 2009 12:22 am

Mark,
we will try to reproduce the issue and find why it is happening. I'll let you know...

Thank you
Konstantin
admin
 
Posts: 4
Joined: Wed Dec 17, 2008 6:03 pm


Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: No registered users and 1 guest