Bandwidth Monitor
SQLDTS.comSQLIS.comSQLIS Wiki
Troubleshooting
There are always going to be things that don't work first time, second time or even the fifth time but in this section we address some of the more common gotchas and provide the solutions allowing you to move on and create that work of art DTS package.
Excel Inserts Null Values 31 May 2005
156081
Hits
DataPump truncates delimited fields to 255 characters 6 Sep 2003 Intermediate
7.0/2000
49865
Hits
Recurring login failed for user 'xyz' errors 15 Jul 2002
16416
Hits
Using SQL Server DTS with Visual Basic: Resources and Known Issues 2 Jul 2002
67037
Hits
Excel treats First Row of Data as Headers 1 Jun 2002
48179
Hits
Insert Header Row in Excel Spreadsheet 1 Jun 2002
47350
Hits
Removing unwanted or orphan connections from a package 9 May 2002
17455
Hits
Connection password not being saved correctly 6 Apr 2002
11741
Hits
Type Mismatch error when saving a local package 6 Jan 2002
18823
Hits
EXCEPTION_ACCESS_VIOLATION during package execution 14 Dec 2001
39869
Hits
Error occurred during creation of a DTS package 22 Sep 2001
18321
Hits
The property 'Use Encryption for Data' is not supported 22 Sep 2001
16220
Hits
QueryInterface for interface DTS.CustomTask failed 1 Nov 2002 Beginner
2000
23887
Hits
Error saving packages to the Meta Data Services repository 18 Aug 2002
11864
Hits
Service Pack and Version Compatibility Problems 5 Aug 2002
24827
Hits
ActiveX Scripting Initialization Error 15 Oct 2002
52824
Hits