Viewing 9 posts - 1 through 9 (of 9 total)
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...
March 19, 2004 at 9:02 am
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.
March 17, 2004 at 2:22 pm
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
February 26, 2003 at 11:02 am
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'
...
February 26, 2003 at 10:42 am
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, , , ,...
October 17, 2002 at 9:38 am
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,...
October 10, 2002 at 10:49 am
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...
October 9, 2002 at 3:11 pm
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...
September 12, 2002 at 9:40 am
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...
September 12, 2002 at 9:22 am
Viewing 9 posts - 1 through 9 (of 9 total)