Viewing 15 posts - 346 through 360 (of 1,155 total)
It depends on the OLE DB provider I think.
It's possible the Microsoft OLE DB provider for Oracle (which is deprecated if I remember correctly) has a fast load option, but...
March 4, 2014 at 1:24 pm
quackhandle1975 (3/4/2014)
Many thanks for all your replies and yes I do agree that running CHECKDB on a dummy database is not the same as running it in production and my...
March 4, 2014 at 1:19 pm
arkiboys (3/4/2014)
I would like to be able to send the report via email.
I have created the custom datasource...
but in the subscription I do not see the Email whereas I see...
March 4, 2014 at 12:08 pm
shannon.proctor (3/4/2014)
Can I assume that it's just this particular component since all other scheduled SSIS packages run successfully?
Yes it this particular component "SAPBI Source connector"
--
SQLBuddy
March 4, 2014 at 11:58 am
ms-techie (2/23/2014)
Now in this scenario, we get the following error
"The process cannot access the file because it is being used by another process " and then the job fails ...
March 4, 2014 at 11:56 am
shannon.proctor (3/4/2014)
I'm running SQL Server 2008 R2 SP2 and I have scheduled other SSIS packages...
March 4, 2014 at 11:48 am
Yes it doesn't help thatway. You need to run it on the actual DB or a copy.
--
SQLBuddy
March 4, 2014 at 11:43 am
wak_no1 (3/4/2014)
What's the most straight forward to determine what the last cumulative update was that was applied to SSMS?
I know that CU8 is out for SQL Server 2012, I just...
March 4, 2014 at 11:39 am
Thought fast load was available for Oracle destination too. May be I missed it ..
--
SQLBuddy
March 4, 2014 at 8:59 am
NJDave (3/3/2014)
It would run out of space on a 500 GB drive that...
March 4, 2014 at 8:52 am
vsamuel (3/4/2014)
March 4, 2014 at 8:43 am
JoshDBGuy (3/4/2014)
djj (3/4/2014)
March 4, 2014 at 8:34 am
Dennis Post (3/4/2014)
As you mentioned it's a 32-bit system, what are your memory configurations .. Total memory, AWE, PAE, Lock Pages in Memory, Min&Max Memory ..
32Bits
16GB RAM
/PAE
AWE...
March 4, 2014 at 8:28 am
Please check RSLog file for any errors that can guide us in right direction.
--
SQLBuddy
March 4, 2014 at 8:09 am
Ness (3/4/2014)
Many thanks SQL Buddy - I will test and get abck to you to let you know if it worked
You are welcome Ness. Sure, pls keep us posted.
--
SQLBuddy
March 4, 2014 at 8:05 am
Viewing 15 posts - 346 through 360 (of 1,155 total)