Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Filepath from SQL job into Script task Expand / Collapse
Author
Message
Posted Wednesday, January 29, 2014 11:16 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 10, 2014 11:03 AM
Points: 24, Visits: 145
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
Post #1536174
Posted Friday, January 31, 2014 9:31 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 1:43 PM
Points: 563, Visits: 8,623
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, MCITP
Post #1536854
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse