Failed to copy - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Failed to copy

Author

Topic

SamC
White Water Yakist

3467 Posts

Posted - 2005-06-14 : 10:48:13

Using EM's TOOLS/EXPORT, I've walked through the wizard to exec a stored proc and store the results to d:\sam.csv

When run, it returns:

Failed to copy 1 Tables
Double-click the error row for a detailed description of the error.

ok, ok...

Copy data from results to d:\sam.csv Step
Incomplete file format information - file cannot be opened.

SamC
White Water Yakist

3467 Posts

Posted - 2005-06-14 : 11:25:52

Strange. If I replace the query with another query. It works.

Something about the recordset??

SamC
White Water Yakist

3467 Posts

Posted - 2005-06-14 : 15:29:49

Here's what resolved the problem.

IF @SomeParm IS NULL
  RETURN 1

SELECT ColA, ColB, ColC

Got rid of the error test and return. It works.

SamC
White Water Yakist

3467 Posts

Posted - 2005-06-14 : 17:37:14

Sam, this has been an interesting thread with much forum participation.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources