Viewing 15 posts - 646 through 660 (of 2,044 total)
Hello,
You don't have to copy the snap-in line, only the code between
public void Main()
{
....
Dts.TaskResult = (int)ScriptResults.Success;
...
August 18, 2015 at 7:41 am
Did you try a reboot after installing the oracle clients?
Is the oracle client the latest from oracle support?
August 17, 2015 at 8:21 am
What happens if you place the package in a subfolder like c:\packages\ram.dtsx?
August 10, 2015 at 4:34 pm
Got away with changing the connection from native oledb Microsoft Ace... to .NET Provider/Microsoft Ace...
Seems to work in the script component and sufficient for the small excelfiles.
August 5, 2015 at 9:21 am
There is likely a more detailed error description if you click it open.
Example
Executed as user: X\Y.
Microsoft (R) SQL Server Execute Package Utility Version 11.0.5592.0 for 64-bit Copyright...
August 5, 2015 at 5:13 am
Does the sql agent job account have rights on C:\Ram.dtsx? (on the sql server)
August 5, 2015 at 4:41 am
I was misinformed, SA not needed for downgrade ( volume licensing? )
May 22, 2015 at 5:10 am
I believe you will need software assurance for the downgrade (2014->2012) rights.
May 20, 2015 at 9:06 am
"Number" are actually NVARCHAR(768)
->SQLServer does that when there is no precision and scale specified in Oracle
VARCHAR2 columns are returned as NVARCHAR (at least the length is OK)
->Depends on the Oracle...
May 15, 2015 at 9:56 am
Congratulations on passing the STIg audit
May 6, 2015 at 2:11 am
It will be hard to find drivers that connect to Oracle 8i.
Perhaps you could export the database and import it into Oracle 12 and use that as a source for...
May 5, 2015 at 4:09 am
The databases were fully backupped once?
Databases are in full/bulk logging mode?
Perhaps there are long running transactions/replications going on
You could convert the maintance plan to a normal job to see what's...
May 5, 2015 at 4:06 am
How are you quering Oracle through SSRS?
Using SQLServer as a datasource and using the LINKEDSERVER..SCHEMA.TABLE / OPENQUERY notation
Or Using Oracle as a datasource?
Is it possible to post the query?
April 29, 2015 at 9:37 am
Viewing 15 posts - 646 through 660 (of 2,044 total)