Can you post the contents of the batch file?

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface

Sorry, didn't see that there was more than one column in the temp table.

Your CWD line should read,

quote:

---

Insert into ##temp_ftp_bat values ('cwd...

Cyrus

The error message is referring to the section of the procedure where it checks for the ftp batch file that it creates. Try using a local path & directory instead...

Bill

The ActiveX script is similar to the T-SQL solution you provided. It builds a list of ftp commands in a file and executes the ftp program with the -s option.

I'm...

Have a look at this,

Function Main()

Dim sSvr ' server name

Dim sDb ' database name

Dim sUser ' user id

Dim sPwd ' password

Dim iSec ' security to use

Dim...

Sorry, the perils of modifying the code after it's been tested.

I changed the SQL statement for the cursor to be what you required, unfortunately I didn't alter the FETCH statement...

Try this,

SET NOCOUNT ON



CREATE TABLE #PingResult (

OUTPUT VARCHAR(150)

)



DECLARE @Cmd nvarchar(200)

DECLARE @ComputerName sysname -- may need to change datatype

DECLARE @ComputerId int -- may need to change datatype

DECLARE...

Assign the value of @@FETCH_STATUS to a local variable and use that in your logic

eg:

FETCH NEXT FROM Outer blah...blah...

SET @Outer_loop = @@FETCH_STATUS

WHILE @Outer_loop = 0

BEGIN

 ...

I think even above that would be the implementation of some sort of global function/object functionality.

Then you could have your ActiveX transforms in one place and just refer to them...

You won't be able to run an SQL query to determine the properties of a DTS package. This is because the packages are stored in msdb..sysdtspackages as BLOB's.

Best method would...

As you're already utilising DTS, why not use an ActiveXscript task to perform the transfer? Or, even do as the above post from BillNye101 does, create a short batch file...

Have you tried any of the techniques described in books online to determine why the blocking is occuring?

Also, take a look at the following articles, they contain some handy tools,

http://support.microsoft.com/default.aspx?scid=kb;en-us;295108&Product=sql2k

http://support.microsoft.com/default.aspx?scid=kb;en-us;271509&Product=sql2k

http://support.microsoft.com/default.aspx?scid=kb;en-us;283725&Product=sql2k

Hope...

quote:

---

If that is the case what you mentioned, it should fail all the time when it runs right? but when i rerun...

One method I've seen implemented that does something like this is to replace the numbers with letters. From memory it added 65 to the each digit and displayed the corresponding...

Also take a look at TNT Software's ELM.

http://www.tntsoftware.com/Products/

Neat product that doesn't come with a huge price tag, but it's not cheap either.

You might need to do a bit more customising...