Nice question, thanks.

Anipaul (5/11/2011)

---

Craig Farrell (5/10/2011)

---

Anipaul, what do you mean by sample questions here? I didn't...

Run the package using dtexec instead of using the GUI in BIDS.

Does it run successfully? Are there any errors/warnings in the log?

If the answers are yes and no, then there...

I would use a single OLE DB source that selects the data from the 3 tables and joins them on ID.

Then I would use a script component as a destination....

Phil Parkin (5/11/2011)

---

Presumably, there is other data on the lines with no dates which you want to keep? If so, you can't use Koen's solutions, as they'll discard the entire...

You need to get rid of those empty lines first, and then place your derived column.

You can use a conditional split for that, or use a SQL query in the...

You need to create a proxy account. Once you have done that and assigned the proxy account to the necessary jobstep types, you can use it in the Run As...

Edit: double post

(quite ironic when the original post is about not posting the same thing twice :hehe:)

Joy Smith San (5/10/2011)

---

.......... I am bit worried that you are the only one responded to my post. ............... From a Microsoft SQL Server community of 1,387,736 DBAs,developers and SQL...

Thanks for sharing!

Great question!

Jeff Moden (5/10/2011)

---

Steve Jones - SSC Editor (5/10/2011)

---

Just rated some sessions for the PASS Summit. This has to be one of the poorest implementations of a rating tool I've seen,...

ALZDBA (5/10/2011)

---

Koen Verbeeck (5/9/2011)

---

I've got a MSDN Livemeeting going on this afternoon (European time). Two demo's of each 15 minutes, so 30 minutes of talking.

Any tips from the professionals around...

Brandie Tarvin (5/10/2011)

---

Koen Verbeeck (5/9/2011)

---

I've got a MSDN Livemeeting going on this afternoon (European time). Two demo's of each 15 minutes, so 30 minutes of talking.

Any tips from the professionals...

bhavika.chauhan (5/10/2011)

---

1) Just right click the Project in the solution explorer

2) Go to properties

3) Select Debugging in the left panel.

4) In Debug option section : Make Run64Bit Runtime -->...