The message box will display if you run the task interactively.  In a job, I believe it will stop the activex script from running.

I find that I have to disable the step (workflow, disable), then I re-enable in code:

Option Explicit

Function Main()

Dim oPkg

Dim oStep

' Get reference to the Package

'------------------------------------------------

 Set oPkg = DTSGlobalVariables.Parent

' Used...

Are you logging the package?  You can look at the package log to see if perhaps there are errors with some of the steps.

Is the query timing out?

If you can trap the error, sometimes the DBEngine.Errors collection will give you a list of much more intelligent errors.  http://www.devx.com/tips/Tip/12413

Using anything other than the DTS Designer will hose the display.  If I am going to only use code once to alter the DTS package, I do it at the...

It isn't too hard.  First, though, what is it you want to do once you open the saved DTS package? This will color my recommendation.

I wasn't able to replicate your error.

What I normally do is to generate scripts on the source database, then run those scripts on the destination.  Then I just do a regular...

The database file is indeed completely empty.

Do you have a back up of the mdb?  The access database should not have any data, just tables linked to the SQL Server,...

The web application (yes, there is an application there) that has a web page called index.asp is running a query on line 85.  Somewhere before that is a connection string...

Just so that I am clear.  From all of your post, you have an Access database (mdb) that has a linked table that is a SQL server table.  But you...

By default, SQL recognizes mm/dd/yy.  However put the following statement before your query and it should work:

SET DATEFORMAT DMY

Or you can use:

select convert(datetime, left(finfo,20), 103) frpm #t

Thanks for the question...

I'm going to assume that you are using Query Analyzer.

In the Tools menu, select the Options menu.  Click on the Connection Properties tab.  About half way down there is a...

When you run your original query do any of the records have a null masterregis.claimstatus?  Also, is there are record in [status table] where claimstatusid has a value of '' (empty...

I'm still not clear what you are trying to do and what you mean by null values.  The change you provide actually doesn't change the query at all, since the...

"Can anyone tell me why this Query will not return "ONLY" NULL data?"

What makes you think that this query might return only null data?  The only mention of null in...