SSIS package name which updated table

1
votes

Please help me to get SSIS package details based table name.

Eg: I have a table A which is update based on ssis package. so i would like to name of that package.

Is there any query i can get it from back end.

2
sql-serverssisetlssis-2012
Can you post some code? – w0051977
you can get the package name as a audit column from the etl by using the pre-defined system variable - PackageName – Dheerendra
Dheerendra - i dont want to create any new packages. there are some packages scheduled already and i know the table name which loading from packages. i want to know the which package is loading from the table name – user7449410

2 Answers

1
votes

SSIS packages are basically just XML-files, so you can open it in some text editor and then use the editors Find-function to locate references to your table.

0
votes

If there is no Log files, or an audit table created to store these informations, you cannot find the package that updated a specific table.

There is a workaround that you can do, is to search the packages that contains the table name. if you are interested in this approach, you can read my answer @ Automate Version number Retrieval from .Dtsx files