Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Connectivity   (RSS)

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:

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:

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:

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

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:

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: ,

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: , ,

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: ,

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:

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: ,

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: ,

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