2014年3月6日

[转]SSIS ADO.NET vs OLEDB

摘要: 本文转自:http://social.msdn.microsoft.com/Forums/sqlserver/en-US/1a9e3670-9685-4943-913b-123ecf248a9c/ole-db-vs-adonet?forum=sqlintegrationservicesADO.NET vs OLEDB:I'll try to answer this question by slicing it into4 main areas:1.support across SSIS components:a.SSIS is not welcoming ADO.NET and OLE 阅读全文

posted @ 2014-03-06 18:41 freeliver54 阅读(1239) 评论(0) 推荐(0)

[转]SSIS高级转换任务—在Package中是用临时表是需要设置RetainSameConnection属性

摘要: 本文转自:http://www.cnblogs.com/tylerdonet/archive/2011/05/20/2052306.html在上一个导入列这个例子中我们创建一个实际的表来存储文件路径,在生产环境中我们可能不会创建一个实际的物理表来存储这些信息,而是创建临时表。这里有一个小小的技巧,在Control Flow中拖放两个Execute SQL task,一个创建临时表,另一个销毁临时表,执行这个package,会遇到一个错误,在Progress中提示信息显示不存在这个临时表。错误信息如下:Error: 0xC002F210 at Execute SQL Task 1, Execut 阅读全文

posted @ 2014-03-06 14:35 freeliver54 阅读(777) 评论(0) 推荐(0)

[转]SSIS高级转换任务—行计数

摘要: 本文转自:http://www.cnblogs.com/tylerdonet/archive/2011/06/19/2084780.html在SSIS中的Row Count转换可以在数据流中计算数据源的行数。这种任务必须将行数保存在一个变量中。这种任务在你不想将数据行数保存在一个物理表中时会很有用。例如在ConditionalSplit任务中使用多个RowCount记录有多少行被分离出来,每个Row Count将使用变量记录分支中的数据行数,可以将这个变量值记录在数据库中,作为邮件信息发送出去,或者在下一个步骤中使用。一样这个任务需要使用高级编辑器,这个更加简单,只需要添加一个变量来存储行数。 阅读全文

posted @ 2014-03-06 14:31 freeliver54 阅读(514) 评论(0) 推荐(0)

[转]SSIS Recordset Destination

摘要: 本文转自:http://www.sqlis.com/sqlis/post/Shredding-a-Recordset.aspxDoing what to a recordset?Shredding a recordset in this instance means that we are going to show you how to take a recordset produced in your SSIS package, loop over the rows in that recordset, break apart the columns and do something wi 阅读全文

posted @ 2014-03-06 10:26 freeliver54 阅读(533) 评论(0) 推荐(0)

[转]SSIS: By coding

摘要: 本文转自:http://www.codeproject.com/Articles/604197/SSIS-By-codingIntroductionSSIS better known as “SQL Server Integration Services (SSIS)”, is a component of SQL Server. According to Wikipedia:-“SSIS is a platform for data integration and workflow applications. It features a fast and flexible data war. 阅读全文

posted @ 2014-03-06 09:21 freeliver54 阅读(502) 评论(0) 推荐(0)

[转]SSIS cannot convert between unicode and non-unicode string

摘要: 本文转自:http://www.mssqltips.com/sqlservertip/1393/import-excel-unicode-data-with-sql-server-integration-services/Import Excel unicode data with SQL Server Integration ServicesProblemOne task that most people are faced with at some point in time is the need to import data into SQL Server from an Excel 阅读全文

posted @ 2014-03-06 09:17 freeliver54 阅读(4806) 评论(0) 推荐(1)

导航