Mar
17
2009

Find the top Knowledge Base articles for SSIS

Here are the top Microsoft Support Knowledge Base articles that Integration Services customers have been reading. You may find them useful also.

The numeric columns in the following table represent rank in the indicated period by number of page views:

  • "1" means that KB article got the most hits
  • a higher number means it got fewer
  •  0 (zero) means it didn't get any.

I have sorted the list on the Total column from most viewed to least viewed. This list does not distinguish between SQL Server 2005 and 2008. The fiscal year periods represent the Microsoft July-through-June fiscal year; therefore, FY09 is incomplete. A big thanks yet again to my buddy Jason Howell, the SSIS guru in Microsoft Support, for sending us this list.

KBID Title FY06 FY07 FY08 FY09 Total
918760 An SSIS package does not run when you call the SSIS package from a SQL Server Agent job step 2 1 1 1 1
918644 FIX: The SQL Server Integration Services (SSIS) service does not start when you install SQL Server 2005 SP1 on a computer that is already running the SSIS service 1 2 5 7 2
919224 On a computer that has a 64-bit processor, you receive an error message in SQL Server Management Studio when you connect to SQL Server 2005 Integration Services or when you create or edit a maintenance plan 3 3 4 5 3
931846 You may be unable to execute SQL Server 2005 Integration Services packages that contain script tasks or script components 0 7 2 2 4
932557 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1399 0 8 3 6 5
912911 How to run a SQL Server 2005 Integration Services package as a SQL Server Agent job step 0 20 6 3 6
904800 You receive an "Error loading" error message when you try to run an SQL Server 2005 Integration Services package in SQL Server 2005 4 4 8 9 7
913967 How to add the SQL Server 2005 tools or SQL Server 2005 Integration Services to an existing instance of SQL Server 2005 7 5 9 8 8
942177 How to determine the version of SQL Server 2005 Integration Services 0 0 7 4 9
933835 Error message when an SSIS package runs that is scheduled to run as a SQL Server Agent job: "An OLE DB error has occurred. Error code: 0x80004005" 0 30 10 10 10
906564 How to use SQL Server Business Intelligence Development Studio or the dtutil utility to regenerate the package ID of an SSIS package that was duplicated 5 9 12 18 11
913817 You receive an error message when you use Business Intelligence Development Studio to build a SQL Server 2005 Integration Services package 9 6 15 13 12
906560 How to write information to the Application event log by using a Script task in a SQL Server 2005 Integration Services package 6 10 17 24 13
934653 How to use the 64-bit SQL Server Agent to schedule a SQL Server 2005 Integration Services package 0 35 11 11 14
918038 You receive an error message when you try to load an SSIS package that contains a DateTime type variable in SQL Server 2005 19 17 19 12 15
908460 How to add an incremental counter in a SQL Server 2005 Integration Services package by using a Script component in a Data Flow task 10 13 20 17 16
932555 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 2047 0 11 16 22 17
906562 How to use the dtutil utility (Dtutil.exe) to set the protection level of a batch of SQL Server Integration Services (SSIS) packages in SQL Server 2005 12 12 21 19 18
932556 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1500 and later builds 0 26 13 16 19
906547 How to create a dynamic subject or message for the Send Mail task in SQL Server 2005 Integration Services 14 16 23 20 20
940232 Error message when you use SQL Server Management Studio to connect to SQL Server 2005 Integration Services from a client computer: "Connect to SSIS Service on machine '<SSISServer>' failed Access is denied" 0 0 14 15 21
920205 FIX: A memory leak may occur when you run SQL Server 2005 Integration Services packages that are stored in the SSIS Package store 0 15 24 21 22
942176 Description of the SQL Server Integration Services (SSIS) service and of alternatives to clustering the SSIS service 0 0 18 14 23
931400 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 2153 and later builds 0 23 22 23 24
911310 Error message when you run a Transact-SQL query that involves one or more SQL Server CLR Integration (SQLCLR) objects in SQL Server 2005: "Msg 6535" 8 24 29 31 25
922546 You receive a "No description found" error message when you create an SSIS package or a SQL Server maintenance plan in SQL Server 2005 0 25 26 26 26
922527 FIX: Error message when you schedule some SQL Server 2005 Integration Services packages to run as jobs: "Package <PackageName> has been cancelled" 0 14 30 42 27
906563 How to interpret data that is logged by using a SQL Server 2005 Integration Services log provider 16 27 28 32 28
924016 BUG: You may receive an access violation error message when you try to run an SSIS package in SQL Server 2005 0 22 33 27 29
910419 FIX: You receive an error message when you try to build a project for deployment and the project contains multiple packages that are configured to use a shared configuration file in SQL Server 2005 Integration Services 11 28 34 37 30
925068 Support WebCast: How to use the DataReader Source and the OLE DB Source objects in SQL Server 2005 Integration Services 0 19 37 30 31
918091 FIX: You may receive an error message when you try to run an SSIS package in SQL Server 2005 0 18 38 34 32
918633 The login account of SQL Server 2005 Integration Services changes to Network Service after you install SQL Server 2005 Service Pack 1 17 21 39 44 33
943655 FIX: Error messages when you run a SQL Server 2005 Integration Services package after you install Cumulative Update 2 for SQL Server 2005 Service Pack 2: "Data conversion failed" and "SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR" 0 0 25 25 34
928324 Error message when you use the dtsrun command prompt utility (Dtsrun.exe) to run a DTS package in SQL Server 2005 Integration Services: "This application has failed to start because SQLResourceLoader.dll was not found" 0 38 32 28 35
914375 FIX: You may receive an error message when you run a package that calls other child packages in SQL Server 2005 Integration Services 24 29 41 40 36
904798 SSIS packages that are currently running may unexpectedly stop responding when you restart the SSIS service in SQL Server 2005 13 31 45 51 37
938608 You receive an error message after you install SQL Server 2005 Service Pack 2 when you try to edit a Script component that is inside an SSIS package and the SSIS package was created in an earlier version of SQL Server 2005 0 50 27 29 38
922648 The binary zero (0x00) data and the successive data in a character column is truncated or is replaced with spaces (0x20) when you use the SQL Server Import and Export Wizard to transfer a table in SQL Server 2005 Integration Services 0 36 40 41 39
912423 FIX: Memory leaks occur when you use Fuzzy Lookup and Fuzzy Grouping to transform a SQL Server 2005 Integration Services package 18 32 46 58 40
922436 FIX: You receive an error message in a Visual Studio Just-In-Time Debugger dialog box when you debug a SQL Server 2005 Integration Services package in SQL Server Business Intelligence Development 0 42 35 38 41
941151 How to enable the Sqldumper.exe utility to generate dump files for processes that are related to SQL Server 2005 Integration Services with Service Pack 2 0 0 31 36 42
911838 How to measure the rate at which rows pass through a particular data flow task in a SQL Server 2005 Integration Services (SSIS) package 15 37 50 56 43
928243 FIX: When you run a SQL Server 2005 Integration Services package, the package may stop responding 0 34 51 61 44
928323 FIX: A script task or a script component is executed multiple times in duplicate when you run packages that contain script tasks or script components in parallel in SSIS 0 41 43 48 45
938087 FIX: You experience problems when you use SQL Server Business Intelligence Development Studio to create an SSIS package after you install SQL Server 2005 Service Pack 2 0 51 36 45 46
924346 FIX: An access violation may intermittently occur when you run a SQL Server Integration Services package in SQL Server 2005 0 33 54 65 47
941154 The "SQL Server:SSIS Pipeline" performance object does not appear in the "Performance object" list after you install Integration Services from a 64-bit version of SQL Server 2005 0 0 48 33 48
940220 FIX: Error message when you run a SQL Server 2005 Integration Services package that contains an FTP task: "An error occurred in the requested FTP operation" 0 0 42 43 49
937969 FIX: Error message when you import data from a flat file in a SQL Server 2005 Integration Services (SSIS) package: "There is a partial row at the end of the file" 0 0 44 46 50
920298 FIX: Error message when you try to add a configuration to a SQL Server 2005 Integration Services .dtsx package: "An error occurred while a new configuration was being added" 26 39 57 53 51
942665 FIX: You cannot run some SQL Server 2005 Integration Services packages in Business Intelligence Development Studio if you also run the same packages by using the Dtexec.exe utility 0 0 47 49 52
299362 FIX: Failover of a SQL Virtual Server Causes Problems with Active Directory Integration 20 40 63 70 53
920882 FIX: You cannot deploy a SQL Server 2005 Integration Services package if you use an XML configuration file whose file name contains an uppercase letter 0 44 56 55 54
937100 FIX: Error message when you run a SQL Server 2005 Integration Services package that contains a Script Component transformation:”Insufficient memory to continue the execution of the program” 0 0 49 54 55
922647 You cannot debug assemblies that are referenced in the Script task code by using Visual Studio for Applications in SSIS 0 0 55 47 56
936728 FIX: Error message when you run a SQL Server 2005 Integration Services (SSIS) package that contains a Fuzzy Lookup transformation: "System.Data.SqlClient.SqlException Error number 8101 is invalid" 0 0 52 52 57
942087 FIX: An access violation may occur intermittently in the DTSPipeline.dll file when you run an Integration Services package that contains a Data Flow task in SQL Server 2005 0 0 53 60 58
956381 FIX: Error message when you render a report in SQL Server 2005 SharePoint integrated mode: "An unexpected error occurred while connecting to the report Server. Verify that the Report Server is available and configured for Sharepoint Integration mode" 0 0 0 35 59
910512 Custom events information from a child package is not logged under the log provider context of the parent package in SQL Server 2005 Integration Services 22 43 64 69 60
916497 FIX: You cannot use SQL Server Management Studio to view job steps that have the SSIS data type on an installation of SQL Server 2005 that uses Turkish collation, and you may receive an "Index was outside the bounds of the array" error message 0 46 62 66 61
945893 FIX: Error message when you run a parent package that contains some child packages in SQL Server 2005 Integration Services: "Error: 0xC001000E" 0 0 61 50 62
956911 FIX: A time-out setting is not available for the Web Service task in a Microsoft SQL Server 2005 Integration Services (SSIS) package 0 0 0 39 63
938049 FIX: An SSIS package stops responding when you run the package and the package contains a data flow task that contains one or more MergeJoin transformations in SQL Server 2005 0 52 58 62 64
944678 FIX: SSIS stops responding when you run an SSIS package that uses a Flat File source in a Data Flow task after you install cumulative update package 2 for SQL Server 2005 Service Pack 2 0 0 59 64 65
911821 Item labels in the SQL Server Integration Services toolbox window may appear in an incorrect language 21 48 71 79 66
821337 FIX: Localized versions of SQL Mail and the Web Assistant Wizard may not work as expected in SQL Server 2000 64 bit 23 45 72 82 67
928792 FIX: The output rows of the Aggregate transformation are divided into multiple rows in SQL Server 2005 Integration Services 0 49 66 75 68
910890 SSIS reports that a query was successful when a SQLOLEDB provider ends an SSIS query because of a server error 25 47 73 81 69
952110 Error message when you save a SQL Server 2005 Integration Services package in SQL Server Business Intelligence Development Studio: "Exception of type 'System.OutOfMemoryException' was thrown" 0 0 70 57 70
942666 FIX: The process stops responding when you run an SSIS package that contains a Flat File destination in x64 versions of Microsoft SQL Server 2005 0 0 60 76 71
942905 FIX: Error message when you run a DML statement against a table in a SQL Server 2005 Integration Services package: "Msg 6549, Level 16, State 1, Procedure sp_FuzzyLookupTableMaintenanceInvoke, Line 0" 0 0 65 67 72
945323 FIX: The logins are incorrectly deleted when you run a SQL Server 2005 Integration Services package that contains a Transfer SQL Server Objects task 0 0 67 68 73
953491 FIX: Duplicate data is written to other flat files in an SSIS package that contains a Foreach Loop container 0 0 75 59 74
949040 FIX: The execution fails when you try to run a SQL Server 2005 Integration Services package that contains an Aggregate transformation 0 0 69 71 75
945899 FIX: Incorrect data is inserted into a table when you run a 32-bit SQL Server 2005 Integration Services package on a 64-bit computer 0 0 68 77 76
960161 FIX: The changes to the data source of a SQL Server 2005 Integration Services package may be lost when the package is run by a job 0 0 0 63 77
945914 FIX: Error message when an application that is running as a Windows service calls some SSIS packages: "A variable may only be added once to either the read lock list or the write lock list" 0 0 74 72 78
967316 FIX: The values of some SQL Server 2005 SSIS pipeline counters are always 0 when you try to view them in a terminal session 0 0 0 73 79
955896 FIX: You cannot edit a component that has multiple inputs in a SQL Server 2008 or SQL Server 2005 Integration Services package 0 0 0 74 80
959030 FIX: If you enter many rows into the Fuzzy Grouping transformation, you may obtain an incorrect result in SQL Server 2005 Integration Services 0 0 0 78 81
967570 FIX: An empty result set is returned when you run an SSIS package that contains an Execute SQL task in SQL Server 2005 Service Pack 2 0 0 0 80 82
940370 FIX: The event information that is generated by a child package does not have a "User:" prefix in Integration Services in SQL Server 2005 Service Pack 2 0 0 76 83 83
947987 Error message when you install SSIS or Notification Services on a cluster where the MS DTC service is a cluster resource: "The Transaction Manager is not available. (Exception from HRESULT: 0x8004D01B)" 0 0 77 0 84


 I hope that you find some of these articles helpful!

Please comment on my blog!

You don't have to sign up or sign in - anonymous comments are enabled. I "moderate" the comments to delete spam before you see it, but otherwise, I publish your comments immediately. You can also email me at dougbert@dougbert.com. Thank you!

-Doug

Comments (1) -

Uzzie

Pretty useful article.


Thanks.


Pingbacks and trackbacks (5)+