Hugo Kornelis (11/28/2011)

---

It would be a silly trick question if the author intended it to trick us.

The "explanation" suggests that the question author fell for the...

Sunil Chandurkar (11/28/2011)

---

I overlooked that it is a STRING comparison and got the answer wrong.:-) (though writer had intention to show datetime comparison)

I updated the code as follows and executed:

DECLARE...

Jeffrey Williams 3188 (11/27/2011)

---

Jeff Moden (11/27/2011)

---

I believe Tom has this nailed. The Green Arrowhead used to be the "run" command prior to SQL Server 2000. In 2005 and...

I'm not really sure what you are trying to accomplish.

You have 3 child packages, which you execute with Execute Package Task.

And the first package has 2 error rows. Does this...

Silly trick question...

Tough one, thanks.

MSBI Learner (11/24/2011)

---

Hi, I would like to have a package to do this job for me so that I can trigger a SQL Job whenever I wanted to push the...

You can download a file using the HTTP Connection Manager:

http://www.sqlis.com/sqlis/post/Downloading-a-file-over-HTTP-the-SSIS-way.aspx

I would go with Jeff's solution. If you want the all or nothing approach in SSIS, you need to incorporate transactions, which can take up quite some time to rollback,...

It would be useful if you at least provided us the error that you got.

This should be a Regular relationship.

The composite key could give troubles though.

I think it is best to introduce surrogate keys between those tables. It will make configuration a lot easier.

You're using SQL Server functions and datatypes. They do not exist in SSIS, so you'll need to use the ones that SSIS provides.

Nice overview, thanks.

I'm trying to convince some coworkers that moving all the files in a directory is much easier in a .NET script task (4-5 lines of code) than using...

Jim Murphy (11/22/2011)

---

The other organizer of our SQLSaturday in Austin (#97) just compiled the speaker feedback evals. I came in 3rd overall! I'm pretty pleased since it was...

:w00t: 7 points! No snow here, as it is still 10°C out there. Quite unusual for the time of the year, but you don't hear me complaining...