Lynn Pettis (9/7/2012)

---

Phil Parkin (9/7/2012)

---

Lynn's solution is the way to go.

In her solution, basedata is a CTE - effectively a subquery in this case - from which the normalised...

Do you mean a folder containing multiple .sql files?

Surely the Execution Plan would be a better place to start, if performance optimisation is your goal?

Lynn's solution is the way to go.

In her solution, basedata is a CTE - effectively a subquery in this case - from which the normalised data is being selected.

If...

Please provide some code which exemplifies this. And explain why you need to do this and what you are expecting.

I think that error is happening because the worksheets in the Excel files have different names. Presumably it's called 'SALES' in the one which is getting loaded and something else...

Ah yes, thanks guys.

Note to self: read more carefully next time 🙂

Yeah you can. Just tried this and...

Robin Sasson (9/6/2012)

---

I'm a bit unclear of your requirements but I assume you want to extract the Month and Year from a given date and create a string from the...

Derived columns in SSIS do not use T-SQL syntax - they use SSIS Expression syntax, which is a bit like C#. So no selects, converts etc. You just need to...

Use the SUBSTRING() function.

Have a try and post back with how you get on.

1) Break down into multiple queries.

2) Use fewer characters.

3) Call a parameterised stored proc to do the work for you.

bhushan_juare (9/5/2012)

---

I don't want SSIS code what I want is Visual basic ASP.net 2005 code where save mail files (.msg) along with attachment is handled. Rest i will do in...

You just answered a post which is three years old... 🙂

Just clarifying what you mean by 'external components' - I presume you are including SSIS and SMO routines?