What does the query plan for the SQL statments being executed look like? Is there a lot of parallel execution taking place? What sort of processors do you have? Maybe...

When a DTS package is run, uses the security credentials of the process that executes it.

In this instance it would be using the security credentials of the Workgroup Web Server.

Have...

For the import from A to B, do you have any transformations, or is it a straight Datapump from one table to the other?

If not, create a staging table that...

As steven_white40 has suggested, you can save your packages as structured storage files. When the file is created for the first time it only saves the latest version of...

So is either the txt file or the DB on the domain? If so then your package will need domain privelages to access that resource.

Hope this helps

Phill Carter

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

Colt 45 -...

The packages are stored in the sysdtspackages table as binary objects so you won't be able to query the table for anything.

You can put together a VBScript to open the...

1) Do you have Package logging enabled? If so, is there any messages there?

2) Can you modify the stored procedure to provide some progress messages. Either write to a table...

Not the would be anymore managable than DTS. Informix isn't one of the mainstream DBMS's that third-party developers provide a lot of native support for.

In the DTS package what data...

Not sure if it'll work but how about using OPENQUERY. You might have to shelve the sp_MSforeachDB routine though.

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface...

Basically the package must be referring to a resource on the AD Domain. Given that, it needs to provide appropriate login details to access that resource.

How does the ASP page...

You don't need to add a workflow script to every task. Just the one after your Transform task. In that task you could use a workflow script or a task...

It's probably best to keep to structured storage files. Unless you can be sure you will have VB available whenever you want to load the packages.

Hope this helps

Phill Carter

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

Colt 45...

Yes you can. It won't perform as quick as a transfer database objects task in DTS. You are also tied to transferring one table at a time. If you group...

You need to include the 'use ...' as part of the EXEC

eg:

exec ('use ' + @dbName + ' dbcc showcontig with tableresults, all_indexes')

Hope this helps

Phill Carter

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

Colt...

In your example, you won't get the output from your print statement because the error occurs in the parse and compile of the statement. So the @@ERROR variable isn't set.

Hope...