Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  How to set up a row count

Author  Topic  Enzo69 Starting Member 1 Post Posted - 2012-02-29 : 06:01:14 Hello, I would like some help on the Row Count (Data Flow Transformation) task. I'm currently a novice at designing SSIS package in SQL Server 2005, and would like help to set up a row count, which will determine the next step the package takes. I am trying to set up a row count, which determine if there are sufficient records in the staging table before it truncates the live table. Currently a flat file is produced, which is then inserted into a staging table. I would like to check how many rows’ are in the staging table before I truncate the live table and then insert staging to live. If the staging table only has 1 row, then I would like to produce an error. However, if the row count is over one millions rows then I would like to insert into the live table. I know how to insert the data into the tables and how to truncate the table; I'm just unsure how to trigger them off... I hope I have made sense... Kind Regards Enzo..