Jack,

For the most part this table is read only. The data used in the table is used to load a DTS package Globals at runtime for execution. In...

Thanks, noeld that works perfectly. I assume how it works is, that because it is an update that both the inserted and deleted "objects" are available.

Works Great!

Select * from

(

Select * from cub_elec_hist

UNION ALL

Select * from msh_elec_hist

) a

WHERE TYPE = 'RES' and mtyr_period = '12/1/2002'

Thanks Andy

I tried this and I got the following error:

Incorrect syntax near the keyword 'WHERE'.

Select * from

(

Select * from cub_elec_hist

UNION ALL

Select * from msh_elec_hist

)

WHERE TYPE = 'RES' and mtyr_period = '12/1/2002'

...

Short and Sweet

Add a reference to the Microsoft DTSPackage Object Library

Then I uses this code:

Private Sub Command1_Click()

Dim objDTSPackage As DTS.Package

Set objDTSPackage = CreateObject("DTS.Package")

objDTSPackage.LoadFromSQLServer "YOUR_SERVER", "USER", "PASSWORD", "DTSSQLStgFlag_UseTrustedConnection, , , ,...

Well it works! I really have no idea why. I rebooted the server this morning and SQL Mail came right up. No clue. Thanks for all the feedback,...

Allen,

I use the admin account for everything on my server. After I could not get it running I have pretty much gone through the SQL Mail steps 2, 3...

I could be server version issues.

If the server you are taking the packages from has a high version then destination server you will get that error.

or

I had the...

Well I got it working! I don't know what did it. Things like this tend to frustate the hell outta me. Fixing something and not knowing what...