March 11, 2011 at 3:18 pm
Hello
I have situation , where i have to find out how date is being populated into the tables, how to check which pacakage is being used for specific table. How can I do this, is ther any Sproc or query to find out.
March 11, 2011 at 10:24 pm
I think you asking if you can find out which SSIS package is inserting data? I don't know of any way to do that. You will most likely have to run a trace and then when you find the times of inserts, you can check your scheduled jobs and see if you isolate which package(s) are running at that time.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 14, 2011 at 1:26 am
Duplicate post.
More replies can be found here:
http://www.sqlservercentral.com/Forums/Topic1077220-391-1.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply