The only thing I can think of right now is to set the Database itself to Read Only (see BOL for process). You would then, of course, have to turn...

If you get an error in Query analyzer you can "double click" on the error message and more times than not it will take you to the offending line.

As for...

Make sure the server you are trying to run the package from has access to the location of the files.

It is truly amazing at how quick one of these threads can go down hill!!! 🙂

I guess that is one of the reasons I keep reading them!!

Darrell

I use a utility from http://www.sqldts.com/ to backup DTS packages from several servers called DTSBackup2000.

You could use this utility to backup to a drive from the server and then transfer...

Never mind folks - found another solution to my problem!

Thanks anyway!

You could also disable the following steps (avoiding having the package return a bogus failed status), much cleaner this way.

take a look at the samples on http://www.sqldts.com/

MS SQL uses an INDENTITY "property" on an INT field for Auto_Increment

So it should look something like this when you create the field

Fieldname INT IDENTITY(1,1) -- this sets it to...

jn,

You could also try something like this:

Dim oFS

Dim oFile

Dim oFolders

Dim oFiles

    Set oFS = CreateObject("Scripting.FileSystemObject")

    Set oFolders = oFS.GetFolder("Folderspec")

    Set oFiles = oFolders.Files

        For Each oFile In oFiles

                MsgBox ("file...

If you really must do this through T-SQL this works.

/* Working with the file system object in TSQL*/

DECLARE @fsoToken Int

DECLARE @error Int

DECLARE @tsToken Int

DECLARE @fToken Int

DECLARE @fileContents VarChar(2000)

DECLARE @src VarChar(500)

DECLARE...

Andrew,

I would add another ActiveXScript that opens the exception file and loads it into a table. I would also handle the email from this script (I don't like having triggers...

Andrew,

This site will give you a start with the VBScript objects (that can be used in an ActiveXScript).

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/FSOoriFileSystemObject.asp

Good Luck,

Darrell

Roberta,

I do something like this to get a count of valid lines:

  SET oFile = oFS.OpenTextFile(filename)

  iLastRow = 0

  DO UNTIL oFile.AtEndOfStream

   sString = oFile.ReadLine

     iLastRow = iLastRow + 1 

  LOOP

But a simple modification should get you the results you want (I think :rolleyes

if 1 = 1

  begin

    print 'OK to run this'

    return

  end

else

 begin

  print...

Steve,

I was watching the news the other day and was suprised to see that the White House has given a young man a press credential for his blog site. They...