DSXchange

I am sorry. I forgot to copy these scripts to my thumb drive. Will do it tomorrow. You need to start with DataStageBackup.bat. Next you need to modify to dsimport.exe on the DataStageImporter.bat and dsexport.exe. (I think) You need to cd into the correct directory. Next you a list of jobs or DSX fi...

Thanks.

Cmd = 'SELECT DS_JOBS SAVING UNIQUE CATEGORY TO 3' execute Cmd capturing output loop while readnext CatName from 3 ... run genhtml job here ... repeat To run a job in job control then there is a drop down list of jobs. Pick the right and it will add the code needed to run this job.

I will post a couple of scripts soon which are based on the backup batch file DataStageBackup.bat. My current customer does not use Version Control. So I modified that script to load all DSX files in a directory. The Directory is the project name. It uses my current directory structure so you need t...

Download EtlStats.

By the way both DwNav and EtlStats can generate html reports on this metadata. DwNav has a save as html. EtlStats has a job called GenHtmlFromSql. Both html are nice and can be copied easily into spreadsheets.

I think it is really difficult to report on these while they are not in tables. I like to extract this ETL metadata into tables so I can write nice reports against this kind of metadata. Reporting either from DS_JOBOBJECTS or doc_tool.mdb and Reporting Assistant is not easy. DwNav was designed to na...

Here are my notes on Custom stages: ========================================= INSERT INTO DICT DS_JOBOBJECTS ( FIELD, CODE, EXP, NAME, FORMAT, SM, ASSOC ) VALUES ( 'CustomPropName', 'I', 'IF OLETYPE = "CCustomInput" THEN @RECORD<14> ELSE ""', 'CustomPropName', '40L', ...

Requires these dictionary items: INSERT INTO DICT DS_JOBOBJECTS ( FIELD, CODE, EXP, NAME, FORMAT, SM ) VALUES ( 'OdbcSqlType', 'I', 'IF OLETYPE = "CODBCOutput" THEN @RECORD<75> : (IF @RECORD<75> = "1" THEN " Generated" ELSE (IF @RECORD<75> = "2&...

The jobs in EtlStats are: LoadEtlMdProperty LoadEtlMdProperty2 LoadEtlMdTable SELECT DS_JOBOBJECTS.NAME as LinkName, DS_JOBS.NAME as JobName, DS_JOBOBJECTS.OdbcTableNames, DS_JOBOBJECTS.OdbcAction FROM DS_JOBOBJECTS, DS_JOBS WHERE OBJIDNO = JOBNO and DS_JOBS.CATEGORY LIKE 'Production%' and DS_JOBOBJ...

Here are a few:

http://www.dsxchange.com/viewtopic.php?t=99543
http://www.dsxchange.com/viewtopic.php?t=100201
http://www.dsxchange.com/viewtopic.php?t=91211
http://www.dsxchange.com/viewtopic.php?t=90303
http://www.dsxchange.com/viewtopic.php?t=99349

I prefer the last one.

There are several SQL statements which I have posted which should give you this. They are all based on stage types. Most of the plugins use custom stage types. The metadata is consistent across these. I have several jobs included in EtlStats which can extract this information and load it into tables...

You need to include them on the emails. They should open tickets and make sure each failure is addressed and being worked. They should alos make sure these tickets get closed at some point. Why should they trust you that all issues are being handled? You do not trust or need them. Your attitiude nee...

The problem with FTP is it is hard to trap errors. I would use rsh or rexec to remotely execute the command. There are secure shell versions of these commands as well. You can trap the errors better.

We can't wait 6 months or a year before version 8 is running at our site.