Archiving off data is a good way to reclaim the space for future transactions, but unlike the others, I don't recommend shrinking the files. Shrinking call kill performance and the...

We need a little more information to answer your question.

How is the variable populated?

How does the variable relate to the .csv file?

How is the .csv file getting imported? (what...

Really? I had never heard that before.

I am setting the property and we will see what happens.

l.danks (9/15/2011)

---

To answer one question - the data is entered regularly, every few minutes in fact, but in a format which is less than useless for reporting (just lousy software...

How would Delay Validation being set to False force the email to send twice?

A couple of things.

1) If you're deleting everything from the destination, use TRUNCATE rather than DELETE. TRUNCATE generally runs faster because it does not fully log the rows being...

Ninja's_RGR'us (9/14/2011)

---

Brandie Tarvin (9/14/2011)

---

Speaking of school, last night I got so excited about such a silly thing. My SO & I were talking about Decartes and I asked, "He was...

Speaking of school, last night I got so excited about such a silly thing. My SO & I were talking about Decartes and I asked, "He was a rationalist, wasn't...

Ray K (9/14/2011)

---

True story: a few weeks ago, I was administering a final exam (I teach part-time). One of my students asked a question. It went something like...

You rock, Dave23! Your Google-Fu is superior to mine.

That actually worked. I moved my Toolbox and no error when I closed BIDS. I open it up and it's exactly where...

After experimenting several times, I finally noticed a pattern. If I close BIDS out as normal (without moving the Toolbox), everything shuts down fine, no issues.

If I move the Toolbox...

Are you having the same...

Howard, that's brilliant! It worked.

Thank you so very much. I was about to start developing in 2005 and then upgrade.

And yet, it's not permanent. The Toolbox keeps moving back to the bottom of my screen when I restart VS.

This is annoying!

Bleargh. I hate using the Wizard. It always gets things wrong.

Edit: Thanks for the suggestion, though.