Re: Best Method to Import to SQL Server

Well the fast ways is to by pass BizTalk and import the flat file into BizTalk using SSIS.

If the file is smaller, then using BizTalk would be ok and easy to set up.  Plus you have a lot of control over routing and mapping.

Hope this helps.