ssis

相关标签：javascript jquery android 多少钱 iPhone

Add new column to existing SSIS package

I\'ve created an SSIS package using the Import/Export Wizard - it involves several tables wit开发者_StackOverflow中文版h some of the original columns dropped(). It seems like I \'ignored\' one too m[详细]

2023-04-08 05:17 分类：问答
SISS Variables -

I have created user defined SSIS variables at the package level. Example: Here are the varibales v1 = 10[详细]

2023-04-07 21:19 分类：问答
SSIS 2008 - Getting the identity field

I have to read in a text file that has a header row and some details with SSIS.I have two tables (one for the header and one开发者_如何学运维 for the details) that I need to get the data into.I need t[详细]

2023-04-07 18:23 分类：问答
Complexity Difference Between Where Clause Inside Query and Where Clause Inside Conditional Split In SSIS

I\'ve been wondering, what\'s the complexity difference between these two cases: Case 1: An OLE DB Source query, written like this:[详细]

2023-04-07 14:44 分类：问答
Creating SQL Server 2008 R2 DTSX from C# - Exception from HRESULT: 0xC0048021

I\'m creating a dtsx from C# (.NET 4.0) but when I try add the OLEDB Source into the data flow and is time to execute the ProvideComponentProperties step, I recieve the following error in VS2010:[详细]

2023-04-07 12:43 分类：问答
Unpivoting Data in SSIS

I am attempting to normalize data using SSIS in the following format: SerialNumberDateR01R02R03R04 -------------------------------------------[详细]

2023-04-07 09:41 分类：问答
Why is STR Available Inconsistently?

When I create a OLE DB source, I can use the following expression: STR(1234.545, 8, 2) But when I use a Derived-Column flow task, that expression is illegal.The design-time error states:[详细]

2023-04-07 04:29 分类：问答
Inserting irregular data into SQL Server

I have a file of data which I want to regularly insert into a table in SQL Server 2008. The file contains several fixed width text fields and one field which is free text and very long.[详细]

2023-04-06 20:23 分类：问答
Why is my SSIS text logfile formatted in this way?

I have configured logging in my SSIS package by using the Text File log provider.The connection string for the provider is the name of a file in my local file system.The package completes and writes d[详细]

2023-04-06 19:50 分类：问答
ssis lookup with sum - can't map parameters

I have a sql query that looks like this: SELECT SUM(A) AS expr1 FROM TREES WHERE (b = ?) AND (c = ?) and (d = ?)[详细]

2023-04-06 17:48 分类：问答