I'm using the Excel source Icon... that uses the following connection string...

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Feed\BO_Data\DDC_Top_Sellers.xls;Extended Properties="EXCEL 8.0;HDR=YES;IMEX=1";

It might be that the article is for ADO connections but the problem and solution...

Still doesn't work... It's still doing the samething (bringing in numeric values only - Non Numeric Values are null...

I have to sort the Excel file within the SP before sending...

I'm Pretty sure I tried that but I'll try to make sure... meanwhile here's the article I found regarding this error:

http://support.microsoft.com/kb/194124

it seems that the T-SQL "group by" sorts before grouping which causes that problem... The only way around this (I think) is to use a Cursor (but this can take...

There's a missing a link... do you have a user id or something that links those 2 records together?

Here's what I did, hope it helps...

create table #test (a varchar(1000), b datetime)

insert into #test values ('Team Manager', '2000-08-31 00:00:00.000')

insert into #test values ('Team Manager', '2000-09-30 00:00:00.000')

insert into #test values...

You have all been a great help... I will still try to find the answer... and if I do, I will let you know...

I've been searching for this answer...

we don't want to lose the original filename since this is the filename is the one we refer to in our system (not MS-SQL).

There are about 10 000 images (they...

It's an option that we are considering... but the name of the pictures will change depending on who these images will be going to... so instead of copying the...

Very similar to what I had... but better, since the file size is the same as the original file... The only problem is when opening the file with "windows picture...

Using the distinct won't work since you have different fnames for each email address...

you'll have to group by email address, and choose an aggregate function for the fname (min,...