SQLDTS.com - SQLIS.comMicrosoft SQL Server Data Transformation Services and SQL Server Integration Services on the web.Global variable diagnostic script- July 8, 2004 There is often some confusion about the real value of a global variable at run-time, or the current execution location and security context. This simple script will illustrate what is really going on. . When trying to debug a package and isolate the problem, it is not always practical to use a full debugger, and sometimes it is just simpler to use a more manual approach to isolating...http://www.sqldts.com/303.aspx SQLDTS File Transfer Protocol Task- July 6, 2004 The SQLDTS FTP Task is designed to give you greater control over FTP operations compared to the task supplied with SQL Server 2000, as well as supporting SQL Server 7.0. . The task supports both upload and download operations, as well as exposing options such as port, connection type and transfer type. . Other features include wildcard support, file filters with date parameters and the...http://www.sqldts.com/302.aspx |