mssql_rules ,

1. He could have either that or dtsrun on his client. Still the package, when runned from the client, will have the...

Jeff,

I am available:

Can you send me an email with your Location in NJ

Thanks

Noel

If you have that error then you ODBC DSN IS WRONG. Use odbc aministrator to make sure that it is connected right!

Well, There is a bridge if you are willing to use

sp_OA stored procedures you can do it in TSQL [Instantiating the DTS.Package (or DTS.Package2) Object].

But I really think that...

the problem with an Update like that is that it will LOCK THE WHOLE TABLE !!

It will probably more efficient to use a cursor with ordered results and in that way...

That's a job for the FRONT END

but if you insist:

If Exists (select * from

tblRC_StandardsTestScores03_04 TS

Inner Join Student_Data_Main SD On TS.Permnum = SD.Permnum

Where TS.Permnum = 2000025822

and TS.TestShortname = 'SFM2'

and Qnum...

chisholmd ,

First If you have a table with  Numbers

1. From 0 to 23 you will be able to generate the 24h in...

I don't think that to have an extra table is bad but you could do something like:

CREATE TABLE TTT (dte datetime, val int)

GO

INSERT INTO TTT(dte, val) VALUES ('2/18/2004 10:00:00', 34567)...

The Count Property of the Fileds is defined as Long which is A LOT.

but if you are retrieving info from SQL Server these are the limitations imposed by Version

CREATE   table T1 (id int , name char (20))

EXEC   sp_addextendedproperty 'MS_Description', 'Employee ID', 'user', dbo, 'table', 'T1', 'column', id

EXEC...