DSXchange

As ArndW suggests, use custom sql with the date supplied as parameters. Something like

here date1 and date2 are parameters which are passed dynamically to this job.

Yea but then again, to dynamically change the meta data. Plus all that prework, thats a nightmare for the maintenance folks. Will need more than a couple of developers to support sucha beast. I dont know, i guess i will just have to push these guys to demand for a standard format until Hawk is reale...

Thanks Guys. I knew there was a halt somewhere. Just wanted to try my luck and get some advice.

Your server must be down. At the unix level, do a
ps -ef | grep dsrpc. See if it returns anything.

Yea, but isnt this dude sitting on windows?

Actually this is strange, a CHAR column with length 10 (for eg) will always result in 10 bytes when written to a fixed width file, regardless of the datatype of the source.

what is the length of you source and target?
You can stick a transformer in between and check for ISNULL and then explicity concatenate spaces.

Did you try && ?

I understand. But if you change the target to Char. It can handle decimal values. I am not too sure, but give it a shot.

How are you coding the password in the param file. Is it just simple text or encrypted? I think you are just passing text and must have specified Password as an encrypted field in your job properties. You need to pass encrypted password. If this mechanism works just like it does in unix (read params...

Specify it as char in you job itself. That should take care of it.

Here, reference thispost. Ray has a few options for you.

Are you sure you are passing the environment variable correctly to the jobs via the sequencer. Maybe a possiblity ?

Gotchya.

True. But if the OP wants the job to run regardless the earlier job is successful or failed. Then these three options should handle it. Right? Please correct me if i am wrong.