Data Loading Performance Guide

Bulk loading with large amounts of data requires strategy. The Data Loading Performance Guide for SQL Server 2008 and SQL Server 2005 is a very useful document. Highlights Understanding Minimally Logged Operations Trace Flag 610 (sql server 2008) Summarizing Minimal Logging Conditions Bulk Load Methods Integration Services Data Destinations BCP BULK INSERT INSERT ... SELECT SELECT INTO Choosing Between Bulk Load Methods Data Compression and Bulk Load Other Minimally Logged and Metadata-Only Operations Solving Typical Scenarios with Bulk Loading Optimizing Bulk Load Read More View the the Data Load Performance Guide Bulk Insert CSV into a SQL Server table -... Read more →

SSIS version in SQL Server

How can I find the SSIS version installed ? Integration Services is the management interface for SSIS packages. SQL Server uses the “MsDtsSrvr.exe” for executing packages To highlight the point, configuring the firewall to access Integration Services requires allowing access to port 135 for the “MsDtsSrvr.exe”. Read more on SQL Server - Security Risk Analysis and database security Access the MsDtsSrvr.exe file to view the version number Find and open the following folder: “%programfiles%\Microsoft SQL Server\90\DTS\Binn\” Right-click the MsDtsSrvr.exe file | click Properties. Click the Version tab. View the text after the File version label. The text is the SSIS... Read more →

Excel Connect to SQL Server

Excel connect to SQL Server Connecting to SQL Server from Excel is an easy process. Users want to distribute an Excel document , for example , within a network. Particuarly as there are plenty of libraries the user can access from Excel as a presentation layer. To implement this solution you will need : Microsoft Excel Visual Basic Editor Step 1: Create your Excel workbook Step 2: In Visual Basic Editor create a new project and within Tools | References , select "Microsoft ActiveX Data Objects Library" Step 3: Insert a module into your new project , and create a... Read more →

SQL Server Import Data from DB2 AS400 iSeries

A SQL Server Import Data from DB2 AS400 iSeries is straightforward , once you’ve overcome a few problems. A common error message on a SSIS import is : Text was truncated or one or more characters had no match in the target code paged Associated with the following types of detailed error messages. - Executing (Error) Messages · Error 0xc020901c: Data Flow Task: There was an error with output column "TITLE" (20) on output "OLE DB Source Output" (11). The column status returned was: "Text was truncated or one or more characters had no match in the target code page.".... Read more →

SQL SSIS and service pack upgrade

SSIS 2005 latest service pack upgrade.How to create instructions for tech support to upgrade the SSIS version From the following link http://support.microsoft.com/kb/942177 find out your SSIS version For example : I have this SSIS version in blue in the following table: Service pack level Version number Name of the root node The release version of SSIS 9.0.1399 MyServerName (Integration Services 9.0.1399 - MyDomain\MyUser) SSIS with Service Pack 1 (SP1) 9.0.2047 MyServerName (Integration Services 9.0.2047 - MyDomain\MyUser) SSIS with Service Pack 2 (SP2) 9.0.3042 MyServerName (Integration Services 9.0.3042 - MyDomain\MyUser) To upgrade the SSIS version to 9.0.3042, download from http://www.microsoft.com/downloads/en/details.aspx?FamilyId=D07219B2-1E23-49C8-8F0C-63FA18F26D3A&displaylang=en Source:Jack... Read more →