Forum Replies Created

Viewing 15 posts - 2,431 through 2,445 (of 2,487 total)

  • RE: Remove old package versions

    quote:

    DOuble check but I believe there is an SP for that built into msdb. No database online here right now so I...

    --------------------
    Colt 45 - the original point and click interface

    November 27, 2002 at 4:33 pm

    #442589

  • RE: Using Execute Package Tasks

    Check out "DTS Package Properties (Logging Tab)" in BOL, specifically the 'Fail package on first error' bit.

    Thanks

    Phill Carter

    --------------------
    Colt 45 - the original point and click interface

    November 26, 2002 at 5:37 pm

    #442491

  • RE: Remove old package versions

    Thanks Antares. Initial test performed great.

    I'll link in the DTS logging tables so I can remove the old log records as well.

    Thanks

    Phill Carter

    --------------------
    Colt 45 - the original point and click interface

    November 26, 2002 at 5:33 pm

    #442490

  • RE: Renaming Connections in DTS

    When you're in Disconnected Edit, make sure you change the task that is associated with the step as well.

    Thanks

    Phill Carter

    Edited by - phillcart on 11/26/2002 5:15:10 PM

    --------------------
    Colt 45 - the original point and click interface

    November 26, 2002 at 5:14 pm

    #442478

  • RE: Executing a package from within a package

    The 'DTSSQLStgFlag_Default' constant specifies that SQL Security is used.

    For Winodws Authentication use the 'DTSSQLStgFlag_UseTrustedConnection' constant instead.

    Thanks

    Phill Carter

    --------------------
    Colt 45 - the original point and click interface

    November 25, 2002 at 5:55 pm

    #442368

  • RE: DTS copy databases

    How are you copying the database? Using the "Transfer Database" or "Copy Objects" task?

    Thanks

    Phill Carter

    --------------------
    Colt 45 - the original point and click interface

    November 25, 2002 at 2:59 pm

    #442354

  • RE: Delete worksheet in Excel

    1) Why do you want to delete the data in the worksheet? Wouldn't you just create a new file or overwrite the old one?

    2) If you use Text file output...

    --------------------
    Colt 45 - the original point and click interface

    November 25, 2002 at 2:54 pm

    #442353

  • RE: Passing Parameters to DTS

    quote:

    Look again under Advanced...

    You can set Global Variables, generate command line or even generate encrypted command line

    --------------------
    Colt 45 - the original point and click interface

    November 25, 2002 at 2:44 pm

    #442349

  • RE: Passing Parameters to DTS

    quote:

    Check out dtsrunui. No more building parameters or jobs for dtsrun by hand. Excellent tool!

    Pity...

    --------------------
    Colt 45 - the original point and click interface

    November 25, 2002 at 5:27 am

    #442242

  • RE: Changes to Text Annotations not saved

    quote:

    I had no issues with SQL 2000 SP2. What version are you running so I am comparing Apples to Apples here?

    --------------------
    Colt 45 - the original point and click interface

    November 24, 2002 at 5:01 pm

    #442218

  • RE: Passing Parameters to DTS

    quote:

    There does not appear to be a solution to run DTS with parameters directly from ASP. I believe the solution we're...

    --------------------
    Colt 45 - the original point and click interface

    November 24, 2002 at 4:53 pm

    #442217

  • RE: Executing a package from within a package

    By using DTSGlobalVariables.parent you are creating a package object which is referencing the current package.

    You need to create a new package object to load your stored package into.

    eg:

    --------------------
    Colt 45 - the original point and click interface

    November 24, 2002 at 4:41 pm

    #442216

  • RE: Execute DTS with Parameters from Stored Procedure

    This article is probably more what you're looking for.

    http://www.databasejournal.com/features/mssql/article.php/1459181

    It shows how to use the sp_OA procedures to set global variables on page 2.

    Thanks

    Phill Carter

    --------------------
    Colt 45 - the original point and click interface

    November 21, 2002 at 3:38 pm

    #442034

  • RE: DTS or BCP or ???

    As you are using a variable, not a static value, you need to put the BULK INSERT statement inside an EXEC statement.

    EG:

    EXEC ('BULK INSERT CUSP001.dbo.tmpALDB_BI2 FROM...

    --------------------
    Colt 45 - the original point and click interface

    November 21, 2002 at 3:34 pm

    #442033

  • RE: Detecting comms failure connecting to AS/400

    Try something like

    

    DECLARE @Err int

    

    CREATE TABLE #Tmp (

      PingText varchar(255)

    )

    

    INSERT INTO #Tmp

      EXEC xp_cmdshell 'ping <your server ip address>'

    

    SELECT @Err = COUNT(*) FROM #Tmp

    WHERE...

    --------------------
    Colt 45 - the original point and click interface

    November 20, 2002 at 9:16 pm

    #441939

    • Viewing 15 posts - 2,431 through 2,445 (of 2,487 total)