2 Comments for this entry

  • J

    I am trying to read the source and destination tables with connection strings to analyse how the data is being loaded to the system. Is there a script you have for this?


  • Sandra Erb

    Hi J,

    sorry for the delay…
    Unfortunately I don’t have a script to help you.
    To archive this you have to search through the XML Structure of your SSIS Package and find the source and destination tasks.
    For reference please have a look at the documentation of the DTSX package schema: https://msdn.microsoft.com/en-us/library/gg587789(v=sql.105).aspx

    For an OLE DB Task for example, you have to find the „Microsoft.OLEDBSource“ Task, get the „SqlCommand“ Attribute and analyse the SQL retrieved (assuming that your source task is using a SQL Statement rather than referencing a table).

Leave a Reply


    Twitter Tweets Powered By Weblizar


  • Back To Top