DSXchange

Please post examples of both - that which works and that which does not. Another option for 'dropping' a record that doesn't match any other link is a Reject link, or a link with a simple constraint that equates to that to avoid the warning a Reject link logs.

That happy man is "C:D".

Why the 'requirement'? What problem are you facing, if any?

I believe that the Oracle stage will have 'closed' and any locks released by the time you get to your after-job subroutine. You should be able to verify this from the logs by looking for a 'Finishing...' message from the stage before your after-job subroutine is called and the error is logged. Talk ...

Sorry, don't know anyone personally that has installed SP3, work or home. I've heard of some gamers online taking the plunge and their experiences seem to have ranged from complete chaos to no issues whatsoever.

As noted in the first reply.

Which I clarified. His 'not in server jobs' comment was specific to the mention of a drop down list which does not exist in Server, not that you can't use a tab delimited file.

You can check before or after job for zero records and then decide what you need to do. That 'before' or 'after' could be in the job itself or outside the job leveraging a Sequence job. You could use a routine that checks the file size itself, or one that checks for the number of records written to ...

No, of course it can. It's just that there's no drop-down select list, you need to (gasp) type in the decimal value or the actual delimiter.

pxraja wrote:I want to know whether the conversion of the field in constraint will work or not.

If done properly, sure.

Wow.

One 'if'. 'And' not 'Or'.

Was wondering when that was going to come up. Can the ODBC 'text' driver be made to work for that or do you need to purchase one specifically for Excel?

No, can't say that I have.

I know... small joke as that's usually the first piece of advice we see from you when someone asks this question.

Sounds like the Windows XP Service Pack 2 problem. If indeed you are running SP2 on your PC then you need to contact your support provider for the patch.