DSXchange

Yes, you would create a custom routine and then use a Routine Activity stage in the last Sequence job to run it... first. Depending on what it returns, you either execute all the stuff you have in there now (whatever that is) or do nothing.

Obligatory Quote Warning

Please use the big orange Reply to topic link rather than Reply with quote unless you have an actual need to quote something you are replying to. It's at the bottom (and top) of every forum page.

Thank you. Helps cut down on the clean up costs.

An exact search here for "dsgetjobinfo" and/or "dsj.jobstatus" should turn up code samples you can steal as a starting point. :wink: For example, here. Cherry pick the parts out of that and/or other posts and put some effort into getting something together you think is close. Pos...

Just one routine at the start of the final Sequence. Look into the DSGetJobInfo function with an InfoType of DSJ.JOBSTATUS, one call for each of the previous four Sequence jobs. Each should return DSJS.RUNOK for the routine to pass back an "Ans" that you would check in the attached trigger...

And nuked again. It's a bot.

I mentioned all that in my post and just opened it up so it can be seen. Arun posted much the same information.

Well, that's... interesting. Nice job tracking that down! And thanks for posting the details.

You are assuming that what they posted exactly matches what they are actually doing... and we all know how often that's not the case.

I guess we shall see, however.

A) Wrong forum... moved here from the FAQ Discussion forum.
B) Took off and nuked it from orbit, it was the only way to be sure.



I can't ban the user but did remove the spammage.

raji33 wrote:i have used substring(convert(varchar, cast(processDate as date)),6,2) as MONTH to get month. so '09'.

A bit overly complicated, don't you think? I'm pretty sure you have a couple of cleaner options:

DATEPART()
MONTH()

Online documentation.

What happens when you try the other techniques mentioned - array notation or the use of Convert() rather than Trim()?

That's your version of VMWare.

Been discussed here quite a bit. Here is one example.

That's all I got. Don't do SQL Server.

I was wondering what the various options controlled and found this if you're curious. Looks like it may still generate inserts but do bulk loads 'under the covers'. In your shoes I'd enlist the aid of your DBA or official support provider to confirm.

As a crazy guess, any that mention "Bulk"... especially this one:

EnableBulkLoad=0

Set it to 1. The rest should be fine for the initial attempts.