MSSQLTips.com - your daily source for SQL Server tips

Google
 
Web mssqltips.com

ESSENTIALS: Home | Tips | Search | Categories | Top 10 | Products | Authors | Blogs | Forums | Webcasts | Advertise | About
Browse by Tags - MSSQLTips

MSSQLTips

MSSQLTips.com - your daily source for SQL Server tips
Welcome to MSSQLTips Sign in | Join | Help
in Search

Browse by Tags

All Tags » sql bulk insert (RSS)
  • Re: SSIS - file import - ANSI non-printing characters

    Simple solutiion - use BCP 1. create format file 2. use following command line: bcp.exe DBName..Table_Name in C:\Input_Filename.txt -T -f C:\FormatFile.fmt or use SQL syntax: BULK INSERT DBName..Table_Name FROM 'C:\Input_Filename.txt' WITH (FORMATFILE = 'C:\FormatFile.fmt') Done.
    Posted to Forum by egxis on 08-01-2008
Page 1 of 1 (1 items)