sql server将数据导入另一个sql数据库 [英] sql server import data to another sql database

问题描述

您好，

我正在尝试使用tasks-import从数据库导入数据但由于空字段副本有错误而失败，我搜索谷歌并发现我必须检查保留null字段但我无法找到它的位置。

Hello,
I am trying to import data from a database using tasks-import but because of null fields the copy has errors and fail, I search google and find that I have to check "retain null fields" something but I cannot find where to check it.

推荐答案

请参考



http://msdn.microsoft.com/en-IN/library/ms187887.aspx [<一个href =http://msdn.microsoft.com/en-IN/library/ms187887.aspxtarget =_ blanktitle =新窗口> ^ ]



https://www.simple-talk.com/sql/reporting-services/using-sql-server-integration-services-to-bulk-load-data/ [ ^ ]



SQL Server Integration Services（SSIS） - 第1部分：基础知识SSIS和创建包 [ ^ ]

Please refer

http://msdn.microsoft.com/en-IN/library/ms187887.aspx[^]

https://www.simple-talk.com/sql/reporting-services/using-sql-server-integration-services-to-bulk-load-data/[^]

SQL Server Integration Services (SSIS) – Part 1: Basics of SSIS and Creating Packages[^]

这篇关于sql server将数据导入另一个sql数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！