Hi,
I want to use bulk insert and would really like to use character file
because it would mean less work from our application, but we cannot use
field terminator nor row terminator because any combinaison of printable
chars could possibly appear in one of our values. So we thought it could be
a good idea to use prefix length as indicated here :
http://msdn2.microsoft.com/en-us/library/ms190779.aspx. But no matter how we
try to format the file, nothing works... Does anyone have an example file
for this? And if noone does, does anyone have a link to how we must format
our dates, decimal, doubles, et al. for native file format? because .NET
formats do not serialize the same way as SQL Server does.

Thanks

ThunderMusic