Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Connectivity   (RSS)
Wednesday, January 07, 2009 5:32 PM

Writing to a MySQL database from SSIS

A couple of users reported being unable to use the ADO.NET destination to insert data into their mysql databases. When I originally tried this out , it worked, but it seems like changes made since the early 2008 CTPs have made us incompatible with MySQL.
Posted by mmasson | 7 Comments
Filed under:
Wednesday, December 03, 2008 11:07 AM

New connectivity white papers

Two new SSIS connectivity white papers have been published on MSDN. Connectivity Options for Microsoft SQL Server 2008 Integration Services by Martin Ellis This paper talks about the various connectivity options that SSIS supports, as well as the new
Posted by mmasson | 1 Comments
Filed under:
Thursday, October 02, 2008 3:05 PM

Attunity connectors for Oracle and Teradata are now available

The high speed connectors for Oracle and Teradata are now available for download .   Supported versions Platforms Oracle 9.2.0.4 or higher x86, x64, ia64 Teradata 2R6.0, 2R6.1, 2R6.2 and 12.0 x86, x64 Attunity has done a great job putting these together,
Posted by mmasson | 8 Comments
Filed under:
Friday, August 22, 2008 4:05 PM

Accessing OLEDB Connection Managers in a Script

Accessing ADO.Net Connection Managers from an SSIS script task / script component is pretty easy – you just need to cast the object returned from AcquireConnection() to the appropriate class (i.e. SqlConnection if you’re using SQL Native Client). SqlConnection
Posted by mmasson | 2 Comments
Sunday, June 29, 2008 6:40 PM

SSIS and SAP

Douglas already beat me to it , but I figured it was important enough to repeat incase you missed it the first time around. I still don't fully understand why SAP is so popular. It's probably because I don't know enough about it, but it seems the more
Posted by mmasson | 0 Comments
Filed under:
Thursday, May 22, 2008 10:54 AM

Improved error messages about missing OLEDB providers

We've modified the OLEDB_NOPROVIDER error to return the name of the provider we failed to find. This will appear in the RC0 release of SQL 2008. SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR.  The requested OLE DB provider SQLNCLI.1 is not registered.
Posted by mmasson | 0 Comments
Filed under: ,
Wednesday, May 21, 2008 4:53 PM

Package upgrade - connection strings

We tried to make our package upgrade as seamless as possible, but one problem we've seen people running into is with their connection strings. As I've previously noted, the provider name for SQL Native Client was changed in 2008 from SQLNCLI to SQLNCLI10.
Posted by mmasson | 3 Comments
Filed under: , ,
Friday, March 21, 2008 9:10 PM

Some notes about SQL Native Client in 2008

The SQL Native Client (SNAC) provider was renamed from SQLNCLI to SQLNCLI10 in 2008. The means that connection strings that used the Yukon provider (SNAC9) won't work if you only have the Katmai provider (SNAC10) installed. This will affect most SSIS
Posted by mmasson | 2 Comments
Filed under: ,
Monday, March 10, 2008 4:52 PM

New connectivity options in 2008

Update: 2008-08-13 - The connector pack will be available two to three months from the GA of SQL 2008 Update: 2008-10-02 - The Oracle and Teradata connectors are now available Update : 2008-11-26 - The SAP BI connections are available Darvey Lavender,
Posted by mmasson | 11 Comments
Filed under:
Monday, March 03, 2008 10:23 PM

Connecting to MySQL from SSIS

Update: See this follow-up post on writing data to MySQL . I've recently seen a bunch of questions about connecting to MySQL from SSIS, so I thought I'd give it a try. Our connectivity wiki currently doesn't have anything about MySQL on it, but I'll try
Posted by mmasson | 9 Comments
Filed under: ,
Thursday, June 07, 2007 9:40 AM

SQL Native Client 10 - provider name change

The provider name for SQL Native Client (SNAC) connections has changed in Katmai. Since this is the default provider for OLEDB connections, you'll probably be affected by this change if you're running SQL Server 2005 packages in Katmai. Version Provider
Posted by mmasson | 0 Comments
Filed under: ,
Wednesday, January 31, 2007 10:20 AM

SSIS connectivity white paper

A connectivity white paper writen by Bob Beauchemin has been added to the connectivity wiki site . Definitely worth checking out.
Posted by mmasson | 0 Comments
Filed under: ,
 
Page view tracker