0

I designed a SSIS package that ensures .CSV file generation into a destination folder using a Script Task component. Everything is ok when I run from the Visual Studio solution but the problems starts to appear right after deployment in SQL Server. The Script Task shows success but no file is generated. If someone please can provide help.

Thanks a lot in advance.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Abderrahman
  • 1
  • I'm running the package through Sql job that use my windows account which is an admin account with full control of my OS. – Abderrahman Nov 05 '15 at 21:38

1 Answers1

0

Are you running it through a SQL job? This might be because the SQL Agent account (or whatever account you're running with) might not have Read/Write permissions on that particular directory.

Julaayi
  • 403
  • 2
  • 8
  • 23