Filepath from SQL job into Script task

• gracebite

  Right there with Babe

  Points: 725

  More actions

  January 29, 2014 at 11:16 pm

  #288832

  Hi,

  Can you please help me out on pass the file path as variable into script task through Job

  I have script task task in a package (package has a variable (file_path) that package in SQL Job that executes one stored proc generates xml output I need to write that out into file that file should be (Dynamic) passed through job. I set a filepath in set values in job but its not writing the output into specified filepath (not recognising file path in script task) when I ran through BITS working fine

  Can you please help me out on this

  Thanks

  Grace

• Russel Loski

  SSCertifiable

  Points: 7059

  More actions

  January 31, 2014 at 9:31 am

  #1685117

  What does the command line look like in the SQL Server Agent task? Specifically, what is the syntax for the Set values part for the variable?

  Russel Loski, MCSE Business Intelligence, Data Platform