May 15, 2012

SSIS Template Generator and Reverse Engineering Part I


Today I started a new pet project to create an SSIS reverse engineering process the idea is to get any package and traverse it and extract the Package Profile or signature of that particular package, once that is done we can basically generate, modified, or executed the Package. Its been a challenge in creating a generic schema that will support most packages, after a few hours the below diagram represent a work in progress. I feel drain tomorrow I will add the File Metadata information, For Each loop and containers to the diagram, like always I am open to suggestions and ideas.



No comments:

Post a Comment

Contact Form

Name

Email *

Message *