February 6, 2019 at 4:56 am
Morning all.
Wonder if anyone can help. I've seen SSIS Packages set up so that you can configure the db and the connection for Live, and also configure the db and connection for DV/Test, so that you can quickly switch between environments.
I would like to set my SSIS Packages with the 3 different environments, to make ongoing development of the current and future ssis packages a lot easier to manage. However, I only saw this briefly, and didn't set it up myself, I am not that familiar with SSIS .
Could someone point me to some sort of tutorial. Not just to show me how to do it, but also get a better understanding of it.
Many Thanks
February 6, 2019 at 7:24 am
This would probably be a good place to start: SSIS Catalog
I've played with some of this, although not to setting up environments
February 6, 2019 at 7:48 am
I think this is the link you want:
https://docs.microsoft.com/en-us/sql/integration-services/lesson-1-4-adding-package-configurations?view=sql-server-2017
February 6, 2019 at 8:02 am
Lovely, thanks for your pointers
February 6, 2019 at 8:09 am
There's also an article on SSIS Catalog Environments in the Stairway to Integration Services article series.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply