DSXchange

What in the world............ Who is this person, We need Walter....

If you load your flat file into a temp table then you can get everything done in a single query. i.e, a single database stage.

Did you remove the quotes from the Date?

If thats the case then yes, send in bad data and keep your warn limit low. This way within just a few warnings the job will abort.

chandankambli wrote:
Pls. explain.

Pls. search.
There are a lot of topics on this discussion. You will also find sample scripts to execute jobs via scripts.

NOt in the sequence job. In your px job.
Go to the job properties and convert both of these parameters to string type. Atleast for the date.

How have you defined them in the job. Are they defined as string or , date and integer. If latter then remove the quotes. If they are defined as string then quotes wouldnt hurt. They will be passed along with quotes.

you sure there are only two lines in your source file. The first one is the date and the second one is the id. Nothing else is present. I just built a dummy job and tested out the same. It works like a charm for me. Do you have the first line as Column Names in your text file?

I was thinking the same. Not only the IT folks had to be smart but physically fit as well.

Ok, for o_date provide



For the t_id provide


This should work.

Kim has something like that which can tell you what table is being used up. Search this forum for etlstats.

Ok now you tell me that they are coming from the same file. I thought you wanted to keep one file per parameter value. How does it look like in the file? Also tell me which parameter value belongs to what parameter.

Is that your derivation. Use the Field() function code that i posted earlier to get everything before the @FM.

What is the derivation you are providing inside the jobactivity for your parameter. Also what is the name of your execute command stage. Copy paste them here.

Some memory huh craig. You guys sound like my college professors. Even they used to talk about those days with so much intensity.