Nigel -

quote:

---

>> That's similar to my first solution. It's what I always do to create things manually as it's quick and lets...

Steven - You can view and edit the DTS packages if you have SP3 on your 7.0 machines.

Hope this helps.

David

O.k. Back to work... Now to solve the mystery. No, I did not copy and paste nor did I do anything as robust as what you guys did. I just...

Interesting configuration I created a table to match and inserted about 500 rows then doing a select from that table brings back all records in about 4...

No, you can use an Execute SQL task within DTS for the sendmail and use the same code you have in the job step. The one concern with doing this...

Sorry, one additional note, I agree with Steve's suggestion for taking the mail step out of the package and making it part of the job. I recently started doing that...

Are you doing this within DTS and if so, are you using the "On Success" or "On Completion" links between the job steps?

If yes, then I am puzzled.

If no,...

Enterprise Manager. Using the SQL Server 2000 Client Tools expands the tool set for DTS and the packages developed in the 2000 client tools will run against a 7.0 SP3...

What I have found to work is by setting up an Excel file as a data source, setting up the SQL data source, and finally utilizing a transform data task...

bkelley,

We have some very similar processes from an Alpha system and we too use the "tickler" file to show the Alpha process is complete. Always been a struggle with the...

Well, it gets more interesting and your question made me try something different. It appears that I can select from the UNC, \\ServerA\c$, from some machines using SQL QA but...

No problems noted here. Make sure that you do the backups as requested and you should be all set if something goes awry.

The nice thing about going to SP3...

Andy,

Thanks Andy! However, no on the permissions as I have Domain Admin privs throughout. The error I recieve is as follows;

Server: Msg 7399, Level 16, State 1, Line 1

OLE DB...

Yes, you could use DTS, Data Transformation Services, to take care of that for you. Once you get the DTS package set up, it is easy to schedule it for...

I believe that Nigel touched on this in his first post but just to clarify, an automated install process is necessary for Service Pack deployment, etc. Tough enough with 15,...