SSIS : Cannot automap for many columns

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

SSIS : Cannot automap for many columns

Postby kaoru » Tue Dec 18, 2012 11:34 am

Hi,

I'm trying to copy data between MS SQL and Greenplum (PostgreSQL) using DTS Wizard.. and it seems that for a table that have more columns than 100 columns, it wont automap the rest of the source and destination columns. Is this a bug from SSIS ? or it's related with PGNP ?

thank u
kaoru
 
Posts: 9
Joined: Tue Dec 18, 2012 5:01 am

Re: SSIS : Cannot automap for many columns

Postby Moderator » Tue Dec 18, 2012 9:40 pm

I have not tried that. What version of SSIS are you using? Could you send the table DDLs in SQL Server and Greenplum to our Support, so that we can try to reproduce the issue?

Thank you!
User avatar
Moderator
Site Admin
 
Posts: 297
Joined: Wed Oct 29, 2008 11:27 pm

Re: SSIS : Cannot automap for many columns

Postby kaoru » Wed Dec 19, 2012 2:19 am

Hi,

I'm using SSIS 2008 and the DDL attached..
Pls let me know if there's a workaround for this :)

many thanks...
kaoru
 
Posts: 9
Joined: Tue Dec 18, 2012 5:01 am

Re: SSIS : Cannot automap for many columns

Postby Moderator » Wed Dec 26, 2012 8:57 am

I could not find attached DDL scripts. Could you e-mail them to Support again?

Thank you!
User avatar
Moderator
Site Admin
 
Posts: 297
Joined: Wed Oct 29, 2008 11:27 pm

Re: SSIS : Cannot automap for many columns

Postby kaoru » Mon Jan 07, 2013 11:47 pm

Hi, it seems that the extension for the attachment is not allowed.
can you tell me what extension allowed for attachment upload ?
I've tried .txt, .sql, and with no extension, but it still got error when adding the file.

thanks
kaoru
 
Posts: 9
Joined: Tue Dec 18, 2012 5:01 am

Re: SSIS : Cannot automap for many columns

Postby Moderator » Wed Jan 09, 2013 10:21 pm

I enabled .txt and .doc attachments. This message has a test attachment. Please send your files with the .txt extension. Thank you!
Attachments
rowset.txt
test
(252 Bytes) Downloaded 178 times
User avatar
Moderator
Site Admin
 
Posts: 297
Joined: Wed Oct 29, 2008 11:27 pm


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

Who is online

Users browsing this forum: Google [Bot] and 1 guest

cron