| 269074 |
INF: How to Run a DTS Package as a Scheduled Job |
| 319951 |
HOW TO: Transfer Data to Excel by Using SQL Server Data Transformation Services |
| 917406 |
Error message when you try to modify a SQL Server 2000 DTS package in SQL Server 2005: "The DTS host failed to load or save the package properly" |
| 889170 |
FIX: You receive a "Not enough storage is available to complete this operation" error message when you run a Data Transformation Services package in SQL Server 2000 |
| 828308 |
FIX: An Internet Explorer script error occurs when you access metadata information by using DTS in SQL Server Enterprise Manager |
| 905417 |
FIX: Error message when you try to open SQL Server 2000 Data Transformation Services (DTS) packages in SQL Server Management Studio: "SQL Server 2000 DTS Designer components are required to edit DTS packages" |
| 288910 |
PRB: "Invalid class string" error message when opening DTS package |
| 830773 |
FIX: You receive an EXCEPTION_ACCESS_VIOLATION error message when you try to save a DTS package in SQL Server 2000 |
| 221193 |
How to install Data Transformation Services (DTS) Event Handlers in Visual Basic |
| 240221 |
HOW TO: Handle Errors in Data Transformation Services "Package" and "Step" Objects |
| 298725 |
PRB: Scheduled DTS Package Fails With "Permission Denied: CreateObject" |
| 919131 |
You may experience problems when you try to run a SQL Server 2000 DTS package after you upgrade all the instances of SQL Server 2000 to SQL Server 2005 |
| 323685 |
HOW TO: Troubleshoot DTS Packages That You Run from Visual Basic Applications |
| 818540 |
FIX: SQL Server Enterprise Manager unexpectedly quits when you modify a DTS package |
| 308801 |
FIX: DTSRUN Fails with Errors If the Arguments Have Multiple Space Characters Between Them |
| 236605 |
PRB: DTS Wizard may not detect Excel column type for mixed data in SQL Server |
| 247527 |
FIX: DTS May Truncate Characters When You Export a Table Column of Character Data Type to a Text File |
| 814113 |
FIX: DTS Designer may generate an access violation after you install SQL Server 2000 Service Pack 3 |
| 322746 |
PRB: Data Transformation Services Jobs May Fail Because the Path for Dtsrun.exe Cannot Be Found |
| 282463 |
Managing permissions for DTS packages in an Enterprise environment |
| 308267 |
FIX: DTS Copy Objects Task (DMO) breaks transaction log backup chain by switching recovery mode to Simple during transfer |
| 220163 |
PRB: DTS Does Not Copy Identity, Indexes, Primary Key or Other Constraints |
| 823455 |
FIX: Visual Basic raises a syntax error when you try to compile a file that was created when you saved a DTS package |
| 242391 |
INF: DTS Package Development, Deployment and Performance |
| 241249 |
HOW TO: Obtain a List of DTS Packages |
| 907888 |
Error message when you install the SQL Server 2000 DTS Designer components on a computer that is running Windows 2000: "dtsui.dll failed to register HRESULT -2147024770" |
| 815115 |
FIX: A DTS package that uses global variables ignores an error message raised by RAISERROR |
| 290077 |
FIX: DTS Scheduled Job Does Not Complete After First Run |
| 293320 |
PRB: DTS Transfer From SQL Server to Oracle Through OLE DB Provider Shows Ongoing Private Bytes Consumption |
| 318819 |
PRB: A DTS Package Raises Exceptions or Stops Responding When You Run It as a Scheduled Job |
| 271889 |
PRB: Error message: "Exception Access Violation 2147221499.Need to run the object to perform this operation" occurs when you run a DTS package in Microsoft Visual Basic code |
| 293318 |
FIX: Analysis Services DTS Task Gets Timeout Error During Incremental Update |
| 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" |
| 839986 |
FIX: The Mail Profile combo box is disabled when you use Enterprise Manager to view SQL Server agent properties, and you receive an error message when you try to use the xp_sendmail stored procedure from a DTS package in SQL Server 2000 |
| 319048 |
PRB: Cannot Use Data Transformation Services Event Handlers in Visual Basic with Execute Package Task |
| 912421 |
BUG: Error message when you run, import, or migrate a SQL Server 2000 DTS package that contains an instance of the Analysis Services Processing task in SQL Server 2005: "Invalid class string" |
| 300192 |
BUG: DTS Import/Export Wizard or TransferObjectsTask Fails to Maintain Filegroup Settings for Transferred Objects |
| 870620 |
DTS packages may fail if you run multiple DTS packages that contain Analysis Services Processing tasks at the same time |
| 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" |
| 316043 |
HOW TO: Log Data Transformation Services Package Execution to a Text File |
| 305365 |
PRB: DTS Package Fails with "Unspecified Error" Error Message When You Use Transfer Logins Task to Move a SQL Server Login |
| 300042 |
FIX: DTS Transfer Reports Error "Non-whitespace characters in row" Even Though All Rows are Imported From Text File |
| 839884 |
FIX: A System.ExecutionEngineException exception occurs when you try to access the DTS DynamicPropertiesTaskAssignments collection |
| 316331 |
FIX: DTSTransferObjects with Events Generates an Error Message and an Access Violation in Visual Basic |
| 288438 |
BUG: DTS Send Mail Task Does Not Display Correct Mail Profile Name in DTS Designer |
| 293223 |
FIX: Problems Saving DTS Packages to Visual Basic Files Using the DTS User Interface |
| 921929 |
BUG: When you click "Build Query" in the "Execute SQL Task Properties" dialog box of the SQL Server 2000 DTS package designer, SQL Server 2005 Management Studio unexpectedly closes |
| 288411 |
FIX: "Incorrect syntax near COLLATE" during DTS transfer on SQL Server 7.0 database that is restored to SQL Server 2000 |
| 315994 |
BUG: DTS Wizard Generates Unspecified Error Message If Database with a Period in Name is Used |
| 247825 |
PRB: DTS Copy Table Uses Table Schema of Existing Table |
| 300272 |
FIX: Transfer of a View that Contains a UDF by Using DTS Export Data Fails with Error 208 |
| 249236 |
HOW TO: Return Multiple Columns in a DTS Lookup Query |
| 241761 |
BUG: DTS Transfer Does Not Report Error When Input File Is Missing Text Qualifier in Last Row |
| 917420 |
BUG: You receive an error message when you use the Package Migration Wizard to migrate a DTS package |
| 810927 |
Support for Data Transformation Services in SQL Server 2000 64-bit |
| 300181 |
FIX: DTS Error Message Repeated Multiple Times When You Import from a Text File |
| 310473 |
FIX: Open of DTS Package Fails with Type Mismatch Error Message |
| 301579 |
FIX: "Unspecified error" Raised When Working with DTS Packages on Localized SQL Server 2000 |
| 288189 |
FIX: DTS FTP Task May Fail to Download Files After a Network Problem |
| 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" |
| 299354 |
PRB: DTS Execute Package Task May Fail to Execute Child Package |
| 320304 |
PRB: A DTS Package That You Save as a Visual Basic File May Fail to Import Tab-Delimited Text Data |
| 252439 |
PRB: Use of Math Operations with DTS and Numeric Data Types |
| 292588 |
PRB: Data Transformation Services May Fail to Import DBCS File Using Fixed Field |
| 290644 |
FIX: DTSRun.exe Causes Access Violation on SMP Computers |
| 302828 |
FIX: DTS Fails to Transfer Rows When a Non-Sysadmin User Opens Packages from T-SQL with Xp_cmdshell |
| 288188 |
FIX: DTS Package Reports Success When FTP Task Doesn't Transfer All Files |
| 815126 |
BUG: Renaming tasks or steps by using the DTS Object model results in a non-editable package |
| 246333 |
INF: SQL Server Data Transformation Services and the Microsoft Repository |
| 282966 |
DTS Package Fails with Dynamic Properties Task and OLAP Processing Task |
| 238367 |
PRB: Error Message "Unspecified Error" When Executing a DTS Package Modified Dynamically |
| 288330 |
FIX: FTP Task in DTS Deletes File from the Destination Folder After the Package Completes Execution |
| 286124 |
INF: How to Reschedule a DTS Package |
| 286773 |
FIX: DTS FTP Task Does Not Behave as Expected if Destination Is Out of Space or the Destination File Exists |
| 294956 |
FIX: Enterprise Manager May Cause Access Violation When You Edit a DTS Package with Long User Name |
| 281664 |
PRB: You Must Select the Include All Dependent Objects Checkbox that Depend on Other Objects in DTS |
| 247360 |
PRB: DTS May Skip More Rows than Specified for Fixed-Length Files |
| 885158 |
FIX: Section names are truncated to a total length of 254 characters when you use Data Transformation Services to create a Dynamic Properties task and you add an .ini file in SQL Server 2000 |
| 324982 |
Support WebCast: Data Transformation Services Package Scheduling - An Inside Look |
| 300187 |
BUG: DTS UI Incorrectly Maps Tinyint to Decimal When You Transfer Data to DB2 Using HIS OLEDB Provider for DB2 |
| 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 |
| 962874 |
In SQL Server 2005 or 2008, the DTS designer application cannot be started on a Windows Vista-based computer or on a Windows Server 2008-based computer |
| 300640 |
BUG: DTS Imports Empty Strings for Character Strings That Were Exported as NULLs |
| 291780 |
FIX: DTS Transfer Objects May Fail if Dependent Objects Are Not in Alphabetical Order |
| 249901 |
PRB: DTS Diagram Changes When DTS Package is Opened and Saved Outside the Package Designer |
| 819260 |
BUG: The Transfer of a File by Using an FTP Task in a DTS Package Returns a Success Message Even When the Source File is Not Available |
| 294944 |
FIX: DTSWIZ.exe Closes When Exporting to a Text File if the File Name Contains 255 Characters |
| 293164 |
PRB: Errors May Occur When You Use SQL Server 2000 to Save a DTS Package as a Visual Basic File |
| 286268 |
FIX: User and Owner Passwords are Dimmed When You Save a Package as a File By Using DTSWIZ |
| 261133 |
FIX: DTS "Send Mail" Fills Up Mailbox and Outlook Cannot See or Delete E-Mail Messages |
| 287234 |
FIX: No Vertical Scroll Bar in DTS Dynamic Properties Task Properties Dialog Box |
| 295442 |
FIX: Processing OLAP 7.0 Objects from Analysis Services DTS Task Fails |
| 259304 |
FIX: DTS Fails to Import Last Row If There is No Last Row Terminator |
| 299543 |
FIX: ActiveX Transformation Function Not Triggered If LastRow Option in DTS Transform Data Task Is Less Than or Equal to Actual Number of Source Table Rows |
| 312089 |
BUG: DTS Separates the Columns of Text at Invalid Trail Byte of DBCS |
| 303104 |
PRB: Unable to Save DTS Package to SQL Server When You Use Windows NT 4.0 French Localized Version |
| 325493 |
Support WebCast: The DTS Multiphase Data Pump |
| 259571 |
PRB: DTS Connection Password Is Write Only |
| 287401 |
FIX: Unable to Use GOTO in an Execute SQL Task of a DTS Package |
| 287753 |
PRB: ExOleDB Provider Doesn't Work with SQL Server 2000 DTS Tool |
| 286775 |
FIX: Creating a Publication From Within DTSWIZ Fails with "Error 496: General Error" Error Message |
| 287713 |
FIX: Problems with DTS UI Help Topics |
| 242543 |
INF: DTS Row Level Restartability After an Unexpected Failure |
| 295739 |
BUG: DTS Designer May Stop Responding When You Use Microsoft Jet 4.0 OLE DB Provider |
| 903004 |
You may experience an access violation or data corruption in Analysis Services when you use DTS to merge partitions when lazy processing is occurring |
| 308830 |
FIX: SQL Server Agent Reports "Succeeded" when Scheduled DTS Package Task Fails |
| 300365 |
PRB: DTS FTP Task Does Not Allow User to Return to Parent Directory from an Empty Folder |
| 286503 |
FIX: Publication Options Disabled When Create Publication Wizard Launched from DTS Import/Export Wizard |
| 221480 |
BUG: DTS: Default Scheduling Information Displayed |
| 291307 |
BUG: DTS Message Queue Task May Truncate Messages to 255 Characters |
| 295668 |
FIX: Transaction Replication to DB2 Subscribers Incorrectly Map Tinyint Data Type if You Use DTS to Transform Published Data |
| 294968 |
FIX: Error Processing Partitions in Parallel Through DTS May Cause Processing to Fail |
| 308961 |
FIX: DTS Data Mining Task May Return Syntax Error for Correct Prediction Query |
| 279159 |
BUG: Cancel Button in DTS Package Designer Save Dialog Box Exits Form Without Saving |
| 296774 |
FIX: DTS Logs Processing Messages Even When Package Logging Is Turned Off |
| 286756 |
FIX: DTS Source Logging Fails if Source Contains Unmapped Columns |
| 198141 |
BUG: DTS: Two or More Columns with the Same Name Cannot Transfer |
| 305056 |
FIX: Must Enter DTS Package Name in Subscription Properties |
| 230406 |
BUG: DTS: Preview Shows Column Headers as Data When Invoked Multiple Times |
| 201785 |
How To Import FileSystem Data Using DTS and Index Server |
| 318721 |
FIX: OLAP DTS Processing Task Fails with Error Code -2146828087 (800A00C9) |