469,890 Members | 2,107 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,890 developers. It's quick & easy.

BCP help needed

I have a script that writes 83 separate files to a directory using bcp.

The script in total worked perfectly well until two weeks ago.

I am now getting the same error message for data from 25 different tables. The error is:

SQLState = S1010, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Function sequence error

The exact bcp command for one of these tables is as follows:
bcp "Select * from Smed_data2000..vw_CrsMstSORD" queryout "\\som\sqlF\dataout\sord\070730\tblCrsMst.txt" -T -c -a 65535 -b 10 -S<servername>

In this example, the view returns 2311 records, hardly enough I think to cause this problem.

DTS works nicely but since my company is using SQL2000 (looking to move shortly to SQL2005) I don't want to write a DTS package in SQL2000 and then have to rewrite it when we move to SQL2005.

Any suggestions are greatly appreciated!
Jul 31 '07 #1
0 970

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by Stephen | last post: by
13 posts views Thread by Joe Feldman | last post: by
reply views Thread by Cindy B | last post: by
17 posts views Thread by dingoatemydonut | last post: by
reply views Thread by ultradiv | last post: by
28 posts views Thread by Ian Davies | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.