在SSIS包中使用OLE DB Destination创建表 [英] Create table using OLE DB Destination in SSIS package
问题描述
我是SSIS包的新手。我正在编写一个SSIS包,它将所有表从Access数据库复制到SQL Server数据库。
我在DataFlow中使用ADO.NET Source和OLEDB Destination,它驻留在ForEach循环容器中。
如果表已经存在于SQL Server数据库中,那么一切正常。
我想要做的是,在SQL Server中创建不存在的表。 (此访问数据库稍后会大量扩展)
我如何在OLEDB目的地中执行此操作?
谢谢
Hi,
I am new to SSIS packages. I am writing an SSIS package which copies all tables from an Access Database to SQL Server Database.
I am using an ADO.NET Source and OLEDB Destination in DataFlow which resides inside a ForEach Loop Container.
Everything is working fine, if the tables are already there in SQL Server Database.
What I want to do is, to create the non-existing tables in SQL Server. (This access db is subject to expand heavily later)
How can I do this in OLEDB Destination ?
Thanks
推荐答案
请参阅此链接
https://www.simple-talk.com/sql/ssis/ssis-basics-using-the- merge-join-transformation / [ ^ ]
http://msdn.microsoft.com/en-IN/library/ms141237(v = sql.105).aspx [ ^ ]
Refer this links
https://www.simple-talk.com/sql/ssis/ssis-basics-using-the-merge-join-transformation/[^]
http://msdn.microsoft.com/en-IN/library/ms141237(v=sql.105).aspx[^]
这篇关于在SSIS包中使用OLE DB Destination创建表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!