get table name and schema name of the source and destination in ssis package

All replies

• 

  

  0

  Sign in to vote

  How can I get table name and schema names of the source and destination in ssis package to insert into audit table....??

  Regards,

  Ramaraju

  ---

  RamarajuC

  • Merged by Katherine Xiong Wednesday, October 7, 2015 9:44 AM duplicate

  Tuesday, October 6, 2015 7:23 AM
• 

  

  0

  Sign in to vote

  You mean get details from within the package? Or get details from corresponding databases?

  If former you can parse the package code behind which is a XML for that

  see this similar example of extracting details from SSIS code

  http://social.technet.microsoft.com/wiki/contents/articles/26784.finding-ssis-packages-having-references-to-a-table-or-column.aspx

  ---

  Please Mark This As Answer if it solved your issue
  Please Vote This As Helpful if it helps to solve your issue
  Visakh
  ----------------------------
  My Wiki User Page
  My MSDN Page
  My Personal Blog
  My Facebook Page
  

  • Proposed as answer by Katherine Xiong Wednesday, October 7, 2015 9:45 AM
  • Marked as answer by Katherine Xiong Tuesday, October 20, 2015 8:21 AM

  Tuesday, October 6, 2015 7:35 AM
• 

  

  0

  Sign in to vote

  duplicate of

  https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6354d719-0565-4cac-86df-5631b1c0c42c/get-table-name-and-schema-name-of-the-source-and-destination-in-ssis-package?forum=sqlintegrationservice

  Please dont open multiple threads for same topic

  ---

  Please Mark This As Answer if it solved your issue
  Please Vote This As Helpful if it helps to solve your issue
  Visakh
  ----------------------------
  My Wiki User Page
  My MSDN Page
  My Personal Blog
  My Facebook Page
  

  Tuesday, October 6, 2015 8:06 AM