Visual Studio 2010 (I guess you're using SSDT) can only build reports for SQL Server 2012.

http://www.cdw.com/content/software/microsoft/sql-2012/sql-compare.html

Second Google result for sql server 2008r2 vs 2012.

How do you configure the destination table? Is it fixed in the package or dynamic?

You can download the zip file using the Webservice Task.

You can unzip the file using the Execute Process Task which calls for example the Winzip.exe file.

You can load the .csv...

What do you mean with filter?

Something like this?

DELETE FROM myTable WHERE columnA = 'B'

ps: why define a VARCHAR(1) column? What is wrong with CHAR(1). If you do have millions of...

Nice question Tom, but I doubt if I'll ever use it 🙂

(ps: you must be getting old if you can't count to four anymore :-P)

So, for which versions do you think the...

Lee Crain (11/7/2012)

---

I'm between jobs right now. I had an interview today for a contract position. The first question out of the Lead DBA's mouth was:

"Can you tell me what...

Does the server on which the package run has access to the SMTP server? No firewall blocking ports or something like that?

Any errors/warnings?

rmudway (11/6/2012)

---

GilaMonster (11/6/2012)

---

rmudway (11/6/2012)

---

Well... i dont need the...

Lee Crain (11/6/2012)

---

I just ran across this one; I can't help but post it. This list is just part of the total job requirements:

Knowledge, Skills, and Abilities

- In depth knowledge...

Easy one, thanks!

george sibbald (11/6/2012)

---

Brandie Tarvin (11/6/2012)

---

For my next SQL Saturdays blog post, I'm coming up with a list of acronyms & definitions for accidental / rookie DBAs.

Anyone have any suggestions for...

I think you're looking at outdated documentation. It talks about Oracle 7.3 and Oracle8.

Oracle is now at version 11.

The documentation is also about the deprecated Microsoft OLE DB provider for...