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

If you don't have a 'On Failure' workflow and you have the 'Fail Package on first Error' option enabled then the package will fail.

Hope this helps

Phill Carter

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

Colt 45 - the...

In the top part put the server name and connection details and messages will be logged to that server. Useful if you have packages running on a number of servers....

The time you have given as an example looks strange. What format is it?

For reqular datetime fields you can use the CONVERT statement and include a style parameter,

eg:

CONVERT(varchar(10), Date_in, 103)...

Are you asking what the difference is between a DTS Package and a SQL Agent Scheduled Job?

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface

From BOL,

quote:

---

For stored procedures, SQL Server uses the SET ANSI_NULLS setting value from the initial creation time of the stored procedure. Whenever...

You can get helpful debugging info if you have package logging enabled. This can be turned on using the Logging tab in Package Properties.

Unfortunately, if you haven't already enabled the...

You can approach this two ways,

1. Put your SQL Statement in a stored procedure and use the RAISERROR command to signal a failure condition. Then set up your workflow appropriately.

2....

The Typeid is an integer value that indicates the datatype of the global variable. This is needed because all the parameters that are passed to DTSRUN are passed as strings.

I've...

I've found this same problem before, I think BOL might be out of sync with service pack changes.

There are two other methods you can try to set the SQLStatement,

1. USe...

Can you run the VB program as a scheduled job without using DTS?

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface

Regardless of how its developed, or where it's stored, the DTS package will always run where it was executed from.

EG: If you use SQL Enterprise Manager on your workstation to...

The ST-INFO/SYSTEM account is a local account. You won't be able to use that account on the other server. Are your servers running on a domain? If so, try using...

Do you have any MsgBox or InputBox statements? They won't work when running as a scheduled Job.

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface

If your service packs are up-to-date, then there shouldn't be any problems. There were some changes to the object model between the service packs.

Hope this helps

Phill Carter

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

Colt 45 - the...