I have also found that installing a 32 bit instance of SQL Server seems to be the best way. I have had to link to all sorts of legacy systems...

This may be a dumb questions, but do you actually have a report open? It will not show up if you don't.

You can indeed install both the 64 bit and 32 bit Oracle client. If you are using 10.2.0.1 client, make sure you patch it to 10.2.0.3 or you will have...

Is this Excel 2003 withthe 65K row limit?

If so, I am not sure if SSIS can automatically open a new sheet.

I am thinking that your connection is to a specific...

You can set it on the General tab of the "job step properties".

Just type it in the command box.

Example: "d:\Program Files\Microsoft SQL Server (x86)\90\DTS\Binn\DTExec.exe" /SQL "\<package name>" /SERVER <server...

I did uninstall reporting services and then I reinstalled it it as a new instance, but only installed 32 bit reporting services.

I was able to reconnect to the original reporting...

Thanks for your answer. It would seem that 9i client is not certified for Windows Server 2008 or Vista. I think I had to download 10.2.0.4 client for Vista. This...

Thanks for the answer. The problem I foresee is that I need the Oracle 10 clients to work with SSIS because of the "program files (x86)" issue. Am I going...

Just curious - does column 35 happen to be the last column?

I have seen cases where the line terminators were not defined correctly on the data source and the next...

You do not (per chance) also have Office 2003 installed do you. I know there are issues starting up some of the programs if you do - specifically Word.

There are scripts you can find to move your users. You can also use the copy database function and check to also copy users. We have done both successfully during...

Starting out a couple of years ago, I relied on maintenance plans and the GUI in general.

As I gained experience and found that the GUI did not always produce the...

Are you sure it is hanging. A db that size would take some time to convert. Are you getting any kind of messages in the output.

I just used SSMA to migrate an Oracle 9.2.0.3 schema to SQL 2005 a few weeks ago. It worked fantastic.

You are correct about the users. I just recreated on the...

Install worked as I thought it would. Pieces already there were recognized.

Install went fine. Updates then picked up everything.