ssis for beginners

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

The SSIS default connection manager is not connected to Oracle or SAPBI, so you can use the Connection Manager plug-in provided by Microsoft if you want SSIS to invoke the SAP RFC. For more information on this point, refer to the official MSDN documentation: Http://technet.microsoft.com/en-us/library/ms140203.aspx The specific Connection manager address can be: http://www.microsoft.com/zh-cn/download/de

1. How to create a linked server in SQL ServerHttp://www.cnblogs.com/spring_wang/p/5409394.html2. How to install SSIS development toolsWhen you install SQL Server, select the SSIS option to3. Examples of use of SSISHttp://www.cnblogs.com/heqichang/archive/2012/09/19/2693214.htmlHttps://wenku.baidu.com/view/915f4ce1d1f34693daef3ef8.htmlHttp://pan.baidu.com/s/1o6iDu904. How to run the

The Web Service task is a newly added task in SSIS that connects to a webservice and executes a method in the service. After executing the method, you can write the results back to a variable or file. This task is suitable for handling information in third-party applications. For example, you can use this task to execute the method in webservice to get Amazon's updated product list and write this information to a local server.In the edit page of the W

The data stream uses memory to buffer the data and process the data transformation in memory, and because memory accesses are very fast, SSIS data Flow conversion performance is very efficient. SSIS engine loads the data into memory in batches, and when data flow loads a new batch of data into memory, the downstream transformation component processes the already loaded into memory, and the destination compo

The SSIS package can be executed to prove that an account with the SSIS package can be executed successfully. The SQL Server Agent default specified account is the Network Service.Then try to set the SQL Server Agent and SQL Server integration Service's startup account to the same account, which is typically configured with the administrator account of the cost machine.Find these two accounts in Configurati

One, the null value of SSIS, the behavior of variable and parameter is the same.In SSIS, variables cannot be set to NULL, and when a value is missing, a variable of each data type uses the default value: The default value of the character type is the null character "", and the default value of the numeric type is the default value of the 0,boolean type is false,datetime the default value is "12/30/ 1899 12:

View a package's historical message data and find that DataFlow Task is frequently faulted, and the description of the error message is:Description: "While reading current row from host, a premature end-of-message is Encountered--an incoming data stream was Interrupted when the server expected to see more data. The host program could have terminated. Ensure that is using a supported client application programming interface (API).The reason for the error is that an error occurs when importing dat

This article directly refers to the blog Park software Life of the article operation, written here only to make a record.To the company side of the first two report server received. To prevent downtime, deploy an SSIS package with disk warnings.Step 1 establishes two variables to receive and write disk capacityStep 2 Create WMI and SMTP connection managersStep 3 Drag a WMI Data Reader Task and configure itNote that almost every option has to be change

1.MaxConcurrentExecutables (concurrency control at the package level)MaxConcurrentExecutables, a package level property in SSIS determines the number of control flow items the can is execute D in parallel. The default value is-1. This is equivalent to number of processors (logical and physical) plus 2.For example, in the below package running on my machine with 4 processors and maxconcurrentexecutables =-1, you can see 6 Tasks has completed execution

Sometimes, using SSIS to import data in Excel to the database, you will find that there is data in the column named excel, but the data in this column in the target library is not imported, and other columns are normal. At first, the direct impression of this problem was caused by the Excel cell format, but it would not work even if this column was converted into a written document. Then I came up with an indirect method: First, save excel as CSV, wh

Why script component Script Component enables us to use. Net custom code in SSIs. We can use it for the following purposes, or we should consider using scriptcomponent when ETL has the following requirements: If we need to perform multiple conversions on the data (for example, adding values to two columns and then calculating the average), we can use scriptcomponent instead of using multiple conversion spaces in the data stream. Access some busines

Code Page in SSIS MSDN interprets Code Page as follows: For character and Unicode data, the Code Page defines the bit mode that represents a specific letter, number, or symbol (for example, 0x20 represents a space, 0x74 represents the character "t "). Some data types Use one byte for each character. The bit mode of each byte can be one of the 256 different bit modes. During Data Coversion of SSIS projects,

Using system;Using system. Collections. Generic;Using system. text;Using dtsruntime = Microsoft. sqlserver. DTS. runtime;Using Microsoft. sqlserver. server;Using system. Data;Using system. xml;Using system. xml. XPath; Namespace ssisrun{Class myeventlistener: dtsruntime. defaultevents{// Self-referenced custom log Writing MethodPrivate Static readonly ilog log = logmanager. getlogger (system. reflection. methodbase. getcurrentmethod (). declaringtype );Public override bool onerror (dtsruntime. d

The SSIS package consists of one control flow and one or more data streams (optional. The following diagram shows the control flow with one container and six tasks. Five of these tasks are defined at the package level, and one is defined at the container level. The task is located in the container. In the control flow toolbox, we can divide the control in the toolbox into two types: Container Control and task control. Now let's take a look at the cont