browse: forums | FAQ

bytes

Hey there! Do you need Microsoft SQL Server help?

Get answers from our community of Microsoft SQL Server experts on BYTES! It's free.

Transfer data using SSIS

squashead

Newbie

Join Date: Mar 2007

Posts: 1

#1: Mar 24 '07

Hello,

I'm in the process of moving data from one database to another. Both are Microsoft sql 2005 databases. I planning on using SSIS to do this but have run into a problem. Since the source database uses int for its primary key and the destination database uses guid for its primary key how can I preserve relationships between tables.

I am fairly new to SSIS but feel comfortable with straight forward data transfer between tables. Any advice/help would be greatly appreciated.

Thanks for the help in advance.

« previous question | next question »

Similar Microsoft SQL Server bytes

Transfer file image datatype from SQL Server to Access OLE Object datatype (answers)
Bulk data transfer from csv file to Pervasive SQL (using .net framework 1.1) (answers)
how to convert clob to other data type ? (answers)
Import ASCII Data (answers)

/bytes/development

/bytes/it

/bytes/other

misc

Forums
Visit our community forums for general discussions and latest on Bytes

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 231,831 network members.