True, while the string test here is interesting, it's real JSON data that will make it (or not) relevant. I'm thinking integration services, message broker etc. that could make a...

MMh... It depends what you are trying to do really. If you want to treat this as the same product but just track it as SCD2 then you need to...

While I agree about the overall sentiment, I think that there should be an automatic flag to set threads to R/O from the system then. Say, if last activity on...

Your powers of observation are quite strong despite the look of your profile pic ;).

I was commenting on the old post about the need to troubleshoot and debut packages remotely...

You should look into SSIS configuration files. they are simple XML files. This way you can have prod and dev configurations that you substitute based on the environment where you...

Hi there,

No I haven't been able to solve it in an ideal way. My solution was to force the use of the old driver in SSIS 2008 (ie use the...

Hi there,

Ok so I've dug up the XML code in the dtsx and here';s what I've found. The issue is that the new OLE DB Command ends up at the...

Sorry, I did not get the 2000 thing (hard to believe it's still out there so much 😉

Anyway, I'm not too familiar with DTS in terms of performance, even though...

Thanks for the info, I'll check it out 🙂

Hi,

For the extraction part, for pure speed purposes, you could try a simple SSIS package that exports the required data from your source DB to a Raw File and then...

Agreed. It should be much simpler to achieve these kinds of results. Right now I annotate but don't format in any special way because of these issues.

I'll give it a look, thanks!

Hi,

Thanks for the answers. What I was doing was that at the end of my package I call sp_updateextendedproperty to update the table's last ETL load. I just liked having...

Well, then I'd just use the actual datetime values instead probably 🙂

Like I said I think that the most important part of to have something that scales relatively well and...

I think this article shows very well that there are many ways to get to a result, each with their own advantages and inconvenients :).

And this is no surprise 😉