Advertisement

02.19.2008 at 10:54PM PST, ID: 23176805 | Points: 500
[x]
Attachment Details

To validate # of excel rows(source) and sql server table(destination) rows are equal

Asked by Alicia_Rose in MS SQL DTS, MS SQL Server, SQL Server 2005

Tags: sql, ie 7

Hi,

 

When expoting data from excel to sql server table, using SSIS package, after exporting is done, how would i check source rows are equal to destination rows. If not to throw an error message.

 

How can we handle transactions in SSIS

1. when some error/something happens during export and the # of rows are not exported fully to destination, how to rollback the transaction in SSIS.

 

Any sort of help would be highly appreciated.

 

Thanks,

Start Free Trial
 
Keywords: To validate # of excel rows(source…
Title
1 Rollback
2 IRQL-NOT-LESS-OR-EQUAL
3 IRQL_NOT_LESS_OR_EQUAL - Bu…
4 Table-like layout with equal DIV height…
5 IRQL_NOT_LESS_OR_EQUAL
6 Islam and Equality?
 
Loading Advertisement...
 
[+][-]02.19.2008 at 11:41PM PST, ID: 20935749

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.20.2008 at 02:15AM PST, ID: 20936352

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.20.2008 at 08:50AM PDT, ID: 21607350

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628