oops posted on wrong forum. Thanks sleepy head...Phil?

that !="yes" will never work because you will never have a file name called "yes". instead what I would is exactly what Tim Mitchell has nicely laid out.

You have to...

is whatever is producing the excel file returning any rows?

hi,

where do you set that timeout? or is there another way of delaying the Send Mail Task. Mine fails because the SSIS package fires in rapid succession with following error

Error:...

Yes I have tried it and ran into too many issues which was the 443th issue, I thought it was not clearing the Sheet when actually it was but the...

ok that did the trick, thank you! I recreated the xl file from scratch and now it is working beautifully!

yes all that in a Data Flow in the for each loop. reason being (could be bad design) I have to loop through each task, then find all subtasks, push...

I mean it populates rows in the Excel file via a Data Flow Task which contains an Ole DB source then a Data Conversion Task and then the Excel destination...

what security context is the SSIS package running ? what user and does that user have rights to that folder? do you have folder names longer than 8 characters in...

absolutely brilliant! thank you so much

forget about DROP TABLE `Sheet1` and all that this is the way to go!!!!!

thank you very much all. I got it working ! I assigned a value to a variable using an object variable to hol the "recordset" then index 0 to refer...

greetings

BOL says

In SQL Server 2005 Integration Services (SSIS), expressions can be used to define conditions for CASE statements, create and update values in data columns, assign values to variables,...