Yes, I think that I need to do this in Execute Sql Task.

Thank you.

Sharon

Hi,

I had read that article but I thought that because I had the Row Count Task after the

OLE DB Source it would work. IT MUST BE AFTER THE COMPLETE...

I tried the (DT_STR,7,1252) it did not work.

I rerun the SQL using top 8, still 0RowsFound.txt

It seems that the row count task is not setting the variable.

I find SSIS...

Hi.

I have created a variable called RowCount - at the package level,Int32,Value = 0.

I have created a Row Count task between my OLE DB Source and Flat File Destination....

I wanted to use SSIS variable in file name to let user know that no records where returned without opening the file. Example:

STSfile_09152008_noRecordsFound.txt or maybe also

STSfile_09152008_450RecordsFound.txt

Thank...