My good story is the system I'm still proud to have developed. It's a deceptively simple process - onboarding and offboarding employees.

I started this as part of a project back...

Sorry - didn't see you had more questions. :ermm:

You can put each data flow and file move into its own sequence container and add your precedence constraints so they happen...

I'm not associated with them in any way but Indeed.com is a really useful job aggregater. Keep track of which jobs you apply for since the same one can show...

GilaMonster (5/31/2016)

---

Well, it was.

Though the first one wasn't really a study area:

Do you have experience in...

You can have multiple connection managers and data flows in the package.

So in this case you have 4 connections - the source and the 3 targets.

Create 4 data flows and...

Remember that a CASE statement will terminate on the first true condition. So if you're trying to do multiple actions on the same value you're not going to do it...

It's a matter of breaking it down into component parts.

You need to get the year, month, and day out of the date value.

Then you need to combine those into a...

xsevensinzx (5/3/2016)

---

Hey guys,

Need some advice. I got a really good job offer recently to work at a company as a DBA. I'm currently a data architect that built and manages...

Brandie Tarvin (4/21/2016)

---

Eirikur Eiriksson (4/21/2016)

---

Brandie Tarvin (4/21/2016)

---

Luis Cazares (4/21/2016)

---

BLOB_EATER (4/21/2016)

---

Luis Cazares (4/21/2016)

---

Brandie Tarvin (4/21/2016)

---

Okay, this is weird. I went searching for an error I got in SSIS 2012 and the...

Can you see the 'Columns' option to the left on your data source? If so that's where you select the columns you want to pull into the data flow.

That doesn't sound fun but then again if it were you wouldn't be posting it here. 😛

Onward.

I've dealt with similar source files. An ugly but effective way to handle...

The overall answer is to look into the Merge command.

https://msdn.microsoft.com/en-us/library/bb510625.aspx?f=255&MSPPError=-2147217396

However this doesn't take into account the idea of slowly changing dimensions. Do you need to keep a history of the...

Look into dynamic SQL. That's how you pass database/table/field values into SQL statements.

Notepad ++ and the Poor Man's T-SQL Formatter. Change to use spaces instead of tabs. No one here has an excuse for trying to push ugly T-SQL.

One bit of advice. Work with your body shop to make sure that the repairs come under the amount where your insurance company...