Re: ADO OLEDB connection to MSSQL: pooling not working

Dennis
Date: 02/18/05

  • Next message: Dennis: "Re: Where can TBetterADODataset downloaded ?" 
    Date: Fri, 18 Feb 2005 08:35:09 -0500

    Pooling may be disabled by default. You can always add the parameter
    "OLE DB Services=xx" to your connectionstring to force to on.

    Lookup "OLE DB Services" in MSDN for help.

    Dennis Passmore
    Ultimate Software, Inc.

  • Next message: Dennis: "Re: Where can TBetterADODataset downloaded ?"

    Relevant Pages

    • Re: SSIS and Staging Tables
      ... What I did was I took my original lookup (from the Flat File Source) ... I sent one path to my OLE DB UPDATE ... One path goes to my UPDATE command....This transform is already ...
      (microsoft.public.sqlserver.dts)
    • Re: SSIS and Staging Tables
      ... Allan Mitchell wrote: ... OK So a lookup must be against a RDBMS and a Text File is most definitely ... Two sources to the pipeline (Text File + OLE DB) ... map the input columns in your case to an update statement. ...
      (microsoft.public.sqlserver.dts)
    • Re: SSIS and Staging Tables
      ... OK So a lookup must be against a RDBMS and a Text File is most definitely not one of them. ... Two sources to the pipeline (Text File + OLE DB) ... if there is any way (within the Data Flow Task) to ... map the input columns in your case to an update statement. ...
      (microsoft.public.sqlserver.dts)
    • Re: SSIS, Lookups, and Redirect Row
      ... The rows you pipe to the error output can be used however you want. ... Using the OLE DB transform then you would have to issue a statement ... If you do not like this then stage these rows and outside of the data flow issue a set based UPDATE in an ExecuteSQL task. ... If I have a lookup comaring two sources ...
      (microsoft.public.sqlserver.dts)
    • Re: SSIS and Staging Tables
      ... I currently have the ability to UPDATE and DELETE records in my OLE DB ... I am trying to create a OLE DB Destination that will INSERT INTO my DB ... OK So a lookup must be against a RDBMS and a Text File is most definitely ... if there is any way (within the Data Flow Task) to ...
      (microsoft.public.sqlserver.dts)