SQLDTS.com - SQLIS.comMicrosoft SQL Server Data Transformation Services and SQL Server Integration Services on the web.DTSBackup 2000- September 30, 2003 DTSBackup 2000 is a designed to help with both backup and transfer of DTS packages. Whilst it is not recommended as a substitute for your normal file and database backup routines, it is an additional layer of protection, with the benefit of package level granularity. See the article Backing Up Packages for additional information. . Whilst the name is backup, it is...http://www.sqldts.com/242.aspx How to loop through a global variable Rowset- September 8, 2003 The Execute SQL Task for SQL Server 2000 allows both input and parameters to be specified. In this article we will be focusing on the Rowset output parameter functionality, and what we can then do with the Recordset it returns. The Rowset parameter takes the result set of a SELECT statement and stores it in an ADO Recordset object within a global variable you choose. You can then retrieve...http://www.sqldts.com/298.aspx DataPump truncates delimited fields to 255 characters- September 6, 2003 There is a known issue where DTS truncates delimited columns at 255 characters when exporting to a text file. The problem is not with the DataPump itself, it is due to the default properties of text file connection provider as used within the DTS designer and the ImportExport wizard. The Wizard has been fixed (FIX: DTS May...http://www.sqldts.com/297.aspx |