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.
A connection manager acquires connections to a database. flat file, or other data source so that the SSIS package can retrieve from or send information to the source. It doesn't have anything to do with setting up the package on a server.|||Exactly. It's essentially a wrapper around the connection, be it a database connection, file connection or whatever, that "manages" the connection for SSIS.
No comments:
Post a Comment