SSIS - how to output the excel file to directory in network drive?

nononame2021 256 Reputation points
2021-11-14T06:45:58.227+00:00

i am using SSIS, and i would like to output the excel file to network drive C:/temp/ouput folder.
how can i develop a map drive in SSIS or SQL server agent job to do that?
after map drive , then i would like to schedule a job to execute SSIS to output file to network drive.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,457 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. nononame2021 256 Reputation points
    2021-11-14T12:39:18.863+00:00

    can SSIS execute .bat file?

    0 comments
  2. ZoeHui-MSFT 33,126 Reputation points
    2021-11-15T01:32:39.03+00:00

    Hi @nononame2021 ,

    You may use Execute Process Task to execute .bat file in SSIS.

    execute-process-task

    You may also use file-system-task to perform operations on files and directories in the file system.

    Some samples for your reference: https://www.tutorialgateway.org/copy-files-using-file-system-task-in-ssis/

    http://www.techbrothersit.com/2014/01/ssis-how-to-execute-batch-file-by-using.html

    Regards，

    Zoe

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments