You can create a global variable in the package to hold the file name/path and use it to set the text file connection. Here's a link to some sample ActiveX script tasks;check Tasks and Connections in the FAQ: http://www.sqldts.com/