Transfer data from SQL Server to Firebird using SS

2019-09-15 05:04发布

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条回答
爷的心禁止访问
2楼-- · 2019-09-15 05:48

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

查看更多
登录 后发表回答