I would setup a scheduled job, remove the schedule. Then write a stored procedure to check the execution status of the job and call sp_start_job to start it. This procedure...

Have a look at "Text in Row Data" in Books Online.

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface

Don't use BCP, use BULK INSERT. Load the table in a staging table first. Make sure you check out "Optimizing Bulk Copy Performance" in BOL.

Then use stored procedures to...

The package is stored in sysdtspackages as a binary object. What you'll need to do is,

a) manually open each package and check the required properties. (got some time to waste...

Check if you have the auto-close option set. When you expand the databases folder in EM, it will check the status of each database. If they are set to auto-close,...

Re-apply service pack and/or re-install client tools. Something else that was installed may have replaced one of the necessary DLL's.

Hope this helps

Phill Carter

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

Colt 45 - the original point and click...

Import your data into a staging table first. Then do all your de-duping for insertion into the destination table. This way you don't have to fiddle with PK's.

Hope this helps

Phill...

Use a format file. Check "Using Format Files" in books online.

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface

If you're using SQL 2000, use a table type variable.

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface

Are all these databases on one server?

If you perform an hourly transaction log backup, and it takes nearly an hour, maybe you should look a doing them more often, or...

Very familiar ... more often than not it relates to a security issue.

Can you provide a bit more info on where you receive this error?

Hope this helps

Phill Carter

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

Colt 45 -...

Ummm ... maybe you're missing something.

I have a couple of views defined that use a select statement in the FROM clause.

CREATE VIEW dbo.vw_AsxRptCosts



AS



SELECT

UserID

, ItemMonth

, ItemYear

, SUM(

CASE

WHEN...

Are you sure you are using the correct mail profile? The SendMail task will only show local profiles.

You need to log into the server and edit the DTS package. Or...

Couple of things to check,

OS and SQL service packs at same level.

Same MDAC on both machines.

Any other DB type application on the slow server? Something that could require older DLL...

quote:

---

Why not do a backup of your DEV and restore on TST and STG. This would be much faster then DTS and...