DSXchange

Still... there's no reason to go find it as the location is well known - your scratch area specified in the job's config file.

For whatever this is worth, here's what under the Help button:

"Select Use OS level authentication to automatically log on using your operating system user name and password. It is cleared by default. For further details on Oracle login information, see your Oracle documentation."

Ah... I tend to forget about that option for some reason.

I'm curious if anyone has been successful reading an NTEXT column via the ODBC Enterprise stage on UNIX from a SQL Server database. :? I can manage this in a Server job but it throws a "metadata mismatch" warning because I have to declare the column as LongVarChar rather than the LongNVarc...

PhilHibbs wrote:

Code: Select all

ls -m

That returns a list of file names with a comma at the end of each, but one file name per line, and the StartLoop stage just takes the first line and ignores the rest.

It *is* documented, not sure why anyone should have to "send" it to you.

How many different variations in the source? For a small enough variation, I would just build multiple jobs rather than burning too many braincells 'over-engineering' this. My 2c.

You can't, really. Have you looked into the -file option?

You need to "source" dsenv before-hand to set the environment.

I believe it's actually the "m" option that gives you the commas, "man ls" should confirm or deny. Or you could convert @FM in the list to commas.

Lastly, an exact search for "ParamValue/Limitvalue is not appropriate" will explain what your -4 problem is all about.

Sounds like a question for your official support provider.

What is your 'transaction isolation' setting in the stage? Actually, is there such a setting in the ODBC stage? There are in Oracle stages but not certain re: ODBC. Perhaps it is in the dns entry you created, compare it on this machine to your 'another machine' where it does work.

Not sure what you're asking. You should be able to use something from User Variables as the Invocation ID... did you actually try it or did you just assume you couldn't?

Did you install VS 2003 or 2005? From what people have posted here, only 2003 works with your version I do believe.

The 'where' would be wherever your config designates as 'scratch' space. As for 'how' it's just a plain old text file.