Hi,

I'm fairly new to DTS and am trying to copy the results of a query to a
text file but get the following error:

Error creating datafile mapping: The volume for a file has been
externally altered so that the opened file is no longer valid.

I'm using sqlserver 7 and have created a connection to my database and
my text file (located on the root of c). The properties of the text
file connection is fixed fields and first row has column names is
checked.

I've created a data driven query task with an sql statemnt as the
source and the text file as the destination. The transformation is an
active script which is created automatically and the query is left
empty. Does this seem correct?

Any help would be much appreciated

Thanks

Simon

Hello accyboy1981,


When I have seen this error

The volume for a file has been externally altered so that the opened file
is no longer valid

I usually have a look at the file size. I have seen this error thrown when
the file size = 0 bytes


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com