|
|
Browse by Tags
All Tags » T-SQL » XPath » XML » ssis (RSS)
-
A few weeks ago I published a blog entitled Collecting information about your SSIS packages which demonstrated a way that you could use T-SQL and XQuery to derive information about your SSIS packages. Since then I’ve made a few amendments to the script that accompanied that blog post as follows: New columns The collected data now includes the ...
-
Did you know that is is possible to read the contents of a SSIS package (i.e. a .dtsx file) from within SQL Server Management Studio (SSMS) using T-SQL? For example, take the following T-SQL snippet:
select cast(BulkColumn as XML)from openrowset(bulk 'C:\tmp\MyPkg.dtsx', single_blob) as pkgColumn;
It uses OPENROWSET ...
|
|
|
|