• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 660
  • Last Modified:

How To Decipher Package Data in sysssispackages Created by SQLS Server 2012 Import/Export Wizard

How can I decipher the packagedata field in the sysssispackages table in the msdb database? The packages were created to import Access 2010 database tables using the SQL Server 2012 Import/Export Wizard.
0
Chuck Wood
Asked:
Chuck Wood
  • 2
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
What you mean with "Decipher"?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
If you're talking about the PackageData column I think you can see it as html:
SELECT *, CAST(CAST([packagedata] as varbinary(max)) as xml)
FROM sysssispackages

Open in new window

0
 
Chuck WoodAuthor Commented:
That worked. Thank you very much.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now