Place Files in Shared Path using SSIS

• CrazySam

  SSC Journeyman

  Points: 87

  More actions

  February 26, 2015 at 4:51 pm

  #315692

  I have created a OLE DB Connection and Created a Flat File in a Shared Folder Location.

  When i execute in BIDS, its working fine in placing the file, But when i deploy the code in SSISDB, its errors out, "Cannot Open Datafile", Access Denied.

  Its mainly an access issue in Shared Folder Level, Could you help me to find out this issue

• SQL.AP

  Hall of Fame

  Points: 3244

  More actions

  February 26, 2015 at 9:59 pm

  #1780466

  You need to give shared folder permissions to the service user which is executing your package from SSISDB.

  ____________________________________________________________

  AP