 » 
DTS Help
hai,
i want to create a DTS package, as a part of whole tasks i want to
perform the following task.
There is a Source file in text format and i want to import data into
SQL Server 2000 table. If the file exists, the DTS is running
successfully. If the file does not exist or the volume of the file is
ZERO, the DTS stops at that point of task and giving as 'DTS failed' and
is storing as failed jobs.
But actually i don't want to happen like this. If the file does not
exist or the volume is zero, the DTS should stop at that task and should
not execute remaining subseqent tasks. More specifically i want to do
the following one:
check if source file exist or not.
if it exists
go to the next step of the DTS (i.e importing data from the source
file to SQL Server)
otherwise (the file not exists or the volume of the file is Zero)
The DTS should stop there and should return success.
for a week, i am trying to catch this one. i have scheduled my package.
every time when it runs, its completing successfully if the file exist.
other wise, its giving
"Error string: Error creating datafile mapping: The volume for a
file has been externally altered so that the opened file is no longer
valid. Error source: Microsoft Data Transformation Services
Flat File Rowset Provider "
and stored into failed jobs.
Please solve my prob.
Thanks & Regards,
Venkata Srinivasa Rao Challa,
Bangalore.
| 
Linear Mode
