SSIS Package in Metadata?

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

pduplessis-723389 SSChampion Points: 10599 More actions · Answer 1

Uhmmmmm,

Nopes.

There are 2 ways you can save your package, to File System (generates a .dtsx file), or to SQL server.

There is a white paper that you may want to look at:

Rgs

~PD

bbrewer 62909 SSChasing Mays Points: 606 More actions · Answer 2

There is a tool that you can download free trial for.

it Captures metadata within a repository from Relational, SSRS, SSAS and SSIS and ties it all together to allow you

to perform impact analysis and search via a web portal.

You can also maintain and extend this metadata centrally via a collaboration feature in the portal.

There are also video demos on the website.

here's the link.