Back to list
Views:   0
Replies:  0
Archived
,
Reply 1
I suggest you to choose SSIS Package because SSIS is meant for such tasks. Well, for accessing file from other/remote server , you can use .NET Impersonation. It gives you a "Run As" capability in your code. If you Google you will find  cut & paste code that you use with SSIS script.Using .NET bilkupload/Bulkcopy is not bad but using SSIS is right choice.

In SSIS " Script Task" you can write simple logic for column differences and make it work"

Best Regards
http://hakimshabir.blogspot.com
Shabir Hakim, Dec 20, 2014
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Licensing       EULA       Sitemap      
© Data & Object Factory, LLC.
Made with    in Austin, Texas