SQ[L package Loads a package that is stored in SQL Server. The package argument specifies the folder and name of the package ...

SQL Server 2008

SQ[L] package  Loads a package that is stored in SQL Server. The package argument specifies the folder and name of the package to retrieve.  However, you can use the SQL option in conjunction with options User, Password, and Server. If you omit the User option, Windows Authentication is used to  access the package. If it is present, the User login name specified is  associated with SQL Server Authentication.  You can use the Password option only in conjunction with the User option. If you use the Password option, dtexec accesses the package with the user name and password information that you provide. If you omit the Password option, a  blank password is used.  * Security Note: When possible, use Windows Authentication.   If you omit the Server option, the default local instance of SQL Server is  assumed.  If you use the SQL option in conjunction with any of the following options,  dtexec fails:  o DTS  o File

sqlQuery - String that contains query to be executed. returnType - Specifies the return type of data returned by the SQL ... sqlQuery - String that represents the query to be run. returnType - Specifies the return type of data that is returned by ... SQLSQM.EXE cannot be launched. This can either be caused if the required information in the registry is missing or corrupted ... SQLXML: Client-side FOR XML does not support the date/time conversions required by this schema. Remove all the date/time-related ... SQ[L package Loads a package that is stored in SQL Server. The package argument specifies the folder and name of the package ... SQ[L package_name Loads a package that is stored in SQL Server. The package_name argument specifies the name and path of ... SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager ... SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "%1!s!" failed because error code 2!8.8X! occurred, and the error ... SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, ...