我是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
推荐答案请参阅此链接 www.simple-talk/sql/ssis/ssis-basics-using-the- merge-join-transformation / [ ^ ] msdn.microsoft/en-IN/library/ms141237(v = sql.105).aspx [ ^ ] Refer this links www.simple-talk/sql/ssis/ssis-basics-using-the-merge-join-transformation/[^] msdn.microsoft/en-IN/library/ms141237(v=sql.105).aspx[^]
更多推荐
在SSIS包中使用OLE DB Destination创建表
发布评论