Ignore, wrong thread.

Sorry, took a bit to get back here for me.

Yeah, SSIS is case sensitive. You'll find the same in LOOKUP component too. UPPER() is your friend there.

Double click on the stream between the excel source and the derived column. First, check the metadata on ColumnX and make sure it's what you expect (in this case,...

Short version: Life.

Self-inflicted financial wounds recovery, a couple of...

Wow, that's a heck of a questionairre. #10 is particularly difficult to decide on.

However, good luck on your costume. 😉

It should be similar to this:

(DT_Date)(SUBSTRING("01Feb2012",3,3) + " " + SUBSTRING( "01Feb2012",1,2) + ", " + SUBSTRING( "01Feb2012",6,4))

You may have to tweak it a bit, but it should look like...

I'm afraid I wasn't clear enough and you apparently...

Then they're worried about one of two things.

Pre-Compiler/validation times (check into the Execution Results and you'll see them) which you can lookup more information on a number of...

He may be part of a group/role that does have access. You have to start with the execution rights on the object and work backwards. Also note that...

Help us help you! Remember we're volunteers.

If you're looking for code assistance, we ask you present the data in a way that we can easily turn it into a...

IT2012 (12/19/2013)

---

As is the case with all "canned" software, seems we always need functionality that doesn't quite come with the package. SO.... I'm teaching myself with the aid...

Yup, but you're on the wrong forum. Even though you're displaying your output in MS SSRS, the...

There's no particular list. It's an open ended question to see how much you know about SSIS package execution and where all the pain points you've experienced are. ...

IT2012 (12/19/2013)

---

WOW!!!!!! Reading through these posts makes me wonder whether I DARE post any more "please help" questions considering my lack of expertise. I assure you my intent...

blasto_max (12/19/2013)

---

Thanks for all the tips @Evil Kraig F. I made a child package which will accept a DataSet from a parent package and convert it into a CSV file....