Tupacmoche
Registered User.
- Local time
- Today, 10:02
- Joined
- Apr 28, 2008
- Messages
- 291
SQL Masters,
When I open my solution and right click on SSIS packages I get a short cut menu 'Add Existing package' I have used this method to bring in packages. What, I need help with is when I have to bring in code that is in the File System. In SSMS -> Object Explorer Details when I right click on a Job and select 'steps' from the left hand options I can click on Edit on the bottom which opens the Job Step Properties. There on the bottom, I can see the package name when the 'Type' is SQL Server Integration Services Package' but when the type is Transact-SQL script, I simple see a window where SQL code has been added.
Now to the question: How do I copy this kind of package using the Add Copy of Existing Package into an SSIS container?:banghead:
When I open my solution and right click on SSIS packages I get a short cut menu 'Add Existing package' I have used this method to bring in packages. What, I need help with is when I have to bring in code that is in the File System. In SSMS -> Object Explorer Details when I right click on a Job and select 'steps' from the left hand options I can click on Edit on the bottom which opens the Job Step Properties. There on the bottom, I can see the package name when the 'Type' is SQL Server Integration Services Package' but when the type is Transact-SQL script, I simple see a window where SQL code has been added.
Now to the question: How do I copy this kind of package using the Add Copy of Existing Package into an SSIS container?:banghead: