asked
Rename Sql Server 2008 SSIS project
Hi, Sceanario: - There is an existing and running SSIS ETL project in the company for project X. - Another project Y started, which needs to perform the same SSIs ETL process - New Project Y has its own database in SSMS, some of the columns needs to be added and removed. Tasks and containers used in Project X a. Sequence container b. For Each Loop container c. Script Task d. Execute SQL Task e. File System Task f. Excute Package Task e. DataFlow Task Connection Manager Type a. OLEDB b. Flatfile c. SMTP Along with these, Parent/Child Configuration is used and Many Variables are used. Requirement: I need to use the ETL used for project X in project Y because both the projects need to import flatfiles from .zip folders into its respective database's tables in SSMs. Both projects have similar table structures. I want to copy the SSIS folder from project X to my machine and make some changes and make it work for project Y. What changes do I have to make ? and where are the renamings need to done ? Any suggestion is really appreciated. Thanks and Have a good one. Rgds, sqlhungry
I am pretty new to SSIS as well. I am looking forward to my virtual training class from Pragmatic Works coming up in April but I do know that you can create config files which I believe are just XML files that contain much of the information you referenced in your question. I am not sure if your current package has things configured that way or not. If not then you will have to open the file connection, database connection etc to make the changes in the new package.
You could try exporting the package from the SSIS pacckage store and saving it under a new name. You then open the file and make the changes you want to and save it as the new file, job done.
