Can I get the same type of information from Query Analyzer -- # of records, size of table in KB, etc. ??? 

What is the sproc or t-sql to get...

Apparently this is a bug with EM.  I applied SP3a and it appears to be fixed.

Check out the article by Andy Warren...

http://www.sqlservercentral.com/columnists/awarren/copyingdtspackagestoadifferentserver.asp

If you're using ODBC to connect to the datasource in your code, you could create a script to go in and alter the registry and update the server in the...

Thanks for the replies!!!

This is exactly the type of information I was looking for.

This is what I use when I change the SQL of a datapump...

 ' Get reference to the DataPump Task

 Set objPkg = DTSGlobalVariables.Parent

 Set objDataPump = objPkg.Tasks("DTSTask_DTSDataPumpTask_1").CustomTask

 ' Assign SQL Statement...

Is it as simply as a typo -- try..."DTSTask_DataPumpTask_1" with the underscore before the task number.

Something that I just noticed in Access queries, if you go into the properties of the query, you can see properties named "Record Locks" and "Recordset Type".  What are these...

Along the same lines as Kevin suggested, use pass-through queries in Access so that the query is executed on SQL Server.

How are you going about reading the ini file value?  Are you using the API call or do you know of a way to get to the value through the...

You can use the following to get at each db size on the server and then sum for a total.  This will give you a record for the db (fileID=1)...

So, are you saying that there is NOT a method to get at this value from within the DTS object model?  And the only way that I can read the...

This is exactly what I have done!!!

I have my information in a table on the server and then I query the table to retrieve the connection password and save this...

So you're using an .ini file in a dynamic properties task to retrieve all of your information?  Is the .ini file saved on the server I'm guessing?

Yes -- if you...

This message is part of the job history (scheduled job failed). 

This is what I get from sp_configure...

name     min        max                  config_value      run_value

locks     5000      2147483647        0                     0