SQLDTS.com - SQLIS.comMicrosoft SQL Server Data Transformation Services and SQL Server Integration Services on the web.How do I enumerate tables in an Access Database- August 26, 2003 If you need to enumerate the tables in an Access database, the easiest method is through the ActiveX Data Objects Extensions for Data Definition Language and Security. The ADOX library, as it is better known, can be used just like other COM objects from within ActiveX script, such as a task or workflow script. . The code below is a simple example that enumerates the tables and just...http://www.sqldts.com/296.aspx How can I overwrite the package log for each execution- August 18, 2003 The package error log file can be very useful in diagnosing problems that occur during package execution, and is particularly useful when working with scheduled packages. . For each execution information is appended to the end of the file. Over time this file can grow quite large, especially if the package runs on a frequent schedule. There is no overwrite option available within the DTS...http://www.sqldts.com/240.aspx |