rocky_498 (8/23/2013)
Hi Guys,Thank you all for your help. I used RowCount Tranformation...
One more question, I want to display Count and file name and put in to flat file. I got the Count is anyone can help me how i can get file name that I just rename through "File System Task" to add Date Stamp? I can get file name however date stamp is not matched from file that just renamed in File System Task.
Any help?
How did you calculate the file name in the file system task? If you used an expression with getdate(), it will change every time it is called.
The best option to have one constant file name is to calculate in an Execute SQL Task and store the result in a variable. This variable you would use in the file system task and to output it to the flat file destination.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP