DSXchange

I have an issue where I need to execute 1 or more instances of a job based on the results of a query to a config table. All SQL queries must utilize the ODBC stage. The config table contains simply TableName Text (sample data) Table1 Text1 Table2 Text2 I need to perform the following select tablenam...

I used this to install qsrtmngr as a service.......note this applies to releases prior to 7.5, where a Windows service does not exist.....

http://support.microsoft.com/kb/137890

Unfortunately I am using QS 7.0 - the installation of a Windows service must have been a feature introduced in 7.5.

How do I implement qsrtmngr.exe to run as a service? Obviously under Windows it is not practical to have to keep a session logged in just to run this daemon.....

Thanks - my problem was that I did not actually specify connection info for the db. Create DDL was greyed out until then.

SQL Server - I purposefully left this off as I figured it would be a generic solution for any ODBC source.....

I have a Job that simply Reads file, transforms, writes file. I want to write to a database table (that does not yet exist) that exactly matches the file. I swapped the target out with an ODBC stage and all mappings are retained, of course. What is the fastest way to get the table created? It is not...

How would I then exectue a series of truncate table and insert statements in a job?

Can I execute a standalone SQL statement in an ODBC stage without having to attach a dummy transform stage?

Or is the preferred (and only) approach to utilize a Stored Procedure stage?

Accidentally put this in the General Forum previously.... Our provider sends up to 300 files in a batch to be processed...I have a job that processes a single file, but calling it 300 times linearly takes forever due to the DataStage job control overhead. I need to kick off 300 instances of the same...

Our provider sends up to 300 files in a batch to be processed...I have a job that processes a single file, but calling it 300 times linearly takes forever due to the DataStage job control overhead. I need to kick off 300 instances of the same job (utilizing the filename as a parameter) simultaneousl...

I have a pipe-delimited Sequential File coming in that occasionally has rows truncated. It should have 3 columns, but sometimes the rows are truncated as below - this is an external provider file and we do not have control over it. key1|10|text key2|20|text key3| key4|40|text In this case the proces...