Post reply

DTS to Excel

  • June 20, 2014 at 4:33 am

    #396941

    I know how to use DTS (yes. still using DTS) to output from an SQL table to excel. Is there any way i can make the excel read only after that?

  • June 20, 2014 at 10:13 am

    #1723651

    You can use a Transform Data Task with your DB Server as the Source and an Excel Connection as your Destination.

    To make it read-only, you might need a script task. I'm not sure about the code you need.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • June 20, 2014 at 10:23 am

    #1723657

    Couple of months back I used a VBScript in Script task component of SSIS package to change file extensions.Not sure about DTS.

    --------------------------------------------------------------------------------------------------
    I am just an another naive wannabe DBA trying to learn SQL Server

  • June 20, 2014 at 11:07 am

    #1723665

    Sachin Nandanwar (6/20/2014)

    Couple of months back I used a VBScript in Script task component of SSIS package to change file extensions.Not sure about DTS.

    How does that help?

    I know that I didn't give the complete solution but yours is completely unrelated.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply