DSXchange

I support your "no" decision 100%.

The Folder stage doesn't support sub-folders. Regardless, in my opinion it is best to stick with the UNIX command approach in a User Variables Activity stage feeding a Start/End Loop sequence job. Your modification time filter may need to be post-list as I don't recall a way to directly compare it t...

Sounds like your FTP process is stripping any trailing spaces from each record. See if a 'binary' transfer helps preserve them.

OK, it has been sent. Enjoy. Please understand several things about this - first and foremost I'm not going to provide any support for it, I've already got enough on my plate without adding that to my resume, thankyouverymuch. :wink: Also note that while it was written in 2003 it worked well for me ...

Well, here we are in Server Town now.

dr.murthy wrote:when i give the constraint to reject link its loading the rejected records into file and throwing the same warning

That's how it works, the warning is always logged.

jerome_rajan wrote:You can use the oracle connector within a parallel container in your server job

I think you've got that backwards.

And what boat would that be? Best to start your own post and detail out the issue you are having.

There is no modifiable default for things like this.

Well, at its heart that is basically a vertical pivot of rows to columns. Clarify for us your "output format" is destined for what - a flat file, a table? That would drive the post-pivot shenanigans you'd need, it seems to me.

No, don't include the PK in the metadata or (I assume) it will want to bind an input column to it - and you won't have one. Your example insert should be pretty close to the mark.

I'm an Oracle person but don't you need to use custom SQL and include a call to newid() in there for that column?

Using dsjob with the -jobinfo option will (among other things) tell you if it is running or not.

I would suggest using the Contact links above to ping 'MembershipDirector' and/or 'Editor' for that.

Send me a PM with your email address...

Those ORA-00600 errors can be nasty. Involve your Oracle DBA, have them trace your session or see what is in their alert logs. Any other ORA errors logged with it?