Stored Procedures ... Can I use Stored Procedures and, if so, how? ... I created DTS package, added a SQL connection and added an Execute SQL Task, ... (microsoft.public.sqlserver.dts)
Re: DTS Process Cube Task ... It has a command-line interface -- so you would use a DTS Process Task...private dimension that contained more than 2 million members. ... occasionally the cube would process, and that was throwing me off. ... DTSRUN of the package from the command-line. ... (microsoft.public.sqlserver.olap)
Re: Is there a limitation on the number of Tasks that can Run in Parellel ? ... Allan Mitchell MCSE,MCDBA, www.SQLDTS.com - The site for all your DTS needs. ... >> Before the sending the mail yesterday, I did increase the number of Tasks executed in Parallel to 20 in the DTS Package>> Properties window. ... >> Step Error Source: Microsoft Data Transformation Services Package Step Error Description:SubStep ... Step Error code: 80040428 Step Error Help>> File:sqldts80.hlp Step Error Help Context ID:1100>> Step Error Source: Microsoft Data Transformation Services Package Step Error Description:SubStep>> 'DTSStep_DTSDataPumpTask_10' failed with the following error: OleDBProperty 'General Timeout' already exists in the collection. ... (microsoft.public.sqlserver.dts)
RE: DTS Hanged When Scheduled ... Please feel free to respond to the newsgroups if you need any ...Microsoft Online Support... | Subject: RE: DTS Hanged When Scheduled ... this behavior occurs because the package is using ... (microsoft.public.sqlserver.dts)
Re: Import and Schedule DTS on MSDE ... The dtsrun utility executes a package created using Data Transformation Services. ... Displays the command prompt options.... Displays the encrypted command used to execute the DTS package without executing it. ... (microsoft.public.sqlserver.tools)
