automating an export

• dl206

  SSC Rookie

  Points: 32

  More actions

  August 9, 2021 at 3:34 pm

  #3918175

  Hello,

  I'm having an issue with Creating an export job. It says that it runs successfully, but when I check the file it creates there is nothing. When I export with the same command using the Export wizard, it works just fine. When I save that exact command as an SSIS package, it says it runs successfully (since there aren't any syntax issues) but there is nothing. In SSA-jobs, I created one that uses T-sql, but I'm wondering what I should be putting in there to export something. Can anyone provide assistance on an example of what an export t-sql script looks like?

• andreas.kreuzberg

  SSCertifiable

  Points: 6191

  More actions

  August 10, 2021 at 10:44 am

  #3918398

  Hi,

  if the export job is running as an sql server agent job, the service user needs the permission to create the export file in the directory.

  If you just run the t-sql, this is running with your credentials.

  Just take care, that the service user from the sql server agent got the permission on the folder / share to export files.

  Good luck,

  Andreas