DSXchange

Dang, too slow.

You are missing Arnd's rather fundamental point that dates in a relational database are not stored with any "format" at all. This talk about "mm/dd/yyyy" is only applicable on output, the external format, what you want the date to look like after you pull it from the database. So all this "I need a ...

Oh, didn't notice you were doing something odd like that. Looks like you'll need to make two passes through the data or perhaps make some creative use of the aggregator for this.

Rows to columns? Sure, that is a "vertical pivot" and you can get information on how to perform one if you search the forums using that phrase.

I have the 7.5.3 media but don't have it installed yet, we're still on 7.5.1A. Couldn't find any mention of this in the ReadMe but not sure that means much of anything.

FAQ posting on that subject:

http://www.dsxchange.com/viewtopic.php?t=88639

Compare what - the tables themselves? The content? And as noted, please be more specific what 'compare' means.

You can. What 'more info' do you need?

What about 7.5.3? Does it restore it?

You didn't state what problem you are facing when you use more than 4.

Ah... I see that now.

Please explain what "remove duplicates more than 1 column" means.

The problem is figuring out what happens when the stored procedure sends back either a "fail" or a "good to go" response. If the response is good to go then I need to parse the rows from the file. Will I be able to go to the stored proc and then process results in a Transformer and then revert back...

In your shoes (even though now I know they probably wouldn't be my style) I'd build a Looping Sequence to do this rather than fight with the Folder stage, especially if the files are of any size. The Folder stage has a well known problem with 'large' files and will tend to fall over dead if the con...

Then time to mark your post as Resolved it seems. Big button at the top of the screen.