Ah. The always popular 'Build vs Buy' debate. The answer to which changes with every management change.

I supported the service desk software for a lot of years. I was...

Letron Brantley (1/12/2016)

---

JustMarie (1/11/2016)

---

To address the situation of gap fill or other re-run situations I use a parameter table.

One package to populate the parameters.

One package to pick up the parameters...

To address the situation of gap fill or other re-run situations I use a parameter table.

One package to populate the parameters.

One package to pick up the parameters and perform the...

OK - either I'm doing something way out of the ordinary or people aren't able to give me much help here.

I have tried going to a static drive for this...

Another use for the staging database is a way to see the extracted data when troubleshooting. It takes up space but it's an invaluable tool.

RonKyle - why won't you use...

Glad that I could help.

Another consideration would be to create desired data type variables for your constants and set them at the start of the process. Then you're only...

RonKyle (12/17/2015)

---

Correct me if I'm wrong but don't some data flow transformations change from set base processing to row based which is why they perform so poorly in comparison to...

I'm salaried with the expectation of 40 hours per week with the occasional extra time needed. Occasional. We're not on call nor are we business critical.

I'm lucky that...

Staging database and T-SQL for almost everything except for data movement.

It kind of makes SSIS a control flow system but it gives me maximum flexibility for checking out what's going...

First, welcome to SQL math. 😀

Second - have a read on the round function and the arguments available.

Third - have a look at data type precedence because this is going...

Please don't create duplicate posts. Put answers here

Thanks Lowell. I needed that kick out of the rut of 'how did I do this before?' to see how to best approach it here.

I went even further in...

ETL is ETL. It doesn't have to be to a data warehouse.

Merge can work but comes with overhead as do most things.

Source to staging. Perform your upsert commands....

Nice one to make us think about the use of datetime2 and precision. It's too much of a habit to use datetime after all these years.

There's far too many companies that want a senior level person with a lot of experience only to make an offer that is more in line with a junior level...