DSXchange

You would tell what's what from the OLETYPE from what I recall. Somewhere out there I believe that someone (Kim?) posted all of them, perhaps a search would turn them up.

Or not. All such syntax is spelled out in the BASIC.pdf manual installed on your PC.

Good Point ..

Any idea what kind of file sizes IE can handle?

It depends on your source - in your case 'go for' sequential file definition.

Time to involve your official support provider, it seems.

Post your code.

Just read it like normal. Propogate the columns to the FTP stage. Supply the remote server's connection parameters.

What problem are you having? What is not working?

tech_savvy wrote:Thanks for your reply, The solution page U have given is not opening I think the page might have been expired.

The link is fine. You're probably logged in to 'dsxchange.com' and he linked to 'www.dsxchange.com'. Copy the link, paste it into the address bar and remove the www, see if it works then.

Not quite sure what you are asking. Either load the metadata for your source data if you are 'get'ing or your target data for a 'put'. And that just like in any other stage.

Why do you think you need that format? Parsers don't care, only people do. You have two choices with the stage: unformatted (aka 'one long line') or formatted as you've shown you are getting. We stick with unformatted out of the gate and only 'pretty' it when people need to look at it. For that, you...

Ah, missed the "for every record" part. I'd suggest a Sequence job with a looping construct, in that case. Read the file into a UserVariables stage, feed that into a loop that runs one of the two jobs. Lather, rinse, repeat.

Good, glad you got it all sorted out.

What kind of ideas do you need? As Nike would say - just do it.


Doesn't even need to be 'user defined' sql to do this.

Create a routine to read/cat the file, use a Routine Activity stage to run and return this TYPE value. Then triggers or a Nested Condition stage can handle the branching based on the value returned.

Server name and userid/password need to come first, right after the dsjob command - then all of the other stuff.