With this solution, it appears that I would have to call this segment of code over and over until @@rowcount = 0. 

In other words, I would have to put...

Alternatively, you could write the value to a table and then query the table during DTS execution for the value.  You would also be able to set the value at...

You can do this in an ActiveX Script like below...

Function Main()

     Dim myYearQtr

     myYearQtr = InputBox ("Enter the date you would like to extract data for.", "Extract Data","4Q2003")

     DTSGlobalVariables("myYearQtr").Value =...

We use the following syntax to log this information in a database:

insert into logdb.dbo.dbfilesize (db, fileID, filesize)

 exec sp_MSforeachdb @command1 =

  'select db_name(dbid), sf.fileid, sf.size

  from sysdatabases sd, ?..sysfiles sf

  where db_name(dbid)...

Steve's solution is pretty nice in that it generates the FTP script file for you using FSO.  Other than that, the process is the same. 

Concerning the original post, if...

I agree with the above post by stacenic. 

To be more specific, add a "Execute Process Task" as the last step.  Within this task, call a batch file like...

C:\FTP_to_Unix\ftp_script.bat

This...

Have you checked this site?

http://www.ibdatabase.com/index.html

I'm out of ideas if its not a security issue with agent.

We pull data from DB2 and it seems like I remember running into an issue where we could not use the "IBM OLE DB Provider for DB2 Servers", but instead...

I would have to disagree with Linda's post.

I have created DTS packages on an WinNT workstation as well as XP, never on the server.  I've been successful in scheduling all...

Now that's funny!!! 

So it's not an issue of having the correct drivers on the workstation where the DTS runs fine interactively from EM, but not having the correct drivers on the server,...

So Interbase 6 is installed on the same server as SQL Server, correct?

Yes, I was told it was a bug also.  It was recommended that I install SP3a on the workstation with EM.  I was also told that this should fix it...

That's the option I normally would use, but I know with these questions that they post, there's always an off the wall way of doing something, so I always check...

Greg,

Thanks for the reply.  SQLDTS.com is often a resource that I use and recommend, but my first source is always this forum.  I always get a quick response and meaningful...