Applause for the second one!

(Boo for the first one :-))

There was a real similar question before, and I thought I'd remember the answer, but apparently I did not, as I took the wrong answer.

But nice question though, thanks.

I've seen that list of question before, and there are sure some legitimate ones in there, as they are just math quizzes in disguise.

For example:

“Out of 25 horses, pick the...

Brandie Tarvin (2/24/2011)

---

Aaaaahhhhh. Good catch.

For some reason, I had it in my head that all I had to do was leave it at "Report and Continue" and that would...

Ah, in that case you'll need a conditional split to split out the data flow to the right destinations.

However, if you have a lot of destinations, it can be a...

Phil Parkin (2/24/2011)

---

I may be coming into this a bit late, but sorting can be done a bit more elegantly than that in .NET. Here's an example:

...

balbirsinghsodhi (2/24/2011)

---

I count not figure out the issue that why Insert in one particular table is very slow. I use the same ssis package for other table and it did...

I'm afraid you can't do...

What is the setting of "Ignore errors count", "Stop on error" and "Number of errors"?

If stop on error is chosen and there is a value filled in for number of...

James Tech (2/24/2011)

---

Okay, I already got it. My only problem...

Brandie Tarvin (2/24/2011)

---

The name is deceptive...

You can change the language in the script task properties to VB.NET.

However, once you chose a language and clicked OK, you...

SSIS doesn't have a date datatype, so in my opinion the best option is to do the conversion immediately in the source query.

20110224 --> 8 characters.

You'll need the following function:

CONVERT(DATE,[FILE_RUN_DATE])

I'm...

Brandie Tarvin (2/24/2011)

---

The two methods I know of are to either use a webservice to get into SAP's database and call the data that way, or get SAP to provide...

The errors that occurred, they were all key not found errors?