Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Transfer SQL Server Objects Expand / Collapse
Author
Message
Posted Thursday, May 21, 2009 11:22 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued 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
Posted Friday, May 22, 2009 12:12 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, October 28, 2013 8:50 AM
Points: 1,607, Visits: 1,039
Anjali, if its only a one time requirement u can go with import and export wizard........



Tanx
Post #721846
Posted Friday, May 22, 2009 12:25 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued 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 »

Add to briefcase

Permissions Expand / Collapse