Storing XML Config files in SSIS

Question

Storing XML Config files in SSIS

mcfarlandparkway

SSCertifiable

Points: 7699
More actions
September 28, 2016 at 7:14 am

#400795

I am new to SSIS,Need some ideas and thoughts of creating XML configuration (dts config) file (Common file) one SSIS package should have capability to load into it.
Researching like how do we store in SSIS database?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246962 More actions · Answer 1

mcfarlandparkway (9/28/2016)
I am new to SSIS,Need some ideas and thoughts of creating XML configuration (dts config) file (Common file) one SSIS package should have capability to load into it.
Researching like how do we store in SSIS database?

Assuming you are using a recent version of SQL Server, XML config files are no longer required. Have a look here[/url] to start getting acquainted with SSISDB environments.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Umer Akram SSC-Insane Points: 22209 More actions · Answer 2

+1 Phil, nice reflexes

was about to share the same thing 🙂

JustMarie SSCertifiable Points: 7771 More actions · Answer 3

Using the SSISDB catalog requires project level deployment. That's something to consider when researching this. For companies that have been doing package level deployment for years this is going to be a major change and may not be a welcome change.

My company uses Control M to batch jobs. That requires config files. Moving to the catalog isn't an option. So config files are created and put into source control.

Phil Parkin SSC Guru Points: 246962 More actions · Answer 4

My company uses Control M to batch jobs. That requires config files. Moving to the catalog isn't an option.

I'm interested. Can you explain why, please, in a bit more detail?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Umer Akram SSC-Insane Points: 22209 More actions · Answer 5

JustMarie (9/28/2016)
Using the SSISDB catalog requires project level deployment. That's something to consider when researching this. For companies that have been doing package level deployment for years this is going to be a major change and may not be a welcome change.
My company uses Control M to batch jobs. That requires config files. Moving to the catalog isn't an option. So config files are created and put into source control.

There are two type of configuration used by SSIS

1. Direct (hard-coded) XML file path configuration.

2. Indirect Configuration (Environmental Variable).

Both have pros and cons and have deployment related issues. Its better to understand them before proceeding further.

Following link contain details understanding for both:

Deploying SSIS Packages with XML Configurations[/url]

Indirect VS Direct configuration

Is it possible to avoid XML config files and still use package configuration in SSIS?

JustMarie SSCertifiable Points: 7771 More actions · Answer 6

Phil Parkin (9/28/2016)
My company uses Control M to batch jobs. That requires config files. Moving to the catalog isn't an option.
I'm interested. Can you explain why, please, in a bit more detail?

It's the standard answer we've all come to know and love. "That's the way we do it."

I'm not in the technology group and I'm not a DBA. So I follow the rules they set up and don't question too much. SQL server is a relative newcomer here with DB2 being rather prevalent so that may have something to do with the lack of buy in for SQL Agent jobs.

Phil Parkin SSC Guru Points: 246962 More actions · Answer 7

JustMarie (10/3/2016)
Phil Parkin (9/28/2016)
My company uses Control M to batch jobs. That requires config files. Moving to the catalog isn't an option.
I'm interested. Can you explain why, please, in a bit more detail?
It's the standard answer we've all come to know and love. "That's the way we do it."
I'm not in the technology group and I'm not a DBA. So I follow the rules they set up and don't question too much. SQL server is a relative newcomer here with DB2 being rather prevalent so that may have something to do with the lack of buy in for SQL Agent jobs.

Understood. I thought maybe there was a 'technical reason' ... which I was getting ready to debunk 🙂

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin