dmj120 (1/20/2015)

---

First, hello!! 🙂 I hope this is the right place to post such a beginner question. I am a complete novice, at best, but really like sql/php/et...

JoshDBGuy (1/20/2015)

---

Phil Parkin (1/20/2015)

---

JoshDBGuy (1/20/2015)

---

I inherited an environment with a SQL Server 2014 environment. It looks like they installed 2014 SSIS concurrently with 2012, leaving both services on the box....

Sorry but I don't have a clue – I did not know that was even possible!

JoshDBGuy (1/20/2015)

---

I inherited an environment with a SQL Server 2014 environment. It looks like they installed 2014 SSIS concurrently with 2012, leaving both services on the box. They then deactivated...

Koen Verbeeck (1/20/2015)

---

Phil Parkin (1/20/2015)

---

For a bit...

For a bit of balance, have a...

Jay Sapani (1/20/2015)

---

The Tables Are Related To Each Other As 1st Table Has List Of Employee And Other The Department In Which They Work.MapPerID = PersonID Of First Table.MapGrp =...

Jay Sapani (1/20/2015)

---

I Have 2 Different Table As Follows

Table 1 - Person

With Columns PersonID,PersonGrp,PersonName

1,'',Person1

2,Grp1,Person2

3,Grp1,Person3

4,Grp2,Person4

5,Grp2,Person5

6,'',Person6

7,'',Person7

Table 2 - PersonMap

With Columns MapID,MapDepartment,MapGrp,MapPerID,DateFrom,DateTo

1,'ADMIN',,1,'01-JAN-2007',''

2,'MGMT',Grp1,,'01-JAN-2007','31-DEC-2008'

3,'MGMT',Grp2,,'01-JAN-2009',''

4,'OTHER',,,'01-JAN-2007',''

Required Output

PersonID,MapID,MapDepartment,DateFrom,DateTo

1,1,'ADMIN','01-JAN-2007',''

2,2,'MGMT','01-JAN-2007','31-DEC-2008'

2,4,'OTHER','01-JAN-2009',''

3,2,'MGMT','01-JAN-2007','31-DEC-2008'

3,4,'OTHER','01-JAN-2009',''

4,2,'MGMT','01-JAN-2009',''

5,2,'MGMT','01-JAN-2009',''

6,4,'OTHER','01-JAN-2007',''

7,4,'OTHER','01-JAN-2007',''

Please Help With Query To Achieve Them Same

WithOut Temp Shifting and...

And I'll be interested to hear which 'imaginary' column names you come up with 🙂

I hope that this was a test migration rather than a "fingers-crossed-and-hope-for-the-best" migration;-)

We had some performance problems too. You may find this thread interesting. Or at least relevant.

I have not...

I don't understand much of what you have written, but perhaps this helps?

http://msdn.microsoft.com/en-us/library/bb934498.aspx

carpay (1/17/2015)

---

hi, I'm having trouble to use the Package Configuration Wizard. The first time using is OK (that is I can configure-save-run it as a was used to in VS2008...

J0shu@ (1/16/2015)

---

Hey Nevyn,

A higher level question with regards to implementation strategy. When implementing a SSIS package, should the priority of process be put on the SSIS side as much as...

J0shu@ (1/16/2015)

---

Hello Phil,

I am working on the alterations suggested by Nevyn. The folder descriptions are integer ID's, incrementing from 1~2500. Also, each folder has 200 files which are also integer...

Nevyn has provided you with some good advice here, I agree with everything he has written. I'm sure that we can find you some links on setting up parallel FELs...