import/export issue - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

import/export issue

Author

Topic

rkharirkishnan
Starting Member

2 Posts

Posted - 2008-11-07 : 02:09:56

When i try to import/export data between two server, and if the destination table is created for transfer, i miss the primary keys, foreign keys and identity properties in the destination tables. How can i keep these while transferring data?

I am using sql server version 9

More over when i do import/export, wizard is asking to save the ssis package in sql server. Ihave given save. But from where i can find this back?

Thanks for the help in advance

Hari Krishnan R K
techiebuddy.com

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-07 : 03:00:06

1.prior to transfer script out primary keys,foreign keys and other properties of table from sql managements studio by connecting to source server and apply to destination server
2.If you've saved the package in sql server, you can get it by connecting to integration services engine on your server. Expand server -> Stored Packages ->MSDB and you shoule see your package listed there.

rkharirkishnan
Starting Member

2 Posts

Posted - 2008-11-07 : 05:04:19

thanks for the reply
but how can i set identity? alter table wont allow to add identity when i tried it

Hari Krishnan R K
techiebuddy.com

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-07 : 05:13:42

you cant modify a column to be identity column. Only workaround is to create another column which is identity and then rename it as your column after dropping yours.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources