Post reply

SSIS package don't running with bat file

  • January 4, 2020 at 6:39 pm

    #3712394

    Hello

    i was created simple dtsx package for copy directory files

    in visual studio this package running success and working

    but i want to create dynamically running with bat file

    bat file running but can't working succes

    please this is my bat file data

    "C:\Program Files\Microsoft SQL Server\110\DTS\Binn\DTExec.exe" /F

    "c:\users\zen\documents\visual studio 2012\projects\LoadData\LoadData\Package.dtsx"

  • January 4, 2020 at 7:18 pm

    #3712397

    what is the error and are you running on a server or on your pc?

    note that to run from the command line you need to have SQL Server Integration Services installed on the host where it runs.

  • January 4, 2020 at 7:23 pm

    #3712398

    Why not use agent to run your SSIS package?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • January 4, 2020 at 7:31 pm

    #3712399

    in this pc have't sql server 

    only ssis have

  • January 4, 2020 at 7:54 pm

    #3712401

    i give this

    choose to open dtsx file

    Attachments:
    You must be logged in to view attached files.

  • January 4, 2020 at 9:59 pm

    #3712411

    that is your problem - in order to use the command line you need to have SQL Server installed including Integration Services.

Viewing 6 posts - 1 through 5 (of 5 total)

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