0

I have a requirement in which I need to compare columns of 2 Excel files. If columns are matched, then proceed with next steps of SSIS package. If columns are not matched, SSIS package should stop. Please help.

SG_
  • 45
  • 7
  • 1
    You need to use `GetOleDbSchemaTable`. Here are some examples. Try these and come back with any specific problems. https://support.microsoft.com/en-us/kb/318452, https://www.mssqltips.com/sqlservertip/1674/retrieve-excel-schema-using-sql-integration-services-ssis/, http://www.proteanit.com/b/2008/03/05/code-to-query-excel-schema-in-ssis-script-component/ – Nick.Mc May 10 '16 at 01:37
  • Thanks Nick, it worked. – SG_ May 18 '16 at 02:05

1 Answers1

0
  1. Import data into SQL table.
  2. Compare columns
  3. then proceed based on match or no match. Do i miss anything here
Ken
  • 3
  • 6
  • Thanks Ken, yes, I was particularly looking for implementation of step 1 mentioned by you above. Its done. Thanks much !! – SG_ May 18 '16 at 02:06