Yelena Varshal (8/22/2013)
You can use package variables.
Use @@Rowcount to get the number of rows returned by the query
http://technet.microsoft.com/en-us/library/ms187316.aspx
Assign this @@Rowcount value to a package variable
Very, very curious how you would do this in an OLE DB Source component.
The way to go is to use the Rowcount component. It is there for a reason.
Yelena Varshal (8/22/2013)
Generate the file name with GetDate() and assign it to both a package variable and to the file name
More info on this:
Dynamic Flat File Connections in SQL Server Integration Services[/url]
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP