Post reply

Extract SSIS Package Metadata details

  • August 18, 2015 at 1:46 pm

    #398918

    Hello,

    SSIS package meta data information is needed to covert SSIS into a Stored Proc.

    100s of table mapping reside within SSIS, what tool/method would help to get those information so that they copied and pasted to SP to speed up efforts. Please help.

    Thanks for your time, Very much appreciated

  • August 18, 2015 at 2:18 pm

    #1820886

    I don't think you'll find any tool that will do that for you.

    The SSIS packages are stored as XML files with .DTSX extension. You can look through these files and maybe you'll see something that might be useful.

    Good luck.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • August 18, 2015 at 2:49 pm

    #1820892

    Thanks Alvin for the reply, appreciated

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

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