SSIS :: Copy Data from source to Destination Using SSIS

Hi Experts,

I have two databases in  same server(sql server 2008). I need to copy only partial data
from some  around 20 tables in source and copy it to destination  tables  using SSIS.

Ex When emp table from source has 1000 rows i only need to copy 100 rows into destination emp table using a filter condition.  When using import & export wizard , i am not able to apply filters.
LVL 1
B_PatiAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
ValentinoVConnect With a Mentor BI ConsultantCommented:
Using that Import/Export wizard, you have the option to save the SSIS package that gets generated.  It's a checkbox in one of the last screens.  So save it, then open it in BIDS and customize the queries as per your requirements.

I've explained this method in more detail in the following article: Importing Excel Data Using Integration Services
0
 
Christopher GordonConnect With a Mentor Senior Developer AnalystCommented:
There may be an easier way to to this, but you could create a view for each table you want to copy; somthing like "select top 100 * from your table".  

Then use the view as the source in the import & export wizard instead of the table.
0
 
ValentinoVBI ConsultantCommented:
Would you mind explaining that B-grade?
Also see http://www.experts-exchange.com/help/viewHelpPage.jsp?helpPageID=26
0
 
B_PatiAuthor Commented:
Hi ,
I had to use Slowly changing Dimension transformation  Control to complete my task. The link you provided  helped me as a starting point.
0
 
ValentinoVBI ConsultantCommented:
Thanks for the feedback.  I fail to see how the SCD component would help you with your request, in fact I never use that component because it has some annoying limitations.  But okay, if you got it to work for your scenario, all the better!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.