Viewing 15 posts - 1 through 15 (of 760 total)
Does this work for anyone??....Can someone please test the code on your local box and let me know??...Thanks
September 2, 2014 at 9:39 pm
Lowell (8/25/2014)
so C:\CambridgePubs.xlsx...
August 31, 2014 at 11:57 pm
LutzM (8/24/2014)
Based on MS Technet
Only members of the sysadmin fixed server role can execute sp_OASetProperty.
If you're not a member of the...
August 24, 2014 at 5:37 am
Permissions don't seem to be the issue either. I am doin this on my laptop. There is only one user on my laptop. So, permissions are also fine.
Please help...
August 24, 2014 at 5:32 am
Eirikur Eiriksson (8/24/2014)
vinu512 (8/24/2014)
Eirikur Eiriksson (8/24/2014)
August 24, 2014 at 5:02 am
Eirikur Eiriksson (8/24/2014)
August 24, 2014 at 3:18 am
LutzM (8/24/2014)
this is not working for some reason
doesn't include any details what the issue might be.
Is there any error message?
Hi LutzM,
Following is the error message:
Operation is not...
August 24, 2014 at 3:15 am
Eirikur Eiriksson (8/24/2014)
😎
Enable Ole Automation Procedures in T-SQL
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures',...
August 24, 2014 at 2:57 am
Phil Parkin (8/11/2010)
Rich-403221 (8/11/2010)
:ermm: Phil, my apologies.Should have tried it a little more before I ASSUMED that SSIS would be logical. Guess it's not as straight forward as I thought.
Rich
No...
September 25, 2013 at 11:54 am
Guys,
Any Luck???
I haven't been able to find a way around this one yet.....Any help guys??
September 20, 2013 at 1:39 pm
Shadab Shah (7/17/2013)
vinu512 (7/16/2013)
July 17, 2013 at 1:01 am
Shadab Shah (7/17/2013)
kapil_kk (7/17/2013)
vinu512 (7/16/2013)
July 17, 2013 at 12:47 am
Very nice work Alan.
I converted Alan's code to work Dynamically(Just in case you have more than 2 tables) as follows:
IF OBJECT_ID('tempdb..TargetActivity') IS NOT NULL
DROP TABLE TargetActivity;
CREATE TABLE Customer
(CustomerIdint...
July 17, 2013 at 12:36 am
Is Auto Update of Statistics on the Database Disabled??....Check both AUTO CREATE STATISTICS and AUTO UPDATE STATISTICS.........If any of them are disabled then enable them as follows:
-- Enable Auto...
July 16, 2013 at 11:55 pm
Viewing 15 posts - 1 through 15 (of 760 total)