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

Try to formulate this a little better.

ps: your insert statement is...

What's the domain exactly? Everything after the @?

If you have the button to call the context menu (like when you right-click with the mouse), it is possible:

1. Hit the context menu button

2. Hit c

3. Hit h

4. Change...

If you have the full path in the file name column, then of course you don't start your count for the substring at 13, but at 100 (if I counted...

This makes no sense.

The...

Try the following:

(DT_DBDATE)(SUBSTRING(myFileName,13,4) + "-" + SUBSTRING(myFileName,17,2) + "-" SUBSTRING(myFileName,19,2))

Do you need the date only or the time portion as well?

Start with SUBSTRING...

That's an option as well, but this trick is more for the lazy...

Phil Parkin (11/12/2014)

---

arunnrj87 (11/12/2014)

---

I have added by going to DataFlow Task -->Flatfile Source -- >Right Click Show Advanced Editor-->

Component Properties -- > Under Custom Properties-->In FileNameColumnName--> i have five the...

OK. According to your original question, the package was already failing before you added this new column.

That issue needs to be solved first.

How did you add the column FtpDate to the source component?

Please post all of the error messages.

Which process are you referring to?

Q1: Not necessarily. Hard to say without actual execution plans. Because you are using INNER JOINS, semantically the three queries are the same; meaning they will produce the same result...

There is an advanced property in the flat file source where you can add a column that contains the filename of the flat file you are loading.

FileNameColumnName property, Flat File...