Re: Importing Empty FIle

Hi Phil,

Perhaps you could write an ActiveX script task that opens the error file and counts the number of rows. Then have success and failure constraints that point to the correct action. Success run the transform.

Norman

get DTS Package Search at http://www.gerasus.com/

Phil wrote:
Hi,

I wonder if there is a work around for the following problem, I have a DTS pack that imports a number of uploaded files as well as files that show errors that we have had in the files that we have uploaded. The DTS works fine when there are errors listed in the Error file but wont work when the file is empty, you get the error

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

I know that really this makes sense, but I could do with the DTS not failing at this point, any ideas, what I would like if for it to do is complete the DTS and just have an empty table where the files should be imported into.

Thanks PD
.

Relevant Pages

  • Re: Importing Empty FIle
    ... pack that imports a number of uploaded files as well as files that show ... The DTS works ... DTS and just have an empty table where the files should be imported into. ...
    (microsoft.public.sqlserver.dts)
  • Re: conditional step
    ... Is there a way to do a conditional step in DTS, like there is in SQL 2005? ... You can use ActiveX Script task to list files in a directory and set ... then split your execution (using workflow ... IF EXIST C:\..path..\yourfile.zip GOTO SUCCESS ...
    (microsoft.public.sqlserver.dts)
  • Re: VB Script Error Code
    ... I dislike using Fail and Success for this ... before kicking-off a DTS import and I wanted to know the following: ... How can I have the script return a Successful or Failure execution? ...
    (microsoft.public.sqlserver.dts)
  • Oracle to SQL Server Dates - Headache!
    ... I've tried DTS ... with little success due to different date formats and multi dates within a ...
    (microsoft.public.sqlserver.programming)
  • Re: FTP script and return codes
    ... I just found out what DTS stands for and I'm ... This is part of activex script in an SQL ... This is the first script and would like to verify success ... > good sites/books for Windows scripting as I would like to know more. ...
    (microsoft.public.windows.server.scripting)
Loading