How about adding some table structure, sample data & the required output? Don't know how to do that click here[/url]

Florian Reischl (5/19/2009)

---

Ramesh (5/19/2009)

---

Ya, I know CLR rocks with file handling, string manipulations etc., but I never really liked those .NET languages, 'cause...

I am sure that it does not require sysadmin privileges because we have been using OLE objects to send mails in all of our legacy applications. All we have...

Though allowing "OLE Automation Procedures" is a security threat, but it does not require sysadmin privileges in order to execute those procedures (though the documentation says it requires sysadmin privileges...

What errors did you get when try to execute the query which I posted earlier?

Do the SQL Server Account had read permissions on the directory?

Is the solution working for you?

You are welcome..

FNS (5/19/2009)

---

A huge thankyou to all who replied. 😀 I was so busy looking at memory tables and then joining them with the original I lost sight of...

Check if the following query works for you.

SELECT *

FROM OPENROWSET

(

...

Add a break point on Pre-Execute event of Execute SQL Task and when in debug mode, go to debug window > Locals > Variables to see the values in the...

Don't cross post, it wastes people's time replying to multiple threads and also breaks the replies. Continue further discussions here

Don't cross post, it wastes people's time replying to multiple threads and also breaks the replies. Continue further discussions here

SELECT YEAR( GETDATE() ) AS [Year], MONTH( GETDATE() ) AS [Month]

It does work in 2K5 but we are in 2K forum. It happened to me many times in the...

Though I strongly does not recommend forcing execution plans as SQL Optimizer is smart enough to generate the best plans most of the times. If you fully aware of...