Post reply

Connection Manager Question

  • May 30, 2007 at 4:03 pm

    #179139

    I know this is a dumb question, but what exactly does connection manager do in SQL Server 2005?  If it works like I think it does, then it sets up BI packages on the servers that it creates a connection to.  However, if my computer goes down, are these packages lost to the server?

    -Thank you in advance.

  • May 30, 2007 at 7:27 pm

    #709872

    A connection manager is part of a SSIS package.  It creates the connection to the data, a SQL Server database, Oracle database, flat file, etc.  

    When you say "my computer goes down", do you mean your workstation where you designed the package?  The packages should be saved on the server, either as a file or stored in MSDB.   

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply