Transfer SQL Server Objects

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Transfer SQL Server Objects

Transfer SQL Server Objects

Rate Topic

Display Mode

Topic Options

Author

Message

anjali.vishwakarma

Posted Thursday, May 21, 2009 11:22 PM

Valued Member

Group: General Forum Members
Last Login: Friday, September 16, 2011 3:37 AM
Points: 54, Visits: 148

We are using Transfer SQL Server Objects in SSIS Package for copying tables and data from one SQL server database to another database. We have 2 requirements:

1. We need to copy only some tables not all
2. Also for those tables we need to copy only some data depending on user input. for eg. if user selects A bank then we need to copy data only for that bank. Is this possible ? If yes how ? If no what is the other way of doing this ? Is this possible through SSIS ?

Post #721836

Eswin

Posted Friday, May 22, 2009 12:12 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 1:56 AM
Points: 1,593, Visits: 1,026

Anjali, if its only a one time requirement u can go with import and export wizard........

Tanx BigGrin

Post #721846

anjali.vishwakarma

Posted Friday, May 22, 2009 12:25 AM

Valued Member

Group: General Forum Members
Last Login: Friday, September 16, 2011 3:37 AM
Points: 54, Visits: 148

As I mentioned in 2nd point, we need to cpoy selective data depending on user input. So its going to be dynamic at runtime. Its not a one time process.

Post #721850

« Prev Topic | Next Topic »

Permissions