SSIS : Cannot automap for many columns

[kaoru]

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

[Moderator]

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!

[kaoru]

Hi,

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

many thanks...

[Moderator]

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

Thank you!

[kaoru]

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

[Moderator]

I enabled .txt and .doc attachments. This message has a test attachment. Please send your files with the .txt extension. Thank you!