So in an effort to start with a fresh clean install, I uninstalled everything and now have an instance on the failover cluster that I cannot get rid of...Everything I...

Yes that is exactly what I want to do...Active/Active...Ok thank you very much for your help...

As I understand it then...I would load instances, 1 on each box...Then go to one...

Sorry it only dycrypted in 7.0, if I am not mistaken the encypt algorithm changed w/ SQL 2000 release...I generate the code (which spits out the code to create the...

Awesome, that's what I needed...

Thanks all!

I knew it was something so simple! That worked, thanks!

SQL Server has changed the way the DTS packages are displayed and developed.  In 2005 to develop SSIS packages you use a tool that installs with SQL Server Integration Services. ...

Are you trying to create a new SSIS package or save a 2000 DTS package in SQL 2005?

The tool in SQL 2005 to manipulate SSIS packages is SQL Server Business...

Thanks both of you for your options...I tried both and I think that the 'out the box' solution is exactly what I need...

I adapted it and it works like a...

Okay I have imported the table let me make sure it is something my developers can use...Thank you for your help and I'll keep you posted...

Christine

Thanks guys for your help...here's how we decided to tackle the issue, forgive my simplistic explanation:

I developed a sproc that will gather the data along with the rep_id....Then my developer...

Okay,

What I decided to do was create a sproc that would gather the data...Then I created a DTS package that:

1. Connected

2. Run SQL Task ( EXEC uspSproc)

3. Then send e-mail

4....

Kenneth, you're awesome, I can actually begin to envision the code...let me work on it and I'll keep you posted on my progress...I stink at actual coding so I am...

OKAY, allow me to go over the steps with you:

• I would store the results for ALL rep's in a temp table?.?
• Create another temp table that holds the email addresses that...

I apologize I should have been more clear:

Each rep should get the list that's pertinent to them, not the entire reult set...

So the loop will work if I am sending...

I would like to see some sample MS SQL server standards documentation writing guides or similar...Any guidance in that area would be idea...Also, product review to assist the newbie in...