Using T-SQL to programmatically edit and save a SSIS config file
-
I want to be able to edit a SSIS Config file for a different company, each time that I ran it.
Each time, we run the SSIS package, we modify the Company name in each of the Configuration Values
This is highlighted in the attached screenshot
Is there a way from T-SQL that this file can be read in and the Company Name on of the ConfigurationValue lines be updated and then the file re-saved?
-
U can try exploring the CLR assemblies feature of SQL. However not recommended to keep modifying the DTSConfig files programatically. OR another (kind of dirty) way
Write a SSIS package use a script task to modify the DTSCOnfig file...
Host a SQL job to invoke the SSIS package.
Call this SQL job from your SP or however you want to.
-
Thank you....so is it quite straight forward to create a script task that can modify the DTSconfig file?
-
It should be, since its just a XML file. You use .net c# script task to modify DTSConfig files, search for it - you will be able to find lot of help already.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply