tim laqua dot com Thoughts and Code from Tim Laqua

27Jun/080

Exporting SSIS Packages Stored on the Server (MSDB) to .DTSX (XML)

We wanted to export an SSIS package that was stored on the server in the msdb.dbo.sysdtspackages90 table to a .dtsx file so we could poke at it.

Here's what we came up with:

DECLARE @SQLcommand VARCHAR(MAX)
SET @SQLcommand = 
    'bcp "SELECT cast(cast(packagedata as varbinary(max)) as varchar(max)) 
     FROM msdb.dbo.sysdtspackages90 
     WHERE name=''PackageName''" queryout "c:\output.dtsx" -T -c'
EXEC xp_cmdshell @SQLcommand

Alternatively, you can just Export the package via SSMS ;-)

Tagged as: , , , , , No Comments
   

Social Networks

What I'm Doing...

Recent Posts

Tags

agent job amo analysis services autosuggest bi business intelligence calculated measure calculated member cube action database dtsx ecommerce elipsis excel excel 2007 Golf google grammar javascript mdx msdb mssql package pivot table polar rdl ReportingServices reporting services reports script sql sql server sql server 2005 sql server 2008 ssas ssis ssrs syntax highlighting t-sql table valued function tsql vbscript xml xmla xmlhttp

Bloggers of Note

Family

People who take my money

Categories

Archives