SQL Server Performance

compare files in ssis?

Discussion in 'SQL Server 2005 Integration Services' started by Raga, Jun 23, 2006.

  1. Raga New Member

    Can I compare 2 files using ssis?... do anyone have any idea how to handle this.

  2. ranjitjain New Member

    Well, i think you need to create your own .net script and then you can achive that the way you want in .net script task in SSIS
  3. SQL_Guess New Member

    Unfortunately, that seems to be the answer for a lot of things if your aren't doing extract/transform/load activites. I found that, and eventually, we decided to develop the specific integration piece we needed, in Biztalk.

    Having said that, I think Biztalk was the right tool to use, since we only had 1 SQL target, everything else was application integration,which is what MS say Biztalk is intended for, whereas SSIS is intended for Data Integration.

    Panic, Chaos, Disorder ... my work here is done --unknown

Share This Page