Viewing 15 posts - 211 through 225 (of 234 total)
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...
Mike
“I know that you believe you understand what you think I said, but I'm not sure you realize that what you heard is not what I meant.”...Robert McCloskey
___________________________________________________________________
January 19, 2010 at 5:40 am
This may be a dumb questions, but do you actually have a report open? It will not show up if you don't.
Mike
“I know that you believe you understand what you think I said, but I'm not sure you realize that what you heard is not what I meant.”...Robert McCloskey
___________________________________________________________________
January 4, 2010 at 7:29 am
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...
Mike
“I know that you believe you understand what you think I said, but I'm not sure you realize that what you heard is not what I meant.”...Robert McCloskey
___________________________________________________________________
December 8, 2009 at 6:00 am
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...
Mike
“I know that you believe you understand what you think I said, but I'm not sure you realize that what you heard is not what I meant.”...Robert McCloskey
___________________________________________________________________
December 3, 2009 at 6:01 am
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...
Mike
“I know that you believe you understand what you think I said, but I'm not sure you realize that what you heard is not what I meant.”...Robert McCloskey
___________________________________________________________________
December 2, 2009 at 8:00 am
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...
Mike
“I know that you believe you understand what you think I said, but I'm not sure you realize that what you heard is not what I meant.”...Robert McCloskey
___________________________________________________________________
October 1, 2009 at 8:02 am
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...
Mike
“I know that you believe you understand what you think I said, but I'm not sure you realize that what you heard is not what I meant.”...Robert McCloskey
___________________________________________________________________
September 30, 2009 at 5:48 am
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...
Mike
“I know that you believe you understand what you think I said, but I'm not sure you realize that what you heard is not what I meant.”...Robert McCloskey
___________________________________________________________________
September 29, 2009 at 8:44 am
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...
Mike
“I know that you believe you understand what you think I said, but I'm not sure you realize that what you heard is not what I meant.”...Robert McCloskey
___________________________________________________________________
September 14, 2009 at 9:11 am
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.
Mike
“I know that you believe you understand what you think I said, but I'm not sure you realize that what you heard is not what I meant.”...Robert McCloskey
___________________________________________________________________
August 31, 2009 at 12:01 pm
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...
Mike
“I know that you believe you understand what you think I said, but I'm not sure you realize that what you heard is not what I meant.”...Robert McCloskey
___________________________________________________________________
August 19, 2009 at 6:26 am
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...
Mike
“I know that you believe you understand what you think I said, but I'm not sure you realize that what you heard is not what I meant.”...Robert McCloskey
___________________________________________________________________
June 19, 2009 at 1:56 pm
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.
Mike
“I know that you believe you understand what you think I said, but I'm not sure you realize that what you heard is not what I meant.”...Robert McCloskey
___________________________________________________________________
April 20, 2009 at 8:39 am
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...
Mike
“I know that you believe you understand what you think I said, but I'm not sure you realize that what you heard is not what I meant.”...Robert McCloskey
___________________________________________________________________
April 7, 2009 at 7:55 am
Install worked as I thought it would. Pieces already there were recognized.
Install went fine. Updates then picked up everything.
Mike
“I know that you believe you understand what you think I said, but I'm not sure you realize that what you heard is not what I meant.”...Robert McCloskey
___________________________________________________________________
March 16, 2009 at 8:40 am
Viewing 15 posts - 211 through 225 (of 234 total)