Define what you mean by 'stuck'.

Generally most quick ways aren't really safe. You could try restarting the MSSQLServer service. I've found in the past that SQL generally recovers pretty well...

Check Books Online. A value of -1 means that the lock timeout hasn't been set for the current session.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface...

Easiest way is to get an evaluation copy of SQL Server (either from Microsoft or buy one of the many books that include eval copies). Then just install the client...

Ok there is two things you'll need to do.

1) Replace your sp_help_revlogin procedure with this one,

quote:

---

IF OBJECT_ID ('sp_help_revlogin') IS NOT NULL

...

You'll need Database and Text file (Destination) connections. Then select both connections and click the Transform Data button to create a Transform Data Task.

Double click the Transform Data Task to...

Sheri

Maybe you could post the batch file so we can look at it.

Generally, when I'm running scheduled DTS packages they are run in the security context of the SQL Agent...

Well if you haven't made any changes to the package. You'd best check what else has changed in terms or security, structure, server and database settings.

What is the ODBC source?...

Now that is strange because I tested this on my server here. I created a text file in Notepad with 5 lines of varying lengths, and made sure the first...

All you need to do is have data, not spaces, in columns 431-447 the first time you define the columns and transformations.

Subsequent eecutions of the DTS package will just chop...

Have you tried using the ISDATE() function instead of ISNULL()?

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

With SQL 7, probably your best bet is to turn on the logging, which will log the messages to a file. Then on failure pickup the file that is created...

Sounds a bit complex.

I'd just import the data you have straight into a staging table. Then run couple of stored procedures to update required fields in the staging table. Then...

Check out the following

http://www.sqldts.com/default.aspx?6,103,211,0,1

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

Have you tried creating a new connection with the same name and then deleting it again?

Also, try the following. http://www.sqldts.com/default.aspx?6,222,253,0,1

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click...

Doing it via the workflow, there is no "OR" in DTS.

You'll have to have an "On Failure" branch with the task you want to execute for each of the ten...