Re: dts transaction

From: Nigel Rivett (NigelRivett_at_discussions.microsoft.com)
Date: 06/26/04

  • Next message: Nigel Rivett: "RE: Modify DTS Package from Visual Basic" 
    Date: Sat, 26 Jun 2004 11:16:01 -0700

    Why use dts t all for this?
    Maybe use it for the import into the staging database if you wish but the rest should be an SP - just do the transaction control in the SP.

    I would call the package from the SP rather than vice versa but it's up to you.

  • Next message: Nigel Rivett: "RE: Modify DTS Package from Visual Basic"

    Relevant Pages

    • 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)
    • Re: Is there a limitation on the number of Tasks that can Run in Parellel ?
      ... > executed in Parallel to 20 in the DTS Package Properties window. ... > Step Error Source: Microsoft Data Transformation Services Package ...
      (microsoft.public.sqlserver.dts)