ssis topics

When the SSIS error is: "Cannot convert between Unicode and non-Unicode string data types", consider implementing it with a data converter, as simple as:The first step is to find the data converter:The second step is to edit the data converter:The third step: Edit the target mapping relationship is "copy of XXX", you can.Error exclusion, success.Note: The data Connection Manager for SSIS is best used for SQ

1. Export conversion component Export column conversion reads data from the data stream and inserts the data into the specified file. the secondary conversion uses paired data columns: one column is the data to be output, and the other column is the files to which the data is output. during conversion, data is inserted into the specified file. if these files do not exist, the conversion creates these files and then writes the data to the files. the data to be written must be of the dt_text, dt_n

The last time we introduced simple data export and import, we only operate on a single file. If we want to import data to all the files under a directory at the same time, how can we achieve this? SSIS provides the foreach loop container in the control flow, which is easy to understand. Compared with the sequential container, SSIS can traverse and execute cyclically, you can repeatedly execute the control f

The transpose of columns in SSIS is somewhat different from that in tsql. I. first look at the row and column transpose in tsql See the following table. Insert test data into the table The following result is returned if username is column: You can do it through the following tsql (refer to msdn: http://msdn.microsoft.com/zh-cn/library/ms177410.aspx for the explain syntax) Select [a] As a, [B] as B, [c] As cfrom (select usernam

An expression is a combination of elements to generate a unique value. These elements include variables, literal faces, functions, stored procedures, and operators. The expression of a short answer is 1 Many tasks in SSIs support expressions. All tasks support attribute configuration using expressions. For example, expressions can be used in for loop and foreach loop to set loop conditions. The derived Column task can use expressions to define outp

SSIS is not only an ETL tool, but it's very powerful. Take its WMI data Reader task and the event watcher task to get even a lot of information about the operating system. Windows Management Specification (Windows Management Instrumentation) is one of the top secrets in Windows. WMI uses WQL queries to complete the following applications: 1. Read the System event log to find a specific error 2. Query running list of applications 3. Query how much m

SSIS (SQL Server integration Services) is a platform for generating enterprise-class data integration and Data transformation solutions. Using Integration Services solves complex business problems by copying or downloading files, sending e-mail to respond to events, updating the Data Warehouse, purging and mining data, and managing SQL Server objects and data. These packages can be used independently or in conjunction with other packages to meet compl

Tags: style blog http color os io using AR forIntroduction to the outsetExecute SQL Task This control is very often used in Microsoft BI ETL projects, and it is also the first few control flow controls that are accessible to most beginners in SSIS. we typically use the Execute SQL Task scenario to include but not only the following categories: Use Execute SQL Task to perform some Truncate operations before loading data from the source to the

You can use SSIS to customize a task by importing the sql2005 of Excel files in one directory (which can include subdirectories). The following is a complete description of the entire process with a large number of pictures. 1, the Establishment test Excel file, assumes has a B C D four fields, saves in the F:/excel directory and copy many of the same files. 2. Open a new business intelligence project by opening Microsoft Visual Studio 2005 or SQL

Scripting SSIS is more powerful than the DTS log schema, and you don't need to write a msgboxes to get the log information you need. Because your script component is inherited from a scriptcomponent component with a log method, this method allows you to return a message to the SSIS package's log, which triggers a scriptcomponentlogentry call, such as the following code(VB code)Dim x (0) as ByteMe.Log ("Hell

SSIS expression 1. Calculate the number of times a substring appears in a stringNumber of occurrences of "." In the Liang. Liang string Set the string variable to v_str SQL code Len(@[User: v_str])-(Len(Replace(@[User: v_str],".",""))/Len(".")) 2. If the current date is Saturday, the string "break" is returned; otherwise, the string "work" is returned.

Container A container is an object that provides a structure for one or more tasks. For example, you can execute a loop until the boundary condition is reached, or organize a series of tasks logically. A container can also contain other containers. Containers and tasks are also placed in the Control Flow Label. There are four types of containers: Task host, sequence, for loop, and foreach loop. Task host containers The task host is the default container of a single task. You cannot find

We will introduce the first container in SSIs 2008: For Loop container,This container is not used in many practical applications, but it is useful in some special scenarios. It is used to realize the loop of a variable and assign values to the variable in the loop. When the condition for terminating the loop is metIt exits the loop. Its function is similar to the do while structure of the structured programming language. For example, the following str

Illustration: SSIS batch import of Excel files Import an Excel file with the same structure in a directory (including sub-Directories) to sql2005 in batches. You can use SSIS to customize the task. A large number of images are used below to describe the entire process. 1. Create a test Excel file. Assume that there are four fields a B c d stored in the F: \ Excel directory.And copy many identical files.

Source: Monitor remote server Windows services through SSIS and send mail Alerts!with SSIS, you can not only do the ETL of BI project, but also do some system monitoring and maintenance work, because the Windows service written by the vendor is processed by the message of reading the ESB, and integrates with the guest system through OA process, whether it is the ESB condition, or Windows services, will have

a bug.Http://blogs.msdn.com/b/mattm/archive/2007/04/18/why-can-t-i-store-my-bigint-result-in-an-int64-variable.aspxWhy can ' t I store my BIGINT result in an Int64 variable?The Native providers (OLE DB, ODBC, ado–ado.net doesn ' t has this problem) in the Execute SQL Task return the BIGINT type As a String, and not the Int64 as you ' d expect. Attempting to store the result of a Int64 variable gives you error along the lines of: [execute SQL Task] Error:an Error occurred while assigning a valu

Yesterday, a friend encountered a problem when developing SSIs in a 64-bit environment: The Excel Connection Manager is not supported in the 64-bit version of SSIs, as no ole db Provider is available. Because there are no 64-bitMicrosoft ole db provider for jetTherefore, when using SSIS to call excel on 64-bit machines, you may encounter two problems: o

When the ssis package is executed, the following error occurs: the connection "" cannot be found. If a specific connection element cannot be found, this error occurs in the Connections set. I searched for it online. Solution: Open SqlServerConfigurationManage, right-click "SqlServerIntegrationServices", select "properties", and change the logon identity to "LocalSystem ". When the ssis package is executed,

Problem Description: When you import data from other databases, or other data sources such as text files to the destination database, you sometimes want to be able to implement the "update when data is present, when it does not exist," in the process of importing. In the past, it is common to import a temporary table and then judge processing to import the formal table, in SQL Server 2005, SSIS can complete this processing directly when importing proc

Objective Because of the project needs, we will read some configuration data from SharePoint, and it is possible to perform some writeback operations to update the SharePoint data. No such operation has been done before, and some should be programmed to get or write some data through C #. Looking at some of the relevant articles, I also started to test how to access the SharePoint list in SSIS Package and write data to the SharePoint list. Two actio