Viewing 15 posts - 16 through 30 (of 43 total)
Why would SSRS using an OLE DB provider give me a different result the SSIS using the same provider?
The goal here is to extract some data from Oracle for use...
January 25, 2010 at 10:54 am
The problem directly addresses two different technologies - SSIS and Oracle. I cross-posted in hopes of getting help from someone who has solved this from either perspective.
January 22, 2010 at 2:13 pm
Oracle client has been installed, and I can access the data from the server using SQL*Plus. The TNSNAMES is correct. In SSIS I can "Test Connection" successfully. ...
January 22, 2010 at 2:11 pm
Years ago I took over managing a database system (Ingres 6) which performed poorly. It had been allowed to use too little memory and was missing patches. After...
October 1, 2009 at 2:06 pm
Deep in our application we have a set of background jobs that send users email and update data based on application data conditions. These email/update jobs, run from the...
September 9, 2009 at 11:20 am
This is helpful - thank you.
DelayValidation is false at all levels. The connection to the remote SQL Server uses the same domain authenticated account that runs the SQL Server...
July 22, 2009 at 8:02 am
Ok, I sort of understand a little - but I am confused.
How do I install a 32-bit Oracle x86 provider (driver?) on a 64-bit server and set up...
May 26, 2009 at 2:18 pm
My problem is not moving the package between systems. The problem is installing an Oracle OLE DB provider (driver) which is useable from within BIDS on my 64-bit Windows...
May 26, 2009 at 12:28 pm
I think you're right. I created a new test db, set up a restore using management studio, and I see two restore files with the same db name, etc.
Live...
April 29, 2009 at 10:00 am
No, this was never resolved. We have installed SP3 on our servers, and will not install the post-SP3 "CU" updates unless we find a specific problem they will solve....
April 20, 2009 at 7:04 am
It turns out that our vendor was using the MSXML parser in an unsupported manner - see KB815112.
The solution to this is to edit the Registry and delete...
March 16, 2009 at 10:33 am
I upgraded a second server, with the same result. Seems like Microsoft has a real bug here, or I'm missing something. 2 of 3 have failed after upgrade....
February 17, 2009 at 8:23 am
I created the packages on my desktop using BIDS and saved them to a server, using "save as". Evey column was defined, with name, length, and a type of...
January 23, 2009 at 1:37 pm
In the Flat File Connection Manager Editor specify a fully qualified file name: \\server\share\directoryame.ext
January 22, 2009 at 8:16 am
Microsoft SQLIO Disk Subsystem Benchmark Tool
has been very useful in comparing different disk IO systems. I've seen values between 600 on my desktop PC and 8000...
December 29, 2008 at 10:30 am
Viewing 15 posts - 16 through 30 (of 43 total)