From the course: SQL Server Integration Services
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Additional connection managers - SQL Server Tutorial
From the course: SQL Server Integration Services
Additional connection managers
- [Instructor] SQL Server Integration Services is built around the concept of data integration flexibility. The OLEDB, Excel, and Flat File connections will likely handle a good portion of your data. But everyone's data environment is unique, and a connection that provides the core foundation or your organization might be completely unheard of in another. And truth be told, most of the connection managers are just variations of what we've already seen. You fill in a path or a network location to the resource, supply any log-in credentials, and test the connection. For instance, if I come down here and right click and choose New Connection, we'll take a look at the ADO.NET connection type. I'll click the New button, and it asks for a server name, the logging credentials, and a specific database to connect to. This is just like what we saw with the OLEDB connection manager. Let's cancel out of this. Now let's take a look at the FTP connection. This would allow you to connect to an FTP…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.