Forum Replies Created

Viewing 15 posts - 1 through 15 (of 760 total)

  • RE: TSQL to create Excel 2013 file

    Does this work for anyone??....Can someone please test the code on your local box and let me know??...Thanks

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    September 2, 2014 at 9:39 pm

    #1742663

  • RE: TSQL to create Excel 2013 file

    Lowell (8/25/2014)

    correct me if i'm wrong, but I thought noone can write to a file on the root of the C drive unless they are running elevated, admin priviledges:

    so C:\CambridgePubs.xlsx...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    August 31, 2014 at 11:57 pm

    #1742147

  • RE: TSQL to create Excel 2013 file

    LutzM (8/24/2014)

    What permission does the user have who's running that code?

    Based on MS Technet

    Only members of the sysadmin fixed server role can execute sp_OASetProperty.

    If you're not a member of the...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    August 24, 2014 at 5:37 am

    #1740571

  • RE: TSQL to create Excel 2013 file

    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...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    August 24, 2014 at 5:32 am

    #1740568

  • RE: TSQL to create Excel 2013 file

    Eirikur Eiriksson (8/24/2014)

    vinu512 (8/24/2014)

    Eirikur Eiriksson (8/24/2014)

    Further on Lutz's question, what is the output of the code in your initial post? Note that all the sp_OA* procedure return 0 if successful,...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    August 24, 2014 at 5:02 am

    #1740566

  • RE: TSQL to create Excel 2013 file

    Eirikur Eiriksson (8/24/2014)

    Further on Lutz's question, what is the output of the code in your initial post? Note that all the sp_OA* procedure return 0 if successful, otherwise a non-zero...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    August 24, 2014 at 3:18 am

    #1740549

  • RE: TSQL to create Excel 2013 file

    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...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    August 24, 2014 at 3:15 am

    #1740547

  • RE: TSQL to create Excel 2013 file

    Eirikur Eiriksson (8/24/2014)

    Quick thought, looks to me that the only thing missing is to enable Ole Automation Procedures

    😎

    Enable Ole Automation Procedures in T-SQL

    sp_configure 'show advanced options', 1;

    GO

    RECONFIGURE;

    GO

    sp_configure 'Ole Automation Procedures',...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    August 24, 2014 at 2:57 am

    #1740543

  • RE: Creating tables on the fly with SSIS

    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...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    September 25, 2013 at 11:54 am

    #1653295

  • RE: Dynamic Data Export

    So...is there no way of doing it??

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    September 23, 2013 at 2:05 pm

    #1652469

  • RE: Dynamic Data Export

    Guys,

    Any Luck???

    I haven't been able to find a way around this one yet.....Any help guys??

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    September 20, 2013 at 1:39 pm

    #1652035

  • RE: Unexpected Behaviour With SQL Server :,(

    Shadab Shah (7/17/2013)

    vinu512 (7/16/2013)

    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:...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    July 17, 2013 at 1:01 am

    #1633094

  • RE: Unexpected Behaviour With SQL Server :,(

    Shadab Shah (7/17/2013)

    kapil_kk (7/17/2013)

    vinu512 (7/16/2013)

    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...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    July 17, 2013 at 12:47 am

    #1633087

  • RE: Help needed for Select Query

    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...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    July 17, 2013 at 12:36 am

    #1633084

  • RE: Unexpected Behaviour With SQL Server :,(

    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...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    July 16, 2013 at 11:55 pm

    #1633074

Viewing 15 posts - 1 through 15 (of 760 total)