SQLDTS.com - SQLIS.comMicrosoft SQL Server Data Transformation Services and SQL Server Integration Services on the web.Getting Syntax Help for DTSRun- January 19, 2004 If you are having problems with the syntax for the dtsrun. command line, or just want an easy way of generating a valid command line first time, try using the dtsrunui. utility. As the name indicates it is very similar to dtsrun, but with a user interface. This allows you to easily select your package, including settings for global variables and logging, then use the generate function to...http://www.sqldts.com/301.aspx Execute a package from a package- January 12, 2004 You can use a parent or master package to control the execution of one or more child packages. This is often used in a looping scenario, or when there are a number of individual packages that make up a process. . This can be achieved very simply in SQL Server 2000 by using the Execute Package Task. As well as being very simple to use it supports transactions, the benefits of which should be...http://www.sqldts.com/215.aspx |