Also, make sure you have a good read of the Upgrading topic in SQL 2000 Books Online. Especially the first topic called "Preparing to Upgrade from SQL Server 6.5"

Hope this...

Yes as usual with SQL 6.5, you have to jump through three or four hoops to do one task. Just be sure that you do each step as documented and...

Have you tried re-creating the mail profile and restarting the SQL service?

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface

To get a proper date comparison you need to do two conversions not one. First convert to varchar to strip off the time and then convert back to datetime for...

Bulk Insert will only import one file at a time. Can the user run your program for each file?

Can you re-engineer your program to loop through the files importing them...

What is the recovery model for the database?

Do you do transaction log backups?

Has there been any large updates to the database, or any reindexing? Both of these operations can cause...

The following script returns the RowsComplete for a Datapump task and build a message string.

You'll need to put the name of you step in the line that reads,

Set oStp =...

If package logging is enabled before the package is run then DTS will log execution info for each step in the package. It won't log anything if the package...

What MDAC version are you using?

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface

If possible, you could put the values for the IN clause into a table. Then just use that table in the FROM clause.

Hope this helps

Phill Carter

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

Colt 45 - the original...

For the tasks that don't execute, do you have single or multiple precedence constraints? If you have multiple constraints, bear in mind that these work as an AND not an...

What type of tasks are you using? If you're using an ActiveXScript task, are you setting the task result correctly? Do you have any Workflow scripts that determine if the...

Well from the Error message it looks like the DTS package is executing. You'll probably find that its trying to access a file share or something that the developers login...

Probably the best approach to making your DTS packages portable between each environment is to make all the environment dependant settings as dynamic as possible.

The way I achieve this is...

Check out "Optimizing Bulk Copy Performance" in Books Online. It has a few tips for getting good performance.

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface