Maybe you can try deleting from the command line. You can specify specific instances and specific features there.

Is this a homework assignment?

Hint: left outer join.

dwain.c (3/31/2014)

---

Now I'm just a project manager so I'm not expected to know anything technical about computers, judging by some of the project managers I've seen recruited out of business...

True dat 🙂

I have...

happycat59 (3/30/2014)

---

Environment variables are actually stored in the registry. So, exporting them using something like "regedt32" will give you a ".reg" file that you can save into source control.

The...

WTH?

The script doesn't mention sysadmin but database owner.

The created user doesn't have sysadmin permissions, so the table will be created using the default schema.

Points back please!

Did you try Google?

Come come, that's called continuous learning...

doug.brown (3/27/2014)

---

You could perhaps try using ReportItems. Have Table A with the results form dataset 1, and Table B with the results from dataset 2. These two tables...

nonghead-webspam (3/27/2014)

---

Koen Verbeeck (3/27/2014)

---

Delete all connection manager, create your new ones. Open up each task and component and reassign to the correct connection manager.

Run the package. If there's an error,...

Delete all connection manager, create your new ones. Open up each task and component and reassign to the correct connection manager.

Run the package. If there's an error, repeat the previous...

tlally (3/27/2014)

---

I recreated the package from the beginning new connection managers but I am still getting the same error.

The connection "{EFC6889A-D312-4A9E-B251-877C7A67B8DF}" is not found. This error is thrown by Connections...

GilaMonster (3/27/2014)

---

Yes, in vast majority of cases.

Heap has the forwarded records and the non-deallocation of pages to contend with,...

nonghead-webspam (3/27/2014)

---

What is the proper procedure when deleting stuff? What do I check for to make sure I don't take out too much or too little?

And, is there some...

Thanks. I do my best to keep ahead of you 😉