In you SSIS package, execute a t-sql task before your data push to excel

OR

execute the code the last SP that...

update

--your table

set E = [value], --what ever you like

F = [value],--what ever you like

M = [value]--what ever you like

Run this code before you export the results to excel.

This...

Did some testing (created table with 270 rows + created view to return a few results)

I ran the following code

if (select COUNT(column) from view) > 0

begin

print 'exists'

end

It took less...

You could be sneaky and build a string that is sent to the stored procedure as the parameter.

EG

declare @string varchar(100)

set @string = 'value1;value2'

exec mystoredproc @string

Then in the stored proc, you...

Lutzm,

Thanks for the feedback and I will be redo the question into a friendly format. Unfortunately I can only do this tomorrow. Should I rather edit the first post...

Hi Jeff,

Thank you so much for your post. I did some modifying but you code work PERFECTLY. Thanks again

:-):-):-)