Reported as spam

reported as spam

Phil Parkin (9/30/2016)

---

quinn.jay (9/30/2016)

---

John Rowan (9/30/2016)

---

All you need are the .dtsx files. If you need to open them in a solution for editing, create a new project in Visual...

Again, I'm not sure why you think you need to move a solution. All you need are the .dtsx files. Move those to a network location where you...

The solution files are only needed for development. Once you've built the package into it's .dtsx file, the solution is really not needed. Your job is not calling...

Jeff Moden (9/20/2016)

---

John Rowan (9/20/2016)

---

Old people should not be allowed to...

Borrowing from Alan's example, the same thing can be done w/o the split function. The split may be faster on huge datasets, but I think just using CROSS APPLY...

I'd go ahead an put a Role dimension in the model. Load it up with the valid roles and add a RoleID column in your fact table. Create...

Old people should not be allowed to write SQL code...:-D

I've been doing this for a long time, crazy that I've never seen this before. Of course, I always use aliases so maybe my good coding practices have just...

Yes. If you can do this on the physical tables, great. Otherwise, use a Named Query in the DSV to create these columns.

I would create your date dimension with an integer key (clustered primary index) with the integer date value for that day. For example, today's key value would be 20160629....

Nope, just one will do! Each date dimension attribute becomes it's own hierarchy by default, but you can create custom hierarchies in the dimension designer. Just drag &...

I run into poorly formatted files on a fairly regularly when trying to consume external files via SSIS. My first choice is always to see if the source system...

Yes, use precedence constraints to handle the first part of your requirements. As far as the second part, whether or not your package has run this month, you'll have...