SSIS Knowledge Base articles : How to in SSIS

SQL Server Integration Services ( SSIS ) Knowledge Base articles

To find one of these articles online, just type in the article number at http://support.microsoft.com/search/.

In some cases, the title listed here may not match the final title of the published article. The articles are listed here in descending order by article number, which should roughly correspond to "most recent first".

SQL Server 2008 Integration Services

KB Article	Title
957803	FIX: DataProfileViewer cannot be started successfully in SQL Server 2008
957239	getKB - SSIS: DataProfileViewer: Unhandled Exception when click "View Single Column Profile By Column" button.
956021	Missing buttons in Chinese (Taiwan) Execute Package Utility
955762	When you migrate a script task created by using Release Candidate 0 version or Community Technology Preview of SQL Server 2008, a reference to the SQL Server Integration Services 2005 may be added to Microsoft.SqlServer.ScriptTask assembly
955796	Visual Studio 2008 Configuration Settings
955953	SSIS Data Mining Model Training Destination Cannot Persist Edits
955709	How to share a package configuration file across multiple packages in SQL Server 2008 Integration Services
955724	SSIS package fails with error DTS_E_CANTCREATESPOOLFILE
955646	SSIS package crashes if VSTA is uninstalled
955713	ActiveX Script tasks in an SSIS package do not run after you uninstall SQL Server 2005 from a computer that has SQL Server 2008 installed
955643	Parsing delimited flat files with variable number of columns
955627	SSIS Data Profile Viewer can be run on 64bit machine
955645	Cannot successfully migrate script tasks or components on IA64
955715	SSIS Scripts can fail to build on machines without Windows SDK
955716	Import/Export Data Wizard mis-identifies types of columns when source is SQL Server via OLEDB and SQL query is used
955633	SSIS Packages with scripts cannot be upgraded on IA64
955632	SSIS perf counter lost during OS upgrade (from Win2K3 to LH)
955717	Commit size in OLE DB dest is changed from 0 to MAX_INT (2147483647)
955631	Yukon tools (BIDS, wizards) doesn't work in Upgrade scenario
955630	Creating Integration Services Connection Project on Workgroup/Web SKU leads to an exception
955634	SSIS Dataflow imports only 1 row from Sybase
955624	Shared components might block SQL Server 2000 upgrade to SQL Server 2008
955621	Packages with Scripts May Not Run on Windows Server 2003 for Itanium-Based Systems
955620	SQL Server 2005 Packages Fail on Windows Server 2003 for Itanium-Based Systems
955525	Dts object is no longer global in SQL 2008 Integration Services Script Tasks
955636	OleDb source adapter may receive only 1 row with Sybase Ole Db Providers

SQL Server 2005 Integration Services

KB Article	Title
962874	007482 Legacy DTS Designer fails to open on Vista or Longhorn
960161	getKB - [SQL 2005 CU11]: SQL 2005 Management Studio Job Step GUI omits SSIS Data Sources
956911	getKB - SQL 2005 SSIS Web Service Task times out after 100 seconds
955896	getKB - Re-mapping dialong not shown if the input for a multi-input component changes.
954159	getKB - SSIS 2005 - StackOverflowException with DTEXEC.exe on a x64 platform
953491	getKB - In case of error, SSIS duplicates data in flat file destination
952110	OutOfMemory exception when saving complex SSIS packages from Business Intelligence Design Studio
949040	getKB - SSIS Crash : Heap Corruption in TxAgg!CAggregate
948582	getKB - Parallel executing and shared lookup task performs invalid lookup reference
945914	getKB - Package Fails When Run Rrom Windows Service with Error: Variable "System::LocaleID" is already on the read list
945899	getKB - Incorrect Data type causes truncation in 64 bit SSIS
945893	getKB - SSIS Child Packages Using Cached Script Task
945323	getKB - SQL Server 2005 - Transfer SQL Server Objects Task can drop logins from source server
944678	getKB - SQL Server Integration Service Flat File Source hangs upon error row after installing SQL Cumulative Update #2
943655	getKB - Fix: SQL 2005 Integration Services Flat File Source causes unexpected conversion errors after CU#2 build 3175 hotfix is installed
942906	getKB - Poor plan choice causing Performance Issues on SQL 2005 as compared to 2000
942905	DML operations against Fuzzy Lookup Reference Table may result in Error 6549 while executing "sp_FuzzyLookupTableMaintenanceInvoke"
942666	getKB - DTExec hangs while exporting to a flat file on 64 bit version
942665	getKB - Race condition between dtexec.exe and msdtssrvr.exe, intermittently cannot enumerate connection managers
942177	How to tell which version of SQL 2005 Integration Services (SSIS) installed
942176	SQL Server 2005 Integration Services - Information on clustering SSIS
942087	FIX: SSIS Package may fail intermittently with exception access violation in "dtspipeline.dll"
941154	PRB: The SQL Server Integration Services Pipeline Performance Counters are Missing on a 64 Bit Machine.
941151	Configure registry keys for SQLDumper to generate a full dump of SSIS
940370	getKB - Events generated by a child package but logged in a parent package no longer has a "User:" prefix
940232	Connecting to SSIS service from non-administrator accounts
940220	SSIS FTP Task may fail to delete remote files on UNIX FTP server
938608	Post SQL 2005 SP2 installation, Script Componenets in SSIS packages may fail to be edited
937969	getKB - When importing data from a flat file using SQL Server 2005 Integration Services (SSIS), you may receive the error "Warning: 0x8020200F at Data Flow Task, Flat File Source [1]: There is a partial row at the end of the file."
937100	SSIS Packages may fail with an error if it contains Script Component that uses VariableDispenser class
936728	FuzzyLookup transformation fails after you install SQL Server 2005 Service Pack 2
934653	How To create 32-bit SSIS jobs on 64-bit servers
933835	INF: SSIS Package fails to execute as a scheduled job using a SQL Agent proxy
931846	SQL Server Integration Services 2005 (SSIS) Script Task and Script Component may need to be recompiled after installing.Net security fixes
928792	getKB - Hotfix Request: Aggregate component divides the aggregations into several rows.
928324	Installation of SSIS Only On a SQL 2000 Server Causes Existing DTS Packages W/ ActiveX Scripting to Fail
928323	Fix: SQL 2005 SSIS package Script tasks and Script Components get executed in the wrong order when nested in child packages which are copied and pasted.
928319	.NET 1.0/1.1 application that uses MSXML fails after installing SQL Server 2005
928243	BUG: SSIS Package With Merge Join Transformation Hangs and Does Not Complete
926629	Unable to Connect to SSIS in MSSMS after ONLY applying the SSIS QFE2152 in X64 machine
924016	SSIS Package Generates Exception From Concurrent Execution of Lookup Data Flow Tasks
922648	Character Data that Contains Embedded Binary Zero is Truncated During SSIS Transfer
922647	Script Task Editor Cannot Debug Referenced Class Libraries
922527	getKB - SSIS Package fails with message "Package <Package Name> has been cancelled"
922436	ContentIdea - SSIS Access Violation when using a Merge Join data flow component, when the destination experiences an error
921929	SQL 2005 Management Studio ends unexpectedly when editing a legacy DTS package and using the Build Query button to open the Data Transformation Services Query Designer
920298	getKB - Error when adding a Configuration to a Non-Solution dtsx Package File
920205	getKB - Memory Leak in MsDtsSrvr.exe
919768	getKB - SQL Server Integration Services service (MsDtsSrvr.exe) leaks memory on x64 and IA64 platforms
919131	DTS 2000 packages fail after upgrading all SQL 2000 instances to SQL 2005
918760	SSIS Package fails when executing via SQL Server Agent Job Step but succeeds outside of SQL Server Agent
918091	getKB - Project REAL -- Variable locking error when package is running without debugger. - sql hotfix 50000154
918038	Package fails when user locale is different than original package creation
917406	Unable to open DTS Packages saved from SQL2K on Win2K computers
914805	Expression on components inside a Dataflow task gets orphaned if the component is renamed
914375	getKB - Connection manager sometimes fails with 0x8004D00A ("Unable to enlist in the transaction.")
913817	Third-party apps can break SSIS component (Task/Connection/etc) object enumeration
912425	Fail to create a deployment manifest if 2 packages in the project share the same configuration file
912423	getKB - Memory Leak with Fuzzy Grouping\Fuzzy Lookup - sql hotfix 65
912421	'Invalid class string' error when attempting to execute, import, or migrate a DTS 2000 package which contains an instance of the Analysis Services Processing Task
911936	Installing SQL Server 2005 Redist package DTS fails on Windows 2000 Advanced Server Service Pack 4 if MDAC is of version less than 2.6
911838	Script for instrumenting the flow-rate of rows through the pipeline
911821	SSIS toolbox items show with label text in the wrong language.
911003	Unable to export a table with the SSIS Import\Export Wizard when the table name contains special characters
910891	SSIS package fails with message about insufficient product level
910890	SQLOLEDB provider to return end of rowset instead of an error when an error is encountered on the server side
910881	Unable to create a table with the SSIS Import Export wizard when the table names contain characters such as * / \ ?
910880	Unable to Export Database when the database name contains Special Characters
908460	How to add an incremental counter field to an SSIS data fow
908018	Creating package templates to re-use common objects and settings such as Connection Managers, and Log Providers
906564	Implications of duplicate package ID and the use of DTUTIL.exe to re-generate Package IDs before deploying to your production environment
906563	Behavior and lableing for log entries posted by a Child Package
906562	Considering Package Protection Level as part of your package deployment plan\best practices, and Batch editing with DTUTIL.exe
906560	Sample Script to post row counts to the windows event log
906547	How to create a dynamic subjet or message for a Send Mail Task
905617	Message field truncated to 128 characters in .trc file created by SQL Profiler log provider
904800	Error message: Error loading [your package name]: Failed to decrypt
904798	Whenever I restart the SQL Server Integration Services Windows Service, currently executing packages are stopped?
904796	HOW TO: Ensure Support for DTS Repository Packages after Upgrading to SQL Server 2005.