DSXchange

Hmmm... well, my gun is empty at this point as I'm not that familiar with ins and outs of SQL Server. Hopefully someone else can chime in. That or ping your official support provider and let us know what they have to add.

$ENV is valid in the Administrator when you define the variable for the Project. You then use $PROJDEF in your job, not $ENV.

You can't trim trailing spaces from a CHAR field. Make sure everything matches out to the full 10 characters on both sides of the lookup.

DSJ.JOBFULLSTAGELIST is a DSGetJobInfo option. Note the 'JOB' prefix which you are missing. Check the online help for the syntax if you are unsure.

Hmmm... a couple of points. That's not generated sql if it literally says 'select *' in it. Without any sort of conversion coming out of Oracle, that will select an internal Oracle numeric value AFAIK, so in my mind all bets are off with regards to what SQL Server will do to it. And you didn't post ...

Oracle will generate a TO_CHAR(YourField,'YYYY-MM-DD HH24:MI:SS') in your source SQL for a timestamp, what does SQL Server generate on the isert side? Regardless, I still don't see how it can get the year wrong. For one date.

ps. Thanks, I like tanks. Panzerkampfwagen VI Ausf. B, baby!

Check the documentation for the stage, I'll wager you'll find a TEXT field is not supported.

Yes, it will use whatever client libraries you have setup in your dsenv file, unless you override those Environment Variables in your job.

No, I don't see how that could be. Double-check that that is really what is happening. What is your derivation for the field? Generated or user-defined sql?

An 'upstream' UserVariables Activity stage can also be used to build a filename list and feed that to the Start Loop as a delimited list.

Welcome. :D What 7.x version? I'm guessing an early one if you have OCI8 stages. You'd need to upgrade to at least 7.5.1a to get a version of the OCI stage certified for Oracle 10g, 11 isn't officially supported but should work fine I would hope. Clients are 'forwards compatible' so older ones can c...

So... did you or did you not try what I suggested? Of course the error relates to the installation of the plugin, as noted part of that 'installation' is properly configuring the environment to support it. Un/reinstalling won't change anything and I have no idea what trying 'a different binary' mea...

Rather than the Folder, use a Sequential file stage - either with the Filter option or a before-job concatenation - to read all of the files.

Interesting, the problem seems to be AIX specific... or at least the patch is.

The question is specific to the client, so XP is supported as long as we're talking XP Pro. Home no, Pro yes.