DSXchange

Yup. Like this post for instance.

With your id, try to manually create a table and insert a single record via command line. See if that works?

I know in server you do
Incolumn[3,5]. Not sure if that works in a PX transformer. Someone else here needs to confirm that.

What about a character return value. Try returning True or False. See if that helps. This is really odd. The jobstatus and the return code are two seperate codes and mutually exclusive and will/should not affect each other.

Now now, dont go run all over him

Write to a different file the second time and then use a link collector to collect the two files.

Substring wont. Agreed. But if the target is a database with char field it will fill in spaces to honour the length.

Do a google on SQL7008. At some places it says you need to jounal a couple of enteries and at some places it says commit more often. Investigate into it.

Need more info,
HOw are you calling the stored procedure, STP stage of odbc stage?
What type of parameter are you specifying while importing the stored procedure?

You can specify the timeout in the wait for file activity stage. This way your job doesnt have to wait for an indefinate period of time.

Ofcourse you can. Look at the filter option in the sequential file stage, or you can even get it done as a before job subroutine by ExecSH and typing your unzip command there.

look into the Collasce function. You can use that in the where predicates. I might be off by a word or two in the name of the function. I have used that before in my sql queries. What it basicaly does is checks if the key is null, it will replace it with a default value that you specify. The format ...

I agree totally with Kim. We have our top posters, very well experienced in this field, to fill in the blanks or even correct us. Thats one reason I always come back and recheck my answers. And i have been corrected so many times, only to my and the dsxchange user's benefit. And we should welcome an...

I think thats an excellent idea. This way a person can go to those topics which were solved before hitting the other ones, that get returned during a search.

Actually, if you are using unix commands then you might as well use the unix uniq command to remove duplicates.
Another question, why are you using aggregator to remove duplicates, why not just pass the input through a hashed file?