Creating SSIS packages with SQL Server Business Intelligence Dev Studio
Posted on 2014-02-03
I am working on developing an SSIS package that will grab data from a number of views on a source database and copy that data to destination server, truncating the destination tables and inserting new data from source database views.
For that purpose I used Business Intelligance Studio to create an Integration Services Project and then I added SSIS Import/Export wizard.
I have a couple of questions:
1) Is using wizard the best way for my purpose?
2) When creating the SSIS package, I use my development machine but later will need to put this package on two different servers: QA server and production. How do i go about doing that?
3) When moving package from my development machine onto a QA server and then to production server, the name of the source and target databases will change. How do I handle the change?
What I mean is on my dev machine, while developing the package, for test purposes I use "server1" as source server name and "localost" as the target server name, but on my QA server I will need to use "Server03" as the source server name and "ServerQA" as the target server. And on Production server the names will also differ. Hope my explanations are clear. How do I modify the names in my SSIS package?