January 20, 2012 at 5:06 am
What would be the best way to get all the relevant information regarding database objects being used inside an SSIS package and insert that into a table? I have got a situation where I have to analyse around 100 SSIS packages and find out the DB objects(database,table,view,procedure,function,column) they are touching. I tried using xml source inside a data flow task but BIDS is not able to generate the XSD, says there are too many namespaces.
Please Help.
Thanks in advance.
MMA
January 20, 2012 at 5:09 am
I would like to add that I am not very comfortable with xml data and the xml task in SSIS.
January 20, 2012 at 5:29 am
This might not be an enjoyable task.
Where are the packages currently stored? If they're in the file system, you might be able to do some sort of wildcard text search within the actual DTSXs.
January 20, 2012 at 5:30 am
Also, is there any external configuration going on? If so, merely searching the packages is not enough, you'll also need to look in the config files/areas.
--edit: fix typo
January 20, 2012 at 10:30 am
You might look at:
This is where I started from. Word of warning, it aint pretty.. but it seems to work.
CEWII
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy