Generate BCP, Bulk Insert code with TSQL

posted by  hjwin (10)  12 months ago (blogs.msdn.com)

This script will generate tsql code to bcp and bulk load data for all tables in a given DB. SET NOCOUNT ON GO DECLARE @ path nvarchar(2000), @batchsize nvarchar(40), @format nvarchar(40), @serverinstance nvarchar(200), @security nvarchar(800) SET @ path...(read more)