.bat file fails in SSIS

• isaac_654135

  Default port

  Points: 1414

  More actions

  September 27, 2017 at 9:41 am

  #1961186

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

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  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.

• BI_Developer

  SSC Eights!

  Points: 908

  More actions

  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.

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  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