And here's the other two.

System1 = SQL2008 RTM Enterprise

System2 = SQL2005 SP3 Standard

Both on Win Server 2003 R2 Standard, one dual core CPU, 3.75GB RAM

When I get home I'll...

Apologies for the delayed response - my PC died!

I'm currently re-running the script (from the OP) on a SQL2005 and a SQL2008 on the same machine

In the meantime here is...

Hi Jeff

I'm unable to run the second script as the servers I can use here do not have AdventureWorks installed. I will run the second one from my home machine...

Jeff Moden (9/20/2010)

Paul White NZ (9/20/2010)

My understanding is that...

I would like to help - is the latest code that Jeff would like us to run in the original post?

Hear hear!

I have lost count of the amount of times that I haven't even had to ask a question because it's been exhaustively answered here! Thank you all.

I use 2 on a standard edition SQL2008. IIRC 3 is also supported, only High Performance isn't.

One thing to note is that Standard doesn't support database snapshots, so you can't...

All...

Thank you Pradeep.

Still no joy though - over 600MB free when I started the SP1, and it still ran out of space! Back to the drawing board...

No, it's a ticket/incident/change management application - Remedy.

Thank you for your responses, Jeff and Todd.

Even using the wizard to create the initial package I would still have to go in and manually edit about 2000 of the...

Thanks Tod.

It's as I feared then - I will at any rate have 1000 distinct OLE DB Sources/Destinations to put together.

I counted the tables, there are actually 3000 of them!!

Yes. To clarify:

All source tables are in the same Oracle schema.

All destination tables will be in one SQL Server database.

I see. Odd that it won't even let you uninstall.

I got through SP1 and CU8 fine after that. It was the inital setting the same locations through the GUI that...

I got the same error yesterday, and solved it by running setup from the command line:

setup.exe /INSTALLSHAREDWOWDIR="D:\Program Files(x86)\Microsoft SQL Server" /INSTALLSHAREDDIR="D:\Program Files\Microsoft SQL Server" /ACTION=install

It appears to be a known...