May
14
2008

The mystery of MULTIFILE

So the other day I was wondering what the heck a Multiple Files connection manager was good for. I read this statement in BOL by a respected predecessor... "A Multiple Files connection manager enables a package to reference existing files and folders or to create files and folders at run time. The tasks and data flow components in Microsoft SQL Server Integration Services that can use information in files perform their work by referencing a Multiple Files connection manager that is included ... [More]
May
10
2008

Sticky note: Authentication in protocol connection managers

Whenever I read user comments about the inconsistent support for authentication methods in our 3 protocol connection managers, I have to go back again and figure out which ones support which methods. So the chart finally became one more sticky note on my wall:   Anonymous Basic Integrated(Windows) FTP Yes Yes No HTTP Yes Yes No SMTP Yes No Yes
May
3
2008

Using connection managers in managed code

SQL Server 2008 Books Online will have a long-needed topic that lists the return values from the AcquireConnection API method for each in-the-box connection manager. The developer needs to be able to cast the return value to the proper type, but these types are somewhat...unpredictable. While the Flat File Connection Manager returns a string, the ADO.NET Connection Manager with SqlClient returns an open SqlConnection. I distracted myself at work one day by adding and configuring a connection mana... [More]