GilaMonster (12/10/2015)

---

No, we're not. We don't have the rigour, the formality, the adherence to standards that characterises engineering disciplines. The scientific method is not 'try stuff at random until something...

SQL 2008 is a bit different....

Create a parameter in each of the child packages for the connection string. When the master package calls the child packages, have it pass the connection string to the parameter...

Is this an old package that used to work or a new one that has not worked yet?

When a package works correctly when run manually, but doesn't work correctly when...

; is a statement terminator. It belongs at the end of a statement, not the beginning!

Luis Cazares (12/2/2015)

---

GilaMonster (12/2/2015)

---

We can compensate for badly written code with more badly written code. Excellent plan.

Correctly terminate all statements with a semicolon (they're statement terminators). The end.

If someone...

As I read this thread, I can't help but think about the question of the day, Fun with qualifiers.

That's a good example of something to avoid. 🙂

demin99 (11/26/2015)

---

Hi All,

We have an excel file which changes every week.Weekly data will be added to each column in excel every week. I am trying to load the data to...

Phil Parkin (12/1/2015)

---

It's not a scenario I've had to deal with. However, I would have expected it to run just fine, assuming you have the connection string to the new...

GilaMonster (12/1/2015)

---

Me: Execution plans please

OP: You can use AdventureWorks2012

Well, yes I could, if I had it installed on the machine that I'm currently using (which I don't). Or I can...

Lynn Pettis (11/30/2015)

---

Lynn Pettis (11/30/2015)

---

Alvin Ramard (11/30/2015)

---

Lynn Pettis (11/30/2015)

---

Pulling hen's teeth, but based on what little detail you have been willing to provide, does the following help?

create table dbo.FirstTable(

...

What is the version of the server you are trying to run the package on? Is this the same server as before the upgrade?

If the package is a SQL 2005...

Lynn Pettis (11/30/2015)

---

Alvin Ramard (11/30/2015)

---

Lynn Pettis (11/30/2015)

---

Pulling hen's teeth, but based on what little detail you have been willing to provide, does the following help?

create table dbo.FirstTable(

...

Lynn Pettis (11/30/2015)

---

Pulling hen's teeth, but based on what little detail you have been willing to provide, does the following help?

create table dbo.FirstTable(

ColA int,

...

Lynn Pettis (11/30/2015)

---

Alvin Ramard (11/30/2015)

---

Sean Lange (11/30/2015)

---

Yeah...