DSXchange

This happens due to the fact that you did not close the job properly via the designer. According to the server, that job is still accessed by someone else because it did not recieve a proper job close. All you need to do is go to the director, go to Job in the tool bar and choose "Cleanup resou...

Or you can also do it in the transformer stage. Get the max from the table, store it in a hash file and pass that value into the tranformer. Specify two stage variables var1 = IF (in.MAX=Var2) THEN Var1+1 ELSE in.MAX +1 var2 = in.MAX your key value will be var1 in the above code. i hope this helps c...

A job to check the connections can be made by the command you had mentioned

What does your stored procedure do? As said by Craig, you have Stored Procedure stage to call a stored procedure. The stage would require inputs and if you give an output from that stage you will need to provide the output columns. So that depends on the functionality of your stored proc. If you don...

You have to pay to see the Premium content.

OOps
i did not pay attention to that. i completely forgot weather it was a server or a px job.
Sorry Tito.
If your problem doesnt get resolved using stage variables, use the logic in my routine and transform that into a px routine. it will work.
Sorry once again guyz

Tito, I took out some time to work on your problem. I came up with a routine. I tested it with all the scenarios you listed in your first post. It works. Try it out and let me know InMonth = Arg1 ActMonth = Arg2 InMonth_Qtr1 = InMonth + 3 InMonth_Qtr2 = InMonth + 6 InMonth_Qtr3 = InMonth + 9 InMonth...

Got it Andrw. It was my mistake .. thanks anyways

Its nothing big.. A simple select
select * from table where tocurrency='usd'.
The only place where the '&' is present in the password.

I am loading from SQL server using ODBC EE stage and using it for Change Capture and the job is aborting saying " Unrecognized Argument : &"
I tried loading it into a peak stage using ODBC EE and Dynamic RDBMS stage as well. Straigt loads are working fine.
Any thoughts on this?

then your file is of fixed width format. do this, while importing the meta data, choose the fixed width option and in the columns, specify the column name and in the length specify the ( for ID specify 2, for name specify 10 and so on...). this should work, provided your file is truely fixed width. ...

I have a timestamp in the format Mar 10 2006.
I want to convert this into 200603 ( ie: YYYYMM).
Any suggestions?

open the file in a notepad, what delimitter do you see? do you even see any delimiter?

message = "" sender = "From:Data_Staqe_Dwetl2@appliedcard.com\n" message = message:"This is a test\n" Probably this is the piece you are getting your warning. I think you are Concatinating the message with " This is a test\n". Try this instead. message = &quo...

Check the nullability of the columns. Sometimes if one is nullable and the other is not, then usually warnings such as this are given too.