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
I have created user defined SSIS variables at the package level. Example: Here are the varibales v1 = 10
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
I\'ve been wondering, what\'s the complexity difference between these two cases: Case 1: An OLE DB Source query, written like this:
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:
I am attempting to normalize data using SSIS in the following format: SerialNumberDateR01R02R03R04 -------------------------------------------
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:
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.
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
I have a sql query that looks like this: SELECT SUM(A) AS expr1 FROM TREES WHERE (b = ?) AND (c = ?) and (d = ?)
加载中,请稍侯......