If i am understanding your post correctly, you are trying to copy the whole transaction table(s) every 24 hours, when in fact you only need thouse transactions which have been generated in...

As an alternative (Especially if you dont have Exchange)

Try xp_smtpmail

http://www.sqldev.net./xp.htm

My own method of dealing with this would be as follows :-

Open the file in Textpad (do a google search if you dont have it).

Use Search>Replace on the hyphens and...

Hi

Right Mouse the table, select All Tasks>Export Data

Follow the wizard through, and just change the destination table name to authors_copy.

Stewart

Im no expert, but based on you results the first if statement is failing, try the following (and i make no promises)

if DTSSource("Col009") = '' then

    DTSDestination("Col009") = ''

Note - 2...

Connor

You are more than welcome, glad i could help

Russ

EM does not need to be running in order for scheduled jobs to run, if you expand the "management" section under your SQL server you will find SQL Server Agent. ...

Hi Connor

I can't help you with your second problem, but hope this helps with the first one:-

http://www.sqldts.com/default.aspx?246

Russ

Karen

Have just implemented something similar to what you are trying to achieve, please let me know if you still need assistance.

Russ

If it is any consolation, i am having a similar problem, but i have identified it as the Outlook .pst file will either be locked by Outlook, in which case...

Is your outlook client running? Microsofts help for getting SQL Agent working requires Outlook 2002 to be running in the background whan using SQL server