When I had this problem a while back the only way I got it to work was to reinstall all of SQL 2005 together.

I think I tried that and it didn't work for me. I had to reinstall with Integration Services selected in order for it to work properly.

Thanks for your post.  I didn't know about I3 so I'll definetly check that one out.

-Brent

Thank you for your response.

We're still searching for the best solution.  Would you mind saying which products you have used and your thoughts on why you chose them?

Regards,

Brent

I found the solution to my problem on this thread:

http://www.sqlservercentral.com/forums/printtopic.aspx?forumid=148&messageid=260038

Microsoft should post what expressions are valid in the expression builder.

-Brent

when I run "start /wait setup.exe /qb REINSTALL=SQL_WarehouseDevWorkbench REINSTALLMODE=OMUS" I get the following error:

"Please go to the Control Panel to install and configure system components"

Any ideas?  I can...

I'm running SQL 2000 Ent SP3a

The login seemed okay in the database users view in EM.  The login was there and not blank.  We could use the accounts and everything seemed to work okay, except...