DTSRun Command Line: Text File out put variable

Last Post 13 Mar 2007 03:34 AM by JHunter. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
GoodFella3993
New Member
New Member

--
12 Mar 2007 09:53 AM
I am using DTSRun to kick off a DTS Job. I have a variable that inputs a number in the WHERE clause of the query. I now want to have a variable in the command line that will allow the user to enter the File Name and Directory of the Outputed Text File.

Any Suggestions
JHunter
New Member
New Member

--
13 Mar 2007 03:34 AM
Create another global variable (or one for each of the directory and filename), then use a dynamic properties task to set the destination of the output file to the global variable(s).

Jamie
GoodFella3993
New Member
New Member

--
13 Mar 2007 04:14 AM
Right now i have it set up with one variable for the whole entire path & file name and put the global variable in the Data Source of the Text File Connection. How would I set it up for two variables, one for the directory, one for the file name. In the future, I will have an ASP Page for the variable inputs.

Thanks again.
You are not authorized to post a reply.

Acceptable Use Policy