All replies

The first step to solving your problem is to run your bcp command from a command line. Does it work as you expect? Probably not. Running it using xp_cmdshell will not allow you to debug your problems. I suggest you look for a file
named Table2 to figure out what happened.