eric.johnson 33562 (3/4/2011)

---

At this point, "Execute SQL task" throws and error because it returns an empty set (select id where custName='unknownCustomer'). Other folks are having that problem also....

Sorry, but I have absolutely no experience with SSAS 2000 and certainly not with DSO.

You can follow the article as a starting point, but I'm afraid you'll have to rely...

As far as I know:

if you don't have Visual Studio, BIDS 2008 is installed. As mentioned before, this is just a shell of visual studio.

If you have Visual Studio 2008...

According to this thread, some dll's should be registred to solve the error:

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/f64f9adf-9c97-4e3e-b7c6-9a85e8f1c383/

Brandie Tarvin (3/4/2011)

---

Ah. I haven't worked with 2008...

jcrawf02 (3/4/2011)

---

Greg Edwards-268690 (3/4/2011)

---

Sounds like the Logic Class my daughter is taking in college right now.

Tough course to take online, when the only feedback you get is correct or incorrect.

The...

Is it possible to post an screenshot of your control flow?

You can add attachments to a reply here in these forums.

If there is anything confidential in your package that can...

CozyRoc (3/4/2011)

---

The solution works really nice. The argument about not using 3rd party tools "falls flat on its face" when you find that many of these same companies are willing...

To the law-mobile!

I know 😉 :hehe:

True. I've spent a good week trying to figure it out myself.

CozyRoc (3/4/2011)

---

Another...

Tom Van Harpen (3/4/2011)

---

We are going to install the SQL engine on the new server so we can use the agent. This is a better option since we will have...

CozyRoc (3/4/2011)

---

Koen Verbeeck (3/4/2011)Therefore the use of dynamic SQL. You construct the whole SELECT and INSERT statement on the fly.

But, to be true, this will only work if the destination...

Ha-ha. I call the victory of this Friday mine!

Now I can celebrate it all weekend long with the finest of beers!

Ahem... 🙂

Jan Van der Eecken (3/4/2011)

---

Brandie Tarvin (3/4/2011)

---

Koen Verbeeck (3/4/2011)

---

Brandie Tarvin (3/4/2011)

---

Plagiarism is when you're pretending the work is your own and not giving proper credit.

Copyright infringement is when you're reprinting...

CozyRoc (3/4/2011)

---

Koen Verbeeck (3/4/2011)

---

You can use a for each loop to loop over the table and store the tablename in a variable.

Then you can construct a dynamic SQL statement in...