Transfer data from SQL Server to Firebird using SS

问题:

I'm trying to execute a select in SQL Server database and insert the result to Firebird using SSIS.

I'm Googled, but anything can help =/

Any idea how I can do this?

Thanks.

回答1:

I am guessing you are trying to create a connection between SSIS en Firebird. To do this, you need to download the LCPI OLE DB Provider for InterBase first.

When you have that installed, you just select it from the dropdown during the creation of the new connection manager.

Check these links out:

http://www.ibprovider.com/eng/download.html http://www.ibprovider.com/eng/documentation/ssis_firebird_interbase.html