Post reply

SSIS Package to compare data in two text files

  • February 21, 2009 at 6:45 pm

    #383992

    Hi,

    I need some solution where I can compare two data in two or more text files and then give output in third file.

    Please help me out in same ASAP.

    Thanks

  • February 21, 2009 at 10:04 pm

    #948243

    Bring the text file data into SQL Server, write a query to do the comparison, then output the results of the query as a text file.

    Phil

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • February 21, 2009 at 10:40 pm

    #948246

    Thanks

    but I can't use any sql server, hv to implement without it

  • February 21, 2009 at 11:59 pm

    #948248

    You are trying to do database-type stuff without a DBMS :crazy:

    You could do the whole thing row by (painfully slow) row in a script task. But when you have a shiny fast SQL Server db engine there, it seems a terrific waste.

    Phil

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply