Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-05-02 : 07:51:36
|
| Oli writes "I am trying to use DTS to perform a Copy SQL Server Objects Task to simply copy several tables from one db to another on the same server. Task completes ok, Destination table IS created, but it does not actually copy the data. In the LOG file created in the specified Script File Directory, I note the following error;::Error::In file in statement on line 0Transfer Status: Transferring Data: (Table '[dbo].[Clients]')[Microsoft][ODBC SQL Server Driver]Unable to open BCP error-file Is this a red herring?Any ideas on how to rectify?OS = MS Windows 2000 Server SP3SQL Server Vers = SQL Server 2000 SP3 " |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-05-02 : 09:17:01
|
| What do you have for a path to the error file in your dts package?Go to package properties then under the logging tab what do you have for error file info.Edited by - ValterBorges on 05/02/2003 09:18:16 |
 |
|
|
|
|
|
Unable to open BCP error-file