SQLDTS.com - SQLIS.comMicrosoft SQL Server Data Transformation Services and SQL Server Integration Services on the web.How do I open a file package or template- January 14, 2003 In the save package dialog screen there are several Locations available. The Structured Storage File option is useful if you wish to keep the package as a file, perhaps so that it can be added into a source control repository, or for manually copying to another server or transfer media. Whilst it is quite simple to save a storage file (.dts) it is not immediately obvious how you open one of...http://www.sqldts.com/193.aspx Create an Access Database- January 13, 2003 When exporting data to a text file, if the file does not exist it will be created, or if it does exist it will be overwritten. In contrast, when exporting to an Access database the file and table must exist already. This article will show you how to create an empty Access database ready to receive your data. . We can create the MDB file in an ActiveX Script Task using the Microsoft...http://www.sqldts.com/288.aspx |