Data Export Wizard - Drop Table option not available

I was using the Export Data Wizard to transfer my data to hosting provider, however the option to drop detsination table first is greyed out. Any Idea? Als Why do I need to do in for each table by clicking Edit? Is there a global setting like in the old Wizard?

Make sure your source and destination databases are different.

Cheers,
Dan

|||

Different server, but same name of database. I may have some restrictions on the destination server, since it is hosting environment. However I can create tables.

Also How to to this globally for all tables at once, instead of clicking Options one by one?

|||What could be the reason that the option "drop and recrete destination table" is grayed out in the Export Wizard (after clicking table edit button)? Is this realted to security?|||

Does anyone have a solution for this?

As soon as the database name is the same this option is disabled? Is this a bug? I have full permissions so it can't be a security issue.

sql

Data Export Wizard - Drop Table option not available

I was using the Export Data Wizard to transfer my data to hosting provider, however the option to drop detsination table first is greyed out. Any Idea? Als Why do I need to do in for each table by clicking Edit? Is there a global setting like in the old Wizard?

Make sure your source and destination databases are different.

Cheers,
Dan

|||

Different server, but same name of database. I may have some restrictions on the destination server, since it is hosting environment. However I can create tables.

Also How to to this globally for all tables at once, instead of clicking Options one by one?

|||What could be the reason that the option "drop and recrete destination table" is grayed out in the Export Wizard (after clicking table edit button)? Is this realted to security?|||

Does anyone have a solution for this?

As soon as the database name is the same this option is disabled? Is this a bug? I have full permissions so it can't be a security issue.

Data conversion inserting to DB2 on AS400 with SSIS

I created a SSIS package moving data from a SQL 2005 table to an existing DB2 table on AS400 using Microsoft OLE DB Provider for DB2.

When the package was run, it showed that rows were successfully inserted to DB2. However, the data didn't seem to be converted correctly. Most of the string values were inserted as unusual characters. Also any string values of digits were not inserted.

For example, 1.) a character field (char(1) or nchar(1) as I have tried both types) in SQL 2005 table with a simple value of 'H' was inserted into the DB2 table field of type "A" (alphanumeric) of length 1 as '?' and others letters were inserted as other unusual characters. 2.) A string value of '00100' in SQL Server is not inserted to DB2 table at all.

Later we found that the fields inserted with usual characters are difined as CSSID =65535. A few fields with correct data inserted have CSSID=00037.

Does anyone know why this happened and how to solve this to get the data inserted correctly in the DB2 table?

Thanks in advance for any help!

Try to set the appropriate LocaleID and DefaultCodePage on your destination component.

Thanks.

|||

The LocaleID and DefaultCodePage were set correctly.

What I found was in the Data Link Properties of connection manager, the "Host CCSID" was set to "OEM - United States [437]". I changed it to "EBCDIC - US/Canada [37]" and it started working perfectly.

Thank you for your suggestion though.