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?

Actually, I have SSMS, just no reports. That's why I am looking for DMVs etc to help me figure out how big this one record is. Looks like I need...

One possible way around this is to create a SQL Agent job which runs the package and then to allow the user to kick off that job, rather than the...

Use Redgate's free SQL Search tool - no coding required and works well.

Turncoat!

🙂

Ah, you must mean the magic-wand component.