Yosiaz - No, it creates CSV files everynight. then another program combines all CSV files into one file. Then i need to take the combine CSV and import that into our database.
but I am having issue with BCP
bcp report.dbo.TempTextData in C:\inetpub\wwwroot\TwilioSmsHandler\log\combined%latest% -t -c -S %sqlinstancename% -U %PRDlogin% -P %PRDpassword%
I get an error below please help.
Starting copy...
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]Unexpected EOF encountered in
BCP data-file
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]Unexpected EOF encountered in
BCP data-file
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]Unexpected EOF encountered in
BCP data-file
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]Unexpected EOF encountered in
BCP data-file
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]Unexpected EOF encountered in
BCP data-file
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]Unexpected EOF encountered in
BCP data-file
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]Unexpected EOF encountered in
BCP data-file
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]Unexpected EOF encountered in
BCP data-file
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]Unexpected EOF encountered in
BCP data-file
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]Unexpected EOF encountered in
BCP data-file
BCP copy in failed
Press any key to continue . . .