Post reply

System table for source and destination column mappings

  • September 17, 2010 at 10:09 am

    #145189

    Hi

    Does anybody know into which system table does SSIS store the source and destination column mappings of a dataflow task.

    Any help would be highly appreciated.

    Thanks

  • September 17, 2010 at 10:31 am

    #1223167

    I don't believe that SSIS uses systems tables for storing such information. The information should be stored inside the package itself.


    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]

  • September 17, 2010 at 10:50 am

    #1223191

    I would have to aggree, the metadata would be part of the SSIS package. I'm also assuming that you're talking about SQL Server in this case. You have to remember that the data flow utilizes a variety of data sources, ranging from flat file connections to OLE DB connections. So connection types affect this situation as well.

    😀

  • September 17, 2010 at 10:57 am

    #1223200

    Thanks for the replies.

    But is there a way I can get the mappings for the source and destination columns or dataflow task. I just have NATIVE SQL OLEBD connections.

    Thanks for ur help.

  • September 17, 2010 at 11:02 am

    #1223206

    The mappings are not stored in SQL. They're stored in the package file itself.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 5 posts - 1 through 4 (of 4 total)

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