There seems to be something wrong with the OLE DB Destination metadata.

Does the package still work in BIDS? Is the destination table different on the server?

You can set delay validation on the package by clicking on the control flow, go to properties and change the property there.

As long as you keep all those grunge bands (Nirvana, Soundgarden, Alice in...

Sean Lange (5/24/2012)

---

Koen Verbeeck (5/24/2012)

---

Sean Lange (5/24/2012)

---

Always keep in mind that the questions you find super easy today are a great chance for some less experienced folks to start answering....

Sean Lange (5/24/2012)

---

Always keep in mind that the questions you find super easy today are a great chance for some less experienced folks to start answering. This helps to give...

opc.three (5/24/2012)

---

The two Execute SQL Tasks you mention point to the same database, using the same connection, sounds good. What happens to that transaction if an exception occurs while talking...

Eugene Elutin (5/24/2012)

---

anthony.green (5/24/2012)

---

Eugene Elutin (5/24/2012)

---

Give us your address and we will send you...

What!? You want to ban the biggest comedian of this entire forum?

😀 😎 :hehe:

Is this thread slowly becoming competition for this one?

http://www.sqlservercentral.com/Forums/Topic1303209-391-2.aspx#bm1305741

opc.three (5/23/2012)

---

MisLead (5/23/2012)

---

I have an execute task that truncates the table when the package runs. Downstream I have dataflow tasks that fetches fresh data and populates that data using stored...

I copied your entire question, pasted it into google and this is the first result:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/4c994ffa-4b96-461f-8472-0139e7f5e3b8/

Amazing, isn't it?

Since you now use DontSaveSensitive, the sa password is not stored anymore in the package. So you need to use a configuration to bring it in.

And let me add that...

It depends a bit on your environment.

If you want to use more memory and CPU power, you're better of with the BI edition.

For example, SSAS can use up to 64GB...

Jup

https://twitter.com/JanosBerke/status/205519876062842880

It's been retweeted a few times and we had some good laughs 🙂

Nice question, thanks.