I am not sure exactly what you are trying to do here, but it looks like you are getting your error in the source of your data flow. Sometimes...

Tuned out to be because the query that is assigning a value to @SumPrice didn't return any records. So when you do any math operation on a NULL value...

That is what I was thinking as well. So just to try something, I used the string data type and then put a few conversion in the stored procedure...

Thanks for the reply, but the result is the same. I think it may have to do with the data type of the variable, but I have used the...

Couldn't you just add a date into the file name to make it different from the previous file(s).

DECLARE @fileDate VARCHAR(20)

SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112)

SET @fileName = 'c:/testing' + '_' + @fileDate...

Andy, Thanks for the article. It is just what I needed. All of the SSIS books I have use the file enumerator in all of their examples and...

Is the property "Run64BitRuntime" set to TRUE?

The property can be found under SSIS Project Property Pages -> Configuration Properties -> Debugging

Here is an article that goes into a lot of...

I think I found a way of getting around it. I guess the problem was that I had 76 columns coming through the pipeline and then I multicasted it...