how to check no of records in a table

[asini]

Hello All,

some how we get data from different sources to Database table,
in our SSIS package, it needs to be write all table data to a .csv file, then it clears the table(by using execute sql task)

now the problem here is, when there is no rows in table then it is creating 0 rows .csv file, how to check if there is atleast 1 row in table then create csv file ,otherwise (if zero rows) it shouldn't

could some one help me in reragds to this solution

can any one tell me is Row count helpful to me (if yes can u please direct me..)
, or any other solution

please i am really stucked here

Thanks in advance
asini

 

[MDXer]

The data flow needs a destination in oder for it to validate so it will create the file regardless of the number of records. Your best option is to have a preceeding dataflow that exutes a query to count your records in a table you can then assign this value to a variable using the rowcount task. in your control flow you would place and expression on your control flow that would execute your extract dataflow only when the row count was greater than 0.