I kinda figured that I would do that step, but how do I set the global variable to a value that comes from the result of a query?  I can...

Ok, here's the latest.  I changed my ActiveX code to the following:

Function Main()

 Dim DeleteStmt, SelectStmt, oPkg, oDataPump, sSQLStatement, PullDate

 PullDate = "2005-05-05"

 SelectStmt = "SELECT * FROM schedule WHERE status='A' and DATE=...

I changed line 27 to reference SQLStatement instead of SourceSQLStatement and it worked!  Thanks for any replies to this post.

Ok, I changed DTSStep to DTSTask and ran it. Now I get the following error:

Error Code: 0

Error Source=Microsoft VBScript runtime error

Error Description - object doesn't support this property or method: 'oDataPump.SourceSQLStatement'

Error on...

I found it in on my 2000 server, but not on my 7.0 server.  How do I do it in 7.0?

What is 'disconnected edit'?  How do I get the name from that?

Ok, here's my code of my ActiveX object.  It's the first thing executed in the package.

Function Main()

 Dim SelectStmt

 SelectStmt = "SELECT * FROM schedule WHERE status='A' and DATE= '" & CStr(Year(Date))...

How do I reference the sql of the DTS object that runs my SQL code?  (Sorry for the delay, but I got pulled off on another project)

Ok, now I have to set this up in SQL Server 7.  I have it all done except for the Dynamic Properties Task step.  There is no Dynamic Properties Task...

I have my local server, the destination server setup to use the Local System Account to log into windows.  

The DTS package uses an anonymous connection to log into the source...

How cow.  I got it to work.  Well, actually you told me how to get it to work.  Now that I have this base working, I can run with this. ...

The statement that I have found is the following:

SELECT * FROM SCHEDLE WHERE DATE=CURDATE()

Unfortunately this statement times out.  You would think that the database engine on this machine would be...

provost - how do I dynamically build the SQL statement within an ActiveX Task?

provost - the global variable thing is what I am trying to do.  How do I get the global variable pumped into the sql statement that I am going to...

I tried to put the quotes around the column and table name and it didn't work.  The statement didn't even parse.