June 10, 2004 at 11:02 am
What tables do I look in for metadata about DTS mappings ... jobs used in and last updated or last ran?
Is this a good query to get tables names and how would I adjust the query to get changed in last week?
select name from sysobjects where xtype = 'U' order by name
June 10, 2004 at 4:46 pm
What do you mean DTS mappings? DTS is structured data and stored in a binary object in the MSDB database in the DTS related tables. But you cannot get info that way from them. I am confused by your question.
June 11, 2004 at 12:09 pm
I've been fortunate enough to work with tools like informatica and SAPBW where the driving meta data for their DTS solution is stored in tables so impact analysis can be done in preparation for change using SQL. Is there another way to find out for example whick DTS Mappings touch a specific table, filed, or txt. For exampl ... I want to know all DTS Mappings that touch a file called MyGeneralLedgerBalances.
Perhaps I've been spoiled : ) with the other tools I've used for ETL (DWing)
Any reply is appreciated.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply