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.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
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
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply