DSXchange

And? I'm aware of that.

Putting a real email here probably wasn't something you meant to do, I redacted it. In your shoes I'd start by adding some 'bread crumbs', calls to DSLogInfo() for the values you are fetching to start the debugging process. Don't forget you are putting everything into a dynamic array which won't pre...

You've written it to a file. Use a sequence job to read the file and pass in the parameter and then schedule the sequence job. Or use a script and schedule the script.

adela.mihaela1 wrote:db_AGG_PBM_MEASURES,0: The system(sqlldr CONTROL=ora.12882.963259.0.ctl LOG=ora.12882.963259.0.log BAD=ora.12882.963259.0.log.bad SILENT=header PARFILE=ora.12882.963259.0.par) failed; see the log file for the Oracle specific message.

Emphasis mine. Have you checked the log, as noted?

And now we're on 'the right page'.

Since these were your first posts I had to guess what your version and O/S were. Feel free to edit your post if those are wrong.

To expand on that, compare the field value with a downcase'd version of the same field. If they are equal then you know it came in all lowercase.

Ah... I only have up through the 8.5 documentation that I can check locally.

I don't see anything in the documentation that indicates that the ODBC Connector supports reading SQL from a file. Unless someone here knows otherwise, time to involve your official support provider it would seem, see what they say your options are.

Can we start with an explanation of what "uses a PL_SQL CASE statement to apply the changes" means? Thanks. That and what settings you are using in the Connector.

... and exactly what settings are you using in the stage?

Interesting... you managed to not answer any of the questions I asked.

Define 'not working'... what happens? What error message(s) do you see? What settings are you using in the stage?

Fine... but start by fixing your use of the External Source stage then see of those are even an issue.

http://dsrealtime.wordpress.com/2007/12 ... -a-source/

Fortunately, you can see enough to solve your problem.

Your methods are crossed... the External Source stage should provide just the file name/path if you are using the URL option in the XML stage. This so the XML stage does the actual reading of the file.