Our SA has managed to use DTS with the 2000 Designer tool on our 64-bit SQL Server 2005 box - don't know how, although he told me "Left the DTS...

I wish. This is our development box, which has limited space - not only that, but our SA doesn't allow DBO's like myself manage any files. Or do much of...

YUp - just came up against that wall: Primary filegroup for my dB is full. :angry:

Thanks! I'll it give it a try now.

Much appreciated

After summarizing the data, most of the queries run against the summary table, but here's one that uses both:

DECLARE @CurrentDate smalldatetime

SET @CurrentDate = (SELECT CAST(MAX(ProgramStartDate)AS SMALLDATETIME) FROM TABLE2)

DECLARE @seq_no...

Does VS2008 include the ability to edit DTS packages on a SQL2005

Gail - here's the table structure for the big 70M record table (TABLE1), which has 10M records per day and one of the summaries (TABLE2). Also, the query that summarizes...

Great suggestions. I'll review the majot queries against it and what columns they're joined on and/or are used in where clause.

The 'date' column is actually a CHAR(10) 'yyyy-mm-dd'. I was...

I hear you. Hey, the use of Excel wasn't my choice, but unfortunately I had to deal with it 🙁

Thanks - you're right. I just needed to add enough ticks +''''+@vho+''''+.......

🙂

Thanks for the suggestions, but it still returns results without single quotes, so thinks it's looking for a column name. i.e. instead of SELECT vho_cd ..... I want SELECT...

Thanks Lynn - worked beautifully!

Just want to close this by saying that Disconnected Edit worked great! Thanks so much for the tip!!!!!

Thanks! I'm not familar with disconnected edit. I'll do a search, or is it something only known to gur's

Hi Philip,

Well I did something like that - didn't properly detach dB. I believe it was aggravated by the fact that a backup job was trying to run, and had been...