DSXchange

***How do i get a list of the filenames only*** That's in the blog I linked you to. Did you read it? :? You'll also need to fix your "file pattern" as it doesn't seem to be finding any files. As to your "one more thing" - you need to have all of the proper metadata / XPath Expre...

One or multiple files, doesn't make any difference. :? The details are in the blog I linked you too and they been posted here a bajillion times, search for them if you want to see what others are doing. All you should be delivering to the XML Input stage are the filenames and the stage should be set...

Well... you can't use the Sequential File stage to reliably read XML files. Follow the link to Ernie's blog and use the ESS to get a list of the filenames only and then set the XML Input stage to do the actual reading of the files. Works way more better. Almost as good as the Folder stage in a Serve...

I smell a pivot coming... but you need to answer Ray's questions before we go too much further.

What is your target? MMDDYYYY is not a DATE data type so you may in fact need something else, that or you may just need to substring off the date from the time.

What "wasn't successful" about your file pattern attempt? Switch to using an External Source stage as detailed here.

You still need to spell out your requirements for us. I took a guess, how about detailing what it really is?

Why not just use the IsValid function and see if it is a valid timestamp or not. Ah... Server... Ray Wurlod has a Server version freely available from his website, from what I recall.

Don't confuse the two - transaction size and array size are two different things. We're talking about the latter.

Excellent question and one I've already asked but we haven't heard back yet. I think that is what will straighten this out.

Tony, please start your own post and post the particulars of your problem, especially your ODBC entry if you think that's the problem.

How about you spell out your requirements in words for us rather than making people puzzle it out from your data? Examples are always important to have but they don't always stand well all on their lonesome. It looks like you need to find alpha character(s) and then repeat them with each single digi...

Your ODBC entry wouldn't control that part as far as I know, that would have to be an option in the actual stage you are using to connect. I've done this in Oracle via their native stages, no clue if you can do the same for SQL Server however.

If you have access to 8.1 (I don't) can you not answer this question yourself? Are you saying that you no longer see a 'Move to' option?

You can fix it, you know. Wrap them in "code" tags and use Preview until everything lines up nicely.