Browse by Tags

How to get rowcount efficiently within a SSIS package?

Published 5 September 7 3:50 AM | SSQA.net

I would like to call this as how efficiently you can obtain counting rows in SSIS package. Usual thought would come is @@rowcount or COUNT_BIG functions, but this is not that efficient way to obtain the results. SSIS provides the snippet within its components...

Filed under: sql server, package, databases, ssis, component, table, requirement, rowcount

Annoying x80040E21 & x80040E24 errors

Published 25 May 7 4:41 AM | SSQA.net

If you are performing a simple process to import a data using a DTS package in SQL 2000 or an SSIS package in SQL 2005, you might be very familiar with errors such as "x80040E21 & x80040E24". To put more in the sense of real error it will...

Filed under: data, ssis, error, jet, component, oledb, mdac, dts, odbc