SSIS
文章平均质量分 72
iteye_15759
这个作者很懒,什么都没留下…
展开
-
The solution of SSIS Error: Timeout expired.
SSIS error message is:Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Solution: The solution is simpl...原创 2012-04-27 14:13:43 · 142 阅读 · 0 评论 -
Bulk Insert Task Error: Cannot bulk load because the file could not be opened.
SSIS error message is:[Bulk Insert Task] Error: An error occurred with the following error message: "Cannot bulk load because the file "C:\Deployment\Files\temp.txt" could not be opened. O...原创 2012-05-23 15:08:15 · 981 阅读 · 0 评论 -
SSIS 经验总结
1、在Execute SQL Task组件中创建临时表,需要使用create显示创建,不能使用select into。 2、Dump数据到SqlServer中,存在数据文件情况下,Bulk Insert Task组件快于Data Flow Task。在Data Flow Task中,使用OLE DB Destination快于ADO NET Destination,设置OLE数据访问模式为...原创 2012-05-24 14:45:24 · 2692 阅读 · 0 评论