SQLDTS.com - SQLIS.comMicrosoft SQL Server Data Transformation Services and SQL Server Integration Services on the web.Working with files and the FileSystemObject- April 21, 2003 The ability to work with files gives us great flexibility in how we use DTS. It allows us to add some intelligence into a package, and cope with unexpected situations automatically. The key to working with files is the Scripting Run Time as this gives us the FileSystemObject, which can be fully exploited through ActiveX Script Tasks, Workflow scripts, and even transformations, inside your DTS...http://www.sqldts.com/292.aspx |