Post reply

.bat file fails in SSIS

  • September 27, 2017 at 9:41 am

    #1961186

    That can also be solved by "escaping" that particular character, when not doing by user control.

  • September 27, 2017 at 10:14 am

    #1961189

    sks_989 - Wednesday, September 27, 2017 7:45 AM

    Yes Steve we resolved issue by removing ! character from password.

    Crazy. Thanks for the update.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • September 27, 2017 at 4:07 pm

    #1961254

    Hi Everyone,

    I checked the directory to the share and I do have access to it.

    Sue,

    I went ahead with your suggestion, created the .bat file; ran it and it created the .txt file successfully. I then added it to an execute process task in my SSIS package and it works beautifully!!!  I think my permissions restrict me from using the fsutil utility.

    Thanks everyone for your input.

  • September 27, 2017 at 4:31 pm

    #1961255

    BI_Developer - Wednesday, September 27, 2017 4:07 PM

    Hi Everyone,

    I checked the directory to the share and I do have access to it.

    Sue,

    I went ahead with your suggestion, created the .bat file; ran it and it created the .txt file successfully. I then added it to an execute process task in my SSIS package and it works beautifully!!!  I think my permissions restrict me from using the fsutil utility.

    Thanks everyone for your input.

    Thanks for posting back - glad you ended up with something that works for you.

    Sue

Viewing 4 posts - 16 through 18 (of 18 total)

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