Skip to content

Instantly share code, notes, and snippets.

@kmoormann

kmoormann/InsertScriptFromSSISConfiguration.sql

Created September 10, 2012 23:25
Show Gist options
  • Save kmoormann/3694746 to your computer and use it in GitHub Desktop.
Save kmoormann/3694746 to your computer and use it in GitHub Desktop.
Download ZIP
INSERT INTO FOR SSIS Configurations
Raw
InsertScriptFromSSISConfiguration.sql
SELECT
'INSERT INTO [dbo.SSISConfig] '
+CHAR(10)+CHAR(13)+CHAR(9) + '([ConfigurationFilter]'
+CHAR(13)+CHAR(10)+CHAR(9) + ',[ConfiguredValue]'
+CHAR(13)+CHAR(10)+CHAR(9) + ',[PackagePath]'
+CHAR(13)+CHAR(10)+CHAR(9) + ',[ConfiguredValueType])'
+CHAR(13)+CHAR(10)+CHAR(9) + 'VALUES'
+CHAR(13)+CHAR(10)+CHAR(9) + '(N''' + ConfigurationFilter + ''''
+CHAR(13)+CHAR(10)+CHAR(9) + ',N'''+ConfiguredValue+''''
+CHAR(13)+CHAR(10)+CHAR(9) + ',N'''+ConfiguredValueType+''''
+CHAR(13)+CHAR(10)+CHAR(9) +')'
FROM dbo.SSISConfigurations
@DocMas
Copy link

DocMas commented Oct 8, 2012

SELECT
'INSERT INTO [dbo].[SSISConfigurations] '
+CHAR(10)+CHAR(13)+CHAR(9) + '([ConfigurationFilter]'
+CHAR(13)+CHAR(10)+CHAR(9) + ',[ConfiguredValue]'
+CHAR(13)+CHAR(10)+CHAR(9) + ',[PackagePath]'
+CHAR(13)+CHAR(10)+CHAR(9) + ',[ConfiguredValueType])'
+CHAR(13)+CHAR(10)+CHAR(9) + 'VALUES'
+CHAR(13)+CHAR(10)+CHAR(9) + '(N''' + ConfigurationFilter + ''''
+CHAR(13)+CHAR(10)+CHAR(9) + ',N'''+ConfiguredValue+''''
+CHAR(13)+CHAR(10)+CHAR(9) + ',N'''+PackagePath+''''
+CHAR(13)+CHAR(10)+CHAR(9) + ',N'''+ConfiguredValueType+''''
+CHAR(13)+CHAR(10)+CHAR(9) +')'
FROM dbo.SSISConfigurations

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment