Schaeffrcc
Technical User
I am using BCP to dump a Temp Table out to a .CSV file every night. the BCP works great for the most part and 5000 records get dumped just fine but approx 900 records get dumped to the .CSV as just the deliminator.
Here is my BCP statement
EXEC master..xp_cmdshell 'bcp "adult.dbo.clients" out "c:\sweeper\clients.csv" -c -q -t~ -Prod -T'
The 900 record that do not extract correctly show up as:
~~~~~~~~~~~~~~
I have speculated that BCP sees something in one of the field in the table that is does no like or cannot understand so it just gives up and send the default blank with deliminators.
has anyone seen this type of problem before and can you give me an idea of where to start.
Thanks in Advance,
Thomas
Here is my BCP statement
EXEC master..xp_cmdshell 'bcp "adult.dbo.clients" out "c:\sweeper\clients.csv" -c -q -t~ -Prod -T'
The 900 record that do not extract correctly show up as:
~~~~~~~~~~~~~~
I have speculated that BCP sees something in one of the field in the table that is does no like or cannot understand so it just gives up and send the default blank with deliminators.
has anyone seen this type of problem before and can you give me an idea of where to start.
Thanks in Advance,
Thomas