Java 1.5 JRE Exception List

Got this with the help of jar-explorer.

deploy.jar : com/sun/deploy/association/AssociationAlreadyRegisteredException.class

deploy.jar : com/sun/deploy/association/AssociationException.class

deploy.jar : com/sun/deploy/association/AssociationNotRegisteredException.class

deploy.jar : com/sun/deploy/association/RegisterFailedException.class

deploy.jar : com/sun/deploy/net/cookie/CookieUnavailableException.class

deploy.jar : com/sun/deploy/net/proxy/ProxyConfigException.class

deploy.jar : com/sun/deploy/net/proxy/ProxyUnavailableException.class

deploy.jar : com/sun/deploy/security/CertificateConfigException.class

deploy.jar : com/sun/deploy/xml/BadTokenException.class

sunpkcs11.jar : sun/security/pkcs11/ConfigurationException.class

sunpkcs11.jar : sun/security/pkcs11/wrapper/PKCS11Exception.class

sunpkcs11.jar : sun/security/pkcs11/wrapper/PKCS11RuntimeException.class

javaws.jar : com/sun/javaws/exceptions/BadFieldException.class

javaws.jar : com/sun/javaws/exceptions/BadJARFileException.class

javaws.jar : com/sun/javaws/exceptions/BadMimeTypeResponseException.class

javaws.jar : com/sun/javaws/exceptions/BadVersionResponseException.class

javaws.jar : com/sun/javaws/exceptions/CacheAccessException.class

javaws.jar : com/sun/javaws/exceptions/CouldNotLoadArgumentException.class

javaws.jar : com/sun/javaws/exceptions/DownloadException.class

javaws.jar : com/sun/javaws/exceptions/ErrorCodeResponseException.class

javaws.jar : com/sun/javaws/exceptions/ExitException.class

javaws.jar : com/sun/javaws/exceptions/FailedDownloadingResourceException.class

javaws.jar : com/sun/javaws/exceptions/InvalidJarDiffException.class

javaws.jar : com/sun/javaws/exceptions/JARSigningException.class

javaws.jar : com/sun/javaws/exceptions/JNLParseException.class

javaws.jar : com/sun/javaws/exceptions/JNLPException.class

javaws.jar : com/sun/javaws/exceptions/JNLPSigningException.class

javaws.jar : com/sun/javaws/exceptions/JreExecException.class

javaws.jar : com/sun/javaws/exceptions/LaunchDescException.class

javaws.jar : com/sun/javaws/exceptions/MissingFieldException.class

javaws.jar : com/sun/javaws/exceptions/MissingVersionResponseException.class

javaws.jar : com/sun/javaws/exceptions/MultipleHostsException.class

javaws.jar : com/sun/javaws/exceptions/NativeLibViolationException.class

javaws.jar : com/sun/javaws/exceptions/NoLocalJREException.class

javaws.jar : com/sun/javaws/exceptions/OfflineLaunchException.class

javaws.jar : com/sun/javaws/exceptions/TooManyArgumentsException.class

javaws.jar : com/sun/javaws/exceptions/UnsignedAccessViolationException.class

javaws.jar : com/sun/javaws/net/CanceledDownloadException.class

javaws.jar : javax/jnlp/UnavailableServiceException.class

jce.jar : javax/crypto/BadPaddingException.class

jce.jar : javax/crypto/ExemptionMechanismException.class

jce.jar : javax/crypto/IllegalBlockSizeException.class

jce.jar : javax/crypto/NoSuchPaddingException.class

jce.jar : javax/crypto/ShortBufferException.class

jsse.jar : javax/net/ssl/SSLException.class

jsse.jar : javax/net/ssl/SSLHandshakeException.class

jsse.jar : javax/net/ssl/SSLKeyException.class

jsse.jar : javax/net/ssl/SSLPeerUnverifiedException.class

jsse.jar : javax/net/ssl/SSLProtocolException.class

jsse.jar : javax/security/cert/CertificateEncodingException.class

jsse.jar : javax/security/cert/CertificateException.class

jsse.jar : javax/security/cert/CertificateExpiredException.class

jsse.jar : javax/security/cert/CertificateNotYetValidException.class

jsse.jar : javax/security/cert/CertificateParsingException.class

plugin.jar : netscape/javascript/JSException.class

plugin.jar : netscape/security/ForbiddenTargetException.class

plugin.jar : sun/plugin/cache/DownloadException.class

plugin.jar : sun/plugin/cache/JarCacheVersionException.class

plugin.jar : sun/plugin/dom/exception/BrowserNotSupportedException.class

plugin.jar : sun/plugin/dom/exception/HierarchyRequestException.class

plugin.jar : sun/plugin/dom/exception/InvalidAccessException.class

plugin.jar : sun/plugin/dom/exception/InvalidStateException.class

plugin.jar : sun/plugin/dom/exception/NoModificationAllowedException.class

plugin.jar : sun/plugin/dom/exception/PluginNotSupportedException.class

plugin.jar : sun/plugin/dom/exception/WrongDocumentException.class

plugin.jar : sun/plugin/liveconnect/OriginNotAllowedException.class

rt.jar : com/sun/corba/se/impl/corba/ExceptionListImpl.class

rt.jar : com/sun/corba/se/impl/io/OptionalDataException.class

rt.jar : com/sun/corba/se/impl/io/TypeMismatchException.class

rt.jar : com/sun/corba/se/impl/logging/ActivationSystemException$1.class

rt.jar : com/sun/corba/se/impl/logging/ActivationSystemException.class

rt.jar : com/sun/corba/se/impl/logging/InterceptorsSystemException$1.class

rt.jar : com/sun/corba/se/impl/logging/InterceptorsSystemException.class

rt.jar : com/sun/corba/se/impl/logging/IORSystemException$1.class

rt.jar : com/sun/corba/se/impl/logging/IORSystemException.class

rt.jar : com/sun/corba/se/impl/logging/NamingSystemException$1.class

rt.jar : com/sun/corba/se/impl/logging/NamingSystemException.class

rt.jar : com/sun/corba/se/impl/logging/OMGSystemException$1.class

rt.jar : com/sun/corba/se/impl/logging/OMGSystemException.class

rt.jar : com/sun/corba/se/impl/logging/ORBUtilSystemException$1.class

rt.jar : com/sun/corba/se/impl/logging/ORBUtilSystemException.class

rt.jar : com/sun/corba/se/impl/logging/POASystemException$1.class

rt.jar : com/sun/corba/se/impl/logging/POASystemException.class

rt.jar : com/sun/corba/se/impl/logging/UtilSystemException$1.class

rt.jar : com/sun/corba/se/impl/logging/UtilSystemException.class

rt.jar : com/sun/corba/se/impl/orbutil/threadpool/TimeoutException.class

rt.jar : com/sun/corba/se/impl/presentation/rmi/ExceptionHandler.class

rt.jar : com/sun/corba/se/impl/presentation/rmi/ExceptionHandlerImpl$ExceptionRW.class

rt.jar : com/sun/corba/se/impl/presentation/rmi/ExceptionHandlerImpl$ExceptionRWBase.class

rt.jar : com/sun/corba/se/impl/presentation/rmi/ExceptionHandlerImpl$ExceptionRWIDLImpl.class

rt.jar : com/sun/corba/se/impl/presentation/rmi/ExceptionHandlerImpl$ExceptionRWRMIImpl.class

rt.jar : com/sun/corba/se/impl/presentation/rmi/ExceptionHandlerImpl.class

rt.jar : com/sun/corba/se/impl/presentation/rmi/IDLTypeException.class

rt.jar : com/sun/corba/se/impl/protocol/AddressingDispositionException.class

rt.jar : com/sun/corba/se/impl/protocol/RequestCanceledException.class

rt.jar : com/sun/corba/se/spi/copyobject/ReflectiveCopyException.class

rt.jar : com/sun/corba/se/spi/legacy/connection/GetEndPointInfoAgainException.class

rt.jar : com/sun/corba/se/spi/orbutil/threadpool/NoSuchThreadPoolException.class

rt.jar : com/sun/corba/se/spi/orbutil/threadpool/NoSuchWorkQueueException.class

rt.jar : com/sun/corba/se/spi/protocol/ForwardException.class

rt.jar : com/sun/image/codec/jpeg/ImageFormatException.class

rt.jar : com/sun/image/codec/jpeg/TruncatedFileException.class

rt.jar : com/sun/imageio/plugins/jpeg/JFIFMarkerSegment$IllegalThumbException.class

rt.jar : com/sun/java/browser/dom/DOMAccessException.class

rt.jar : com/sun/java/browser/dom/DOMUnsupportedException.class

rt.jar : com/sun/java/util/jar/pack/Attribute$FormatException.class

rt.jar : com/sun/jmx/snmp/BerException.class

rt.jar : com/sun/jmx/snmp/daemon/CommunicationException.class

rt.jar : com/sun/jmx/snmp/IPAcl/ParseException.class

rt.jar : com/sun/jmx/snmp/SnmpBadSecurityLevelException.class

rt.jar : com/sun/jmx/snmp/SnmpSecurityException.class

rt.jar : com/sun/jmx/snmp/SnmpStatusException.class

rt.jar : com/sun/jmx/snmp/SnmpTooBigException.class

rt.jar : com/sun/jmx/snmp/SnmpUnknownAccContrModelException.class

rt.jar : com/sun/jmx/snmp/SnmpUnknownModelException.class

rt.jar : com/sun/jmx/snmp/SnmpUnknownModelLcdException.class

rt.jar : com/sun/jmx/snmp/SnmpUnknownMsgProcModelException.class

rt.jar : com/sun/jmx/snmp/SnmpUnknownSecModelException.class

rt.jar : com/sun/jmx/snmp/SnmpUnknownSubSystemException.class

rt.jar : com/sun/jndi/cosnaming/ExceptionMapper$1.class

rt.jar : com/sun/jndi/cosnaming/ExceptionMapper$2.class

rt.jar : com/sun/jndi/cosnaming/ExceptionMapper.class

rt.jar : com/sun/jndi/ldap/Ber$DecodeException.class

rt.jar : com/sun/jndi/ldap/Ber$EncodeException.class

rt.jar : com/sun/jndi/ldap/LdapReferralException.class

rt.jar : com/sun/org/apache/bcel/internal/classfile/CodeException.class

rt.jar : com/sun/org/apache/bcel/internal/classfile/ExceptionTable.class

rt.jar : com/sun/org/apache/bcel/internal/ExceptionConstants.class

rt.jar : com/sun/org/apache/bcel/internal/generic/ClassGenException.class

rt.jar : com/sun/org/apache/bcel/internal/generic/CodeExceptionGen.class

rt.jar : com/sun/org/apache/bcel/internal/generic/ExceptionThrower.class

rt.jar : com/sun/org/apache/bcel/internal/generic/TargetLostException.class

rt.jar : com/sun/org/apache/bcel/internal/verifier/exc/AssertionViolatedException.class

rt.jar : com/sun/org/apache/bcel/internal/verifier/exc/ClassConstraintException.class

rt.jar : com/sun/org/apache/bcel/internal/verifier/exc/CodeConstraintException.class

rt.jar : com/sun/org/apache/bcel/internal/verifier/exc/InvalidMethodException.class

rt.jar : com/sun/org/apache/bcel/internal/verifier/exc/LinkingConstraintException.class

rt.jar : com/sun/org/apache/bcel/internal/verifier/exc/LoadingException.class

rt.jar : com/sun/org/apache/bcel/internal/verifier/exc/LocalVariableInfoInconsistentException.class

rt.jar : com/sun/org/apache/bcel/internal/verifier/exc/StaticCodeConstraintException.class

rt.jar : com/sun/org/apache/bcel/internal/verifier/exc/StaticCodeInstructionConstraintException.class

rt.jar : com/sun/org/apache/bcel/internal/verifier/exc/StaticCodeInstructionOperandConstraintException.class

rt.jar : com/sun/org/apache/bcel/internal/verifier/exc/StructuralCodeConstraintException.class

rt.jar : com/sun/org/apache/bcel/internal/verifier/exc/VerificationException.class

rt.jar : com/sun/org/apache/bcel/internal/verifier/exc/VerifierConstraintViolatedException.class

rt.jar : com/sun/org/apache/bcel/internal/verifier/structurals/ExceptionHandler.class

rt.jar : com/sun/org/apache/bcel/internal/verifier/structurals/ExceptionHandlers.class

rt.jar : com/sun/org/apache/regexp/internal/RESyntaxException.class

rt.jar : com/sun/org/apache/xalan/internal/xsltc/cmdline/getopt/GetOptsException.class

rt.jar : com/sun/org/apache/xalan/internal/xsltc/cmdline/getopt/IllegalArgumentException.class

rt.jar : com/sun/org/apache/xalan/internal/xsltc/cmdline/getopt/MissingOptArgException.class

rt.jar : com/sun/org/apache/xalan/internal/xsltc/compiler/CompilerException.class

rt.jar : com/sun/org/apache/xalan/internal/xsltc/compiler/IllegalCharException.class

rt.jar : com/sun/org/apache/xalan/internal/xsltc/TransletException.class

rt.jar : com/sun/org/apache/xerces/internal/dom/RangeExceptionImpl.class

rt.jar : com/sun/org/apache/xerces/internal/dom3/as/DOMASException.class

rt.jar : com/sun/org/apache/xerces/internal/impl/dv/DatatypeException.class

rt.jar : com/sun/org/apache/xerces/internal/impl/dv/DVFactoryException.class

rt.jar : com/sun/org/apache/xerces/internal/impl/dv/InvalidDatatypeFacetException.class

rt.jar : com/sun/org/apache/xerces/internal/impl/dv/InvalidDatatypeValueException.class

rt.jar : com/sun/org/apache/xerces/internal/impl/dv/xs/SchemaDateTimeException.class

rt.jar : com/sun/org/apache/xerces/internal/impl/io/MalformedByteSequenceException.class

rt.jar : com/sun/org/apache/xerces/internal/impl/xpath/regex/ParseException.class

rt.jar : com/sun/org/apache/xerces/internal/impl/xpath/XPathException.class

rt.jar : com/sun/org/apache/xerces/internal/impl/xs/XMLSchemaException.class

rt.jar : com/sun/org/apache/xerces/internal/jaxp/validation/WrappedSAXException.class

rt.jar : com/sun/org/apache/xerces/internal/util/URI$MalformedURIException.class

rt.jar : com/sun/org/apache/xerces/internal/xni/parser/XMLConfigurationException.class

rt.jar : com/sun/org/apache/xerces/internal/xni/parser/XMLParseException.class

rt.jar : com/sun/org/apache/xerces/internal/xni/XNIException.class

rt.jar : com/sun/org/apache/xerces/internal/xs/XSException.class

rt.jar : com/sun/org/apache/xml/internal/dtm/DTMConfigurationException.class

rt.jar : com/sun/org/apache/xml/internal/dtm/DTMDOMException.class

rt.jar : com/sun/org/apache/xml/internal/dtm/DTMException.class

rt.jar : com/sun/org/apache/xml/internal/dtm/ref/DTMNamedNodeMap$DTMException.class

rt.jar : com/sun/org/apache/xml/internal/dtm/ref/IncrementalSAXSource_Filter$StopException.class

rt.jar : com/sun/org/apache/xml/internal/utils/StopParseException.class

rt.jar : com/sun/org/apache/xml/internal/utils/URI$MalformedURIException.class

rt.jar : com/sun/org/apache/xml/internal/utils/WrappedRuntimeException.class

rt.jar : com/sun/org/apache/xml/internal/utils/WrongParserException.class

rt.jar : com/sun/org/apache/xpath/internal/functions/WrongNumberArgsException.class

rt.jar : com/sun/org/apache/xpath/internal/XPathException.class

rt.jar : com/sun/org/apache/xpath/internal/XPathProcessorException.class

rt.jar : com/sun/org/omg/CORBA/ExceptionDescription.class

rt.jar : com/sun/org/omg/CORBA/ExceptionDescriptionHelper.class

rt.jar : com/sun/security/auth/PolicyParser$ParsingException.class

rt.jar : java/awt/AWTException.class

rt.jar : java/awt/color/CMMException.class

rt.jar : java/awt/color/ProfileDataException.class

rt.jar : java/awt/datatransfer/MimeTypeParseException.class

rt.jar : java/awt/datatransfer/UnsupportedFlavorException.class

rt.jar : java/awt/dnd/InvalidDnDOperationException.class

rt.jar : java/awt/FontFormatException.class

rt.jar : java/awt/geom/IllegalPathStateException.class

rt.jar : java/awt/geom/NoninvertibleTransformException.class

rt.jar : java/awt/HeadlessException.class

rt.jar : java/awt/IllegalComponentStateException.class

rt.jar : java/awt/image/ImagingOpException.class

rt.jar : java/awt/image/RasterFormatException.class

rt.jar : java/awt/print/PrinterAbortException.class

rt.jar : java/awt/print/PrinterException.class

rt.jar : java/awt/print/PrinterIOException.class

rt.jar : java/beans/ExceptionListener.class

rt.jar : java/beans/IntrospectionException.class

rt.jar : java/beans/PropertyVetoException.class

rt.jar : java/io/CharConversionException.class

rt.jar : java/io/EOFException.class

rt.jar : java/io/FileNotFoundException.class

rt.jar : java/io/InterruptedIOException.class

rt.jar : java/io/InvalidClassException.class

rt.jar : java/io/InvalidObjectException.class

rt.jar : java/io/IOException.class

rt.jar : java/io/NotActiveException.class

rt.jar : java/io/NotSerializableException.class

rt.jar : java/io/ObjectStreamException.class

rt.jar : java/io/OptionalDataException.class

rt.jar : java/io/StreamCorruptedException.class

rt.jar : java/io/SyncFailedException.class

rt.jar : java/io/UnsupportedEncodingException.class

rt.jar : java/io/UTFDataFormatException.class

rt.jar : java/io/WriteAbortedException.class

rt.jar : java/lang/annotation/AnnotationTypeMismatchException.class

rt.jar : java/lang/annotation/IncompleteAnnotationException.class

rt.jar : java/lang/ArithmeticException.class

rt.jar : java/lang/ArrayIndexOutOfBoundsException.class

rt.jar : java/lang/ArrayStoreException.class

rt.jar : java/lang/ClassCastException.class

rt.jar : java/lang/ClassNotFoundException.class

rt.jar : java/lang/CloneNotSupportedException.class

rt.jar : java/lang/EnumConstantNotPresentException.class

rt.jar : java/lang/Exception.class

rt.jar : java/lang/ExceptionInInitializerError.class

rt.jar : java/lang/IllegalAccessException.class

rt.jar : java/lang/IllegalArgumentException.class

rt.jar : java/lang/IllegalMonitorStateException.class

rt.jar : java/lang/IllegalStateException.class

rt.jar : java/lang/IllegalThreadStateException.class

rt.jar : java/lang/IndexOutOfBoundsException.class

rt.jar : java/lang/InstantiationException.class

rt.jar : java/lang/instrument/IllegalClassFormatException.class

rt.jar : java/lang/instrument/UnmodifiableClassException.class

rt.jar : java/lang/InterruptedException.class

rt.jar : java/lang/NegativeArraySizeException.class

rt.jar : java/lang/NoSuchFieldException.class

rt.jar : java/lang/NoSuchMethodException.class

rt.jar : java/lang/NullPointerException.class

rt.jar : java/lang/NumberFormatException.class

rt.jar : java/lang/reflect/InvocationTargetException.class

rt.jar : java/lang/reflect/MalformedParameterizedTypeException.class

rt.jar : java/lang/reflect/UndeclaredThrowableException.class

rt.jar : java/lang/RuntimeException.class

rt.jar : java/lang/SecurityException.class

rt.jar : java/lang/StringIndexOutOfBoundsException.class

rt.jar : java/lang/Thread$UncaughtExceptionHandler.class

rt.jar : java/lang/TypeNotPresentException.class

rt.jar : java/lang/UnsupportedOperationException.class

rt.jar : java/net/BindException.class

rt.jar : java/net/ConnectException.class

rt.jar : java/net/HttpRetryException.class

rt.jar : java/net/MalformedURLException.class

rt.jar : java/net/NoRouteToHostException.class

rt.jar : java/net/PortUnreachableException.class

rt.jar : java/net/ProtocolException.class

rt.jar : java/net/SocketException.class

rt.jar : java/net/SocketTimeoutException.class

rt.jar : java/net/UnknownHostException.class

rt.jar : java/net/UnknownServiceException.class

rt.jar : java/net/URISyntaxException.class

rt.jar : java/nio/BufferOverflowException.class

rt.jar : java/nio/BufferUnderflowException.class

rt.jar : java/nio/channels/AlreadyConnectedException.class

rt.jar : java/nio/channels/AsynchronousCloseException.class

rt.jar : java/nio/channels/CancelledKeyException.class

rt.jar : java/nio/channels/ClosedByInterruptException.class

rt.jar : java/nio/channels/ClosedChannelException.class

rt.jar : java/nio/channels/ClosedSelectorException.class

rt.jar : java/nio/channels/ConnectionPendingException.class

rt.jar : java/nio/channels/FileLockInterruptionException.class

rt.jar : java/nio/channels/IllegalBlockingModeException.class

rt.jar : java/nio/channels/IllegalSelectorException.class

rt.jar : java/nio/channels/NoConnectionPendingException.class

rt.jar : java/nio/channels/NonReadableChannelException.class

rt.jar : java/nio/channels/NonWritableChannelException.class

rt.jar : java/nio/channels/NotYetBoundException.class

rt.jar : java/nio/channels/NotYetConnectedException.class

rt.jar : java/nio/channels/OverlappingFileLockException.class

rt.jar : java/nio/channels/UnresolvedAddressException.class

rt.jar : java/nio/channels/UnsupportedAddressTypeException.class

rt.jar : java/nio/charset/CharacterCodingException.class

rt.jar : java/nio/charset/IllegalCharsetNameException.class

rt.jar : java/nio/charset/MalformedInputException.class

rt.jar : java/nio/charset/UnmappableCharacterException.class

rt.jar : java/nio/charset/UnsupportedCharsetException.class

rt.jar : java/nio/InvalidMarkException.class

rt.jar : java/nio/ReadOnlyBufferException.class

rt.jar : java/rmi/AccessException.class

rt.jar : java/rmi/activation/ActivateFailedException.class

rt.jar : java/rmi/activation/ActivationException.class

rt.jar : java/rmi/activation/UnknownGroupException.class

rt.jar : java/rmi/activation/UnknownObjectException.class

rt.jar : java/rmi/AlreadyBoundException.class

rt.jar : java/rmi/ConnectException.class

rt.jar : java/rmi/ConnectIOException.class

rt.jar : java/rmi/MarshalException.class

rt.jar : java/rmi/NoSuchObjectException.class

rt.jar : java/rmi/NotBoundException.class

rt.jar : java/rmi/RemoteException.class

rt.jar : java/rmi/RMISecurityException.class

rt.jar : java/rmi/server/ExportException.class

rt.jar : java/rmi/server/ServerCloneException.class

rt.jar : java/rmi/server/ServerNotActiveException.class

rt.jar : java/rmi/server/SkeletonMismatchException.class

rt.jar : java/rmi/server/SkeletonNotFoundException.class

rt.jar : java/rmi/server/SocketSecurityException.class

rt.jar : java/rmi/ServerException.class

rt.jar : java/rmi/ServerRuntimeException.class

rt.jar : java/rmi/StubNotFoundException.class

rt.jar : java/rmi/UnexpectedException.class

rt.jar : java/rmi/UnknownHostException.class

rt.jar : java/rmi/UnmarshalException.class

rt.jar : java/security/AccessControlException.class

rt.jar : java/security/acl/AclNotFoundException.class

rt.jar : java/security/acl/LastOwnerException.class

rt.jar : java/security/acl/NotOwnerException.class

rt.jar : java/security/cert/CertificateEncodingException.class

rt.jar : java/security/cert/CertificateException.class

rt.jar : java/security/cert/CertificateExpiredException.class

rt.jar : java/security/cert/CertificateNotYetValidException.class

rt.jar : java/security/cert/CertificateParsingException.class

rt.jar : java/security/cert/CertPathBuilderException.class

rt.jar : java/security/cert/CertPathValidatorException.class

rt.jar : java/security/cert/CertStoreException.class

rt.jar : java/security/cert/CRLException.class

rt.jar : java/security/DigestException.class

rt.jar : java/security/GeneralSecurityException.class

rt.jar : java/security/InvalidAlgorithmParameterException.class

rt.jar : java/security/InvalidKeyException.class

rt.jar : java/security/InvalidParameterException.class

rt.jar : java/security/KeyException.class

rt.jar : java/security/KeyManagementException.class

rt.jar : java/security/KeyStoreException.class

rt.jar : java/security/NoSuchAlgorithmException.class

rt.jar : java/security/NoSuchProviderException.class

rt.jar : java/security/PrivilegedActionException.class

rt.jar : java/security/PrivilegedExceptionAction.class

rt.jar : java/security/ProviderException.class

rt.jar : java/security/SignatureException.class

rt.jar : java/security/spec/InvalidKeySpecException.class

rt.jar : java/security/spec/InvalidParameterSpecException.class

rt.jar : java/security/UnrecoverableEntryException.class

rt.jar : java/security/UnrecoverableKeyException.class

rt.jar : java/sql/BatchUpdateException.class

rt.jar : java/sql/SQLException.class

rt.jar : java/text/ParseException.class

rt.jar : java/util/concurrent/BrokenBarrierException.class

rt.jar : java/util/concurrent/CancellationException.class

rt.jar : java/util/concurrent/ExecutionException.class

rt.jar : java/util/concurrent/Executors$PrivilegedExceptionActionAdapter.class

rt.jar : java/util/concurrent/RejectedExecutionException.class

rt.jar : java/util/concurrent/TimeoutException.class

rt.jar : java/util/ConcurrentModificationException.class

rt.jar : java/util/DuplicateFormatFlagsException.class

rt.jar : java/util/EmptyStackException.class

rt.jar : java/util/FormatFlagsConversionMismatchException.class

rt.jar : java/util/FormatterClosedException.class

rt.jar : java/util/IllegalFormatCodePointException.class

rt.jar : java/util/IllegalFormatConversionException.class

rt.jar : java/util/IllegalFormatException.class

rt.jar : java/util/IllegalFormatFlagsException.class

rt.jar : java/util/IllegalFormatPrecisionException.class

rt.jar : java/util/IllegalFormatWidthException.class

rt.jar : java/util/InputMismatchException.class

rt.jar : java/util/InvalidPropertiesFormatException.class

rt.jar : java/util/jar/JarException.class

rt.jar : java/util/MissingFormatArgumentException.class

rt.jar : java/util/MissingFormatWidthException.class

rt.jar : java/util/MissingResourceException.class

rt.jar : java/util/NoSuchElementException.class

rt.jar : java/util/prefs/BackingStoreException.class

rt.jar : java/util/prefs/InvalidPreferencesFormatException.class

rt.jar : java/util/regex/PatternSyntaxException.class

rt.jar : java/util/TooManyListenersException.class

rt.jar : java/util/UnknownFormatConversionException.class

rt.jar : java/util/UnknownFormatFlagsException.class

rt.jar : java/util/zip/DataFormatException.class

rt.jar : java/util/zip/ZipException.class

rt.jar : javax/activity/ActivityCompletedException.class

rt.jar : javax/activity/ActivityRequiredException.class

rt.jar : javax/activity/InvalidActivityException.class

rt.jar : javax/imageio/IIOException.class

rt.jar : javax/imageio/metadata/IIODOMException.class

rt.jar : javax/imageio/metadata/IIOInvalidTreeException.class

rt.jar : javax/management/AttributeNotFoundException.class

rt.jar : javax/management/BadAttributeValueExpException.class

rt.jar : javax/management/BadBinaryOpValueExpException.class

rt.jar : javax/management/BadStringOperationException.class

rt.jar : javax/management/InstanceAlreadyExistsException.class

rt.jar : javax/management/InstanceNotFoundException.class

rt.jar : javax/management/IntrospectionException.class

rt.jar : javax/management/InvalidApplicationException.class

rt.jar : javax/management/InvalidAttributeValueException.class

rt.jar : javax/management/JMException.class

rt.jar : javax/management/JMRuntimeException.class

rt.jar : javax/management/ListenerNotFoundException.class

rt.jar : javax/management/MalformedObjectNameException.class

rt.jar : javax/management/MBeanException.class

rt.jar : javax/management/MBeanRegistrationException.class

rt.jar : javax/management/modelmbean/InvalidTargetObjectTypeException.class

rt.jar : javax/management/modelmbean/XMLParseException.class

rt.jar : javax/management/monitor/MonitorSettingException.class

rt.jar : javax/management/NotCompliantMBeanException.class

rt.jar : javax/management/openmbean/InvalidKeyException.class

rt.jar : javax/management/openmbean/InvalidOpenTypeException.class

rt.jar : javax/management/openmbean/KeyAlreadyExistsException.class

rt.jar : javax/management/openmbean/OpenDataException.class

rt.jar : javax/management/OperationsException.class

rt.jar : javax/management/ReflectionException.class

rt.jar : javax/management/relation/InvalidRelationIdException.class

rt.jar : javax/management/relation/InvalidRelationServiceException.class

rt.jar : javax/management/relation/InvalidRelationTypeException.class

rt.jar : javax/management/relation/InvalidRoleInfoException.class

rt.jar : javax/management/relation/InvalidRoleValueException.class

rt.jar : javax/management/relation/RelationException.class

rt.jar : javax/management/relation/RelationNotFoundException.class

rt.jar : javax/management/relation/RelationServiceNotRegisteredException.class

rt.jar : javax/management/relation/RelationTypeNotFoundException.class

rt.jar : javax/management/relation/RoleInfoNotFoundException.class

rt.jar : javax/management/relation/RoleNotFoundException.class

rt.jar : javax/management/remote/JMXProviderException.class

rt.jar : javax/management/remote/JMXServerErrorException.class

rt.jar : javax/management/RuntimeErrorException.class

rt.jar : javax/management/RuntimeMBeanException.class

rt.jar : javax/management/RuntimeOperationsException.class

rt.jar : javax/management/ServiceNotFoundException.class

rt.jar : javax/naming/AuthenticationException.class

rt.jar : javax/naming/AuthenticationNotSupportedException.class

rt.jar : javax/naming/CannotProceedException.class

rt.jar : javax/naming/CommunicationException.class

rt.jar : javax/naming/ConfigurationException.class

rt.jar : javax/naming/ContextNotEmptyException.class

rt.jar : javax/naming/directory/AttributeInUseException.class

rt.jar : javax/naming/directory/AttributeModificationException.class

rt.jar : javax/naming/directory/InvalidAttributeIdentifierException.class

rt.jar : javax/naming/directory/InvalidAttributesException.class

rt.jar : javax/naming/directory/InvalidAttributeValueException.class

rt.jar : javax/naming/directory/InvalidSearchControlsException.class

rt.jar : javax/naming/directory/InvalidSearchFilterException.class

rt.jar : javax/naming/directory/NoSuchAttributeException.class

rt.jar : javax/naming/directory/SchemaViolationException.class

rt.jar : javax/naming/event/NamingExceptionEvent.class

rt.jar : javax/naming/InsufficientResourcesException.class

rt.jar : javax/naming/InterruptedNamingException.class

rt.jar : javax/naming/InvalidNameException.class

rt.jar : javax/naming/ldap/LdapReferralException.class

rt.jar : javax/naming/LimitExceededException.class

rt.jar : javax/naming/LinkException.class

rt.jar : javax/naming/LinkLoopException.class

rt.jar : javax/naming/MalformedLinkException.class

rt.jar : javax/naming/NameAlreadyBoundException.class

rt.jar : javax/naming/NameNotFoundException.class

rt.jar : javax/naming/NamingException.class

rt.jar : javax/naming/NamingSecurityException.class

rt.jar : javax/naming/NoInitialContextException.class

rt.jar : javax/naming/NoPermissionException.class

rt.jar : javax/naming/NotContextException.class

rt.jar : javax/naming/OperationNotSupportedException.class

rt.jar : javax/naming/PartialResultException.class

rt.jar : javax/naming/ReferralException.class

rt.jar : javax/naming/ServiceUnavailableException.class

rt.jar : javax/naming/SizeLimitExceededException.class

rt.jar : javax/naming/TimeLimitExceededException.class

rt.jar : javax/print/attribute/UnmodifiableSetException.class

rt.jar : javax/print/AttributeException.class

rt.jar : javax/print/FlavorException.class

rt.jar : javax/print/PrintException.class

rt.jar : javax/print/URIException.class

rt.jar : javax/security/auth/callback/UnsupportedCallbackException.class

rt.jar : javax/security/auth/DestroyFailedException.class

rt.jar : javax/security/auth/login/AccountException.class

rt.jar : javax/security/auth/login/AccountExpiredException.class

rt.jar : javax/security/auth/login/AccountLockedException.class

rt.jar : javax/security/auth/login/AccountNotFoundException.class

rt.jar : javax/security/auth/login/CredentialException.class

rt.jar : javax/security/auth/login/CredentialExpiredException.class

rt.jar : javax/security/auth/login/CredentialNotFoundException.class

rt.jar : javax/security/auth/login/FailedLoginException.class

rt.jar : javax/security/auth/login/LoginException.class

rt.jar : javax/security/auth/RefreshFailedException.class

rt.jar : javax/security/sasl/AuthenticationException.class

rt.jar : javax/security/sasl/SaslException.class

rt.jar : javax/sound/midi/InvalidMidiDataException.class

rt.jar : javax/sound/midi/MidiUnavailableException.class

rt.jar : javax/sound/sampled/LineUnavailableException.class

rt.jar : javax/sound/sampled/UnsupportedAudioFileException.class

rt.jar : javax/sql/rowset/serial/SerialException.class

rt.jar : javax/sql/rowset/spi/SyncFactoryException.class

rt.jar : javax/sql/rowset/spi/SyncProviderException.class

rt.jar : javax/swing/text/BadLocationException.class

rt.jar : javax/swing/text/ChangedCharSetException.class

rt.jar : javax/swing/tree/ExpandVetoException.class

rt.jar : javax/swing/undo/CannotRedoException.class

rt.jar : javax/swing/undo/CannotUndoException.class

rt.jar : javax/swing/UnsupportedLookAndFeelException.class

rt.jar : javax/transaction/InvalidTransactionException.class

rt.jar : javax/transaction/TransactionRequiredException.class

rt.jar : javax/transaction/TransactionRolledbackException.class

rt.jar : javax/transaction/xa/XAException.class

rt.jar : javax/xml/datatype/DatatypeConfigurationException.class

rt.jar : javax/xml/parsers/ParserConfigurationException.class

rt.jar : javax/xml/transform/TransformerConfigurationException.class

rt.jar : javax/xml/transform/TransformerException.class

rt.jar : javax/xml/xpath/XPathException.class

rt.jar : javax/xml/xpath/XPathExpressionException.class

rt.jar : javax/xml/xpath/XPathFactoryConfigurationException.class

rt.jar : javax/xml/xpath/XPathFunctionException.class

rt.jar : org/ietf/jgss/GSSException.class

rt.jar : org/omg/CORBA/ExceptionList.class

rt.jar : org/omg/CORBA/portable/ApplicationException.class

rt.jar : org/omg/CORBA/portable/IndirectionException.class

rt.jar : org/omg/CORBA/portable/RemarshalException.class

rt.jar : org/omg/CORBA/portable/UnknownException.class

rt.jar : org/omg/CORBA/SystemException.class

rt.jar : org/omg/CORBA/UnknownUserException.class

rt.jar : org/omg/CORBA/UnknownUserExceptionHelper.class

rt.jar : org/omg/CORBA/UnknownUserExceptionHolder.class

rt.jar : org/omg/CORBA/UserException.class

rt.jar : org/omg/IOP/ExceptionDetailMessage.class

rt.jar : org/w3c/dom/DOMException.class

rt.jar : org/w3c/dom/events/EventException.class

rt.jar : org/w3c/dom/ls/LSException.class

rt.jar : org/w3c/dom/ranges/RangeException.class

rt.jar : org/xml/sax/SAXException.class

rt.jar : org/xml/sax/SAXNotRecognizedException.class

rt.jar : org/xml/sax/SAXNotSupportedException.class

rt.jar : org/xml/sax/SAXParseException.class

rt.jar : sun/applet/AppletIllegalArgumentException.class

rt.jar : sun/applet/AppletIOException.class

rt.jar : sun/applet/AppletSecurityException.class

rt.jar : sun/applet/Main$ParseException.class

rt.jar : sun/audio/AudioSecurityExceptionAction.class

rt.jar : sun/audio/InvalidAudioFormatException.class

rt.jar : sun/awt/image/ImageFormatException.class

rt.jar : sun/awt/image/PNGImageDecoder$PNGException.class

rt.jar : sun/dc/path/PathException.class

rt.jar : sun/dc/pr/PRException.class

rt.jar : sun/io/ConversionBufferFullException.class

rt.jar : sun/io/MalformedInputException.class

rt.jar : sun/io/UnknownCharacterException.class

rt.jar : sun/java2d/InvalidPipeException.class

rt.jar : sun/jdbc/odbc/JdbcOdbcBatchUpdateException.class

rt.jar : sun/management/counter/perf/InstrumentationException.class

rt.jar : sun/misc/CEFormatException.class

rt.jar : sun/misc/ExtensionInstallationException.class

rt.jar : sun/misc/InvalidJarIndexException.class

rt.jar : sun/misc/ProxyGenerator$ExceptionTableEntry.class

rt.jar : sun/misc/REException.class

rt.jar : sun/net/ConnectionResetException.class

rt.jar : sun/net/ftp/FtpLoginException.class

rt.jar : sun/net/ftp/FtpProtocolException.class

rt.jar : sun/net/smtp/SmtpProtocolException.class

rt.jar : sun/net/TelnetProtocolException.class

rt.jar : sun/net/www/ApplicationLaunchException.class

rt.jar : sun/nio/ch/AlreadyBoundException.class

rt.jar : sun/print/PrintJobAttributeException.class

rt.jar : sun/print/PrintJobFlavorException.class

rt.jar : sun/reflect/annotation/AnnotationTypeMismatchExceptionProxy.class

rt.jar : sun/reflect/annotation/EnumConstantNotPresentExceptionProxy.class

rt.jar : sun/reflect/annotation/ExceptionProxy.class

rt.jar : sun/reflect/annotation/TypeNotPresentExceptionProxy.class

rt.jar : sun/reflect/generics/reflectiveObjects/NotImplementedException.class

rt.jar : sun/reflect/InstantiationExceptionConstructorAccessorImpl.class

rt.jar : sun/rmi/transport/proxy/CGIClientException.class

rt.jar : sun/rmi/transport/proxy/CGIServerException.class

rt.jar : sun/security/jgss/GSSExceptionImpl.class

rt.jar : sun/security/krb5/Asn1Exception.class

rt.jar : sun/security/krb5/internal/KdcErrException.class

rt.jar : sun/security/krb5/internal/KrbApErrException.class

rt.jar : sun/security/krb5/internal/KrbErrException.class

rt.jar : sun/security/krb5/KrbCryptoException.class

rt.jar : sun/security/krb5/KrbException.class

rt.jar : sun/security/krb5/RealmException.class

rt.jar : sun/security/pkcs/EncodingException.class

rt.jar : sun/security/pkcs/ParsingException.class

rt.jar : sun/security/provider/certpath/CertificateRevokedException.class

rt.jar : sun/security/provider/certpath/SunCertPathBuilderException.class

rt.jar : sun/security/provider/PolicyParser$ParsingException.class

rt.jar : sun/security/timestamp/TSResponse$TimestampException.class

rt.jar : sun/security/util/PendingException.class

rt.jar : sun/security/util/PropertyExpander$ExpandException.class

rt.jar : sun/security/validator/ValidatorException.class

rt.jar : sun/security/x509/CertException.class

rt.jar : sun/tools/jar/JarException.class

How to use SQL Server 2008 R2 Import and Export Wizard to import a CSV file into SQL Azure

The SQL Server 2008 R2 Import and Export Wizard will allow you to import a CSV ‘flat’ file directly into SQL Azure. The process is relatively simple, but it’s not obvious. The following steps will help guide you through the process.

The SQL Server Import and Export Wizard is available on the SQL Server 2008 R2 media, so you must obtain your organization’s copy of SQL Server 2008 R2 software.

1. Run the wizard from the Windows Start menu, Start à Programs à SQL Server 2008 R2 à Import and Export Data.

2. Select Flat File Source as the data source, browse for your CSV file, and then select the settings appropriate for your file. For example, the fields in my file are surrounded by double-quotes if they contain commas, so I select double-quotes as my text qualifier. Also, the column names are found in the first row of my file. Click Next.

3. Verify that your data looks as you expected. Click on Advanced on the left.

4. Remember that the wizard is looking at a flat file, so it doesn’t make many assumptions about the data contained therein. It’s up to you to go through each column in this screen and adjust data types and sizes. The following table shows a mapping of data types between the wizard and SQL Server. Click Next after you’ve made your changes.

Data Type	SQL Server (SQLOLEDB; SQLNCLI10)
DT_BOOL	bit
DT_BYTES	binary, varbinary, timestamp
DT_CY	smallmoney, money
DT_DATE
DT_DBDATE	date
DT_DBTIME
DT_DBTIME2	time(p)
DT_DBTIMESTAMP	datetime, smalldatetime
DT_DBTIMESTAMP2	datetime2
DT_DBTIMESTAMPOFFSET	datetimeoffset(p)
DT_DECIMAL
DT_FILETIME
DT_GUID	uniqueidentifier
DT_I1
DT_I2	smallint
DT_I4	int
DT_I8	bigint
DT_NUMERIC	decimal, numeric
DT_R4	real
DT_R8	float
DT_STR	char, varchar
DT_UI1	tinyint
DT_UI2
DT_UI4
DT_UI8
DT_WSTR	nchar, nvarchar, sql_variant, xml
DT_IMAGE	image
DT_NTEXT	ntext
DT_TEXT	text

Table 1 - Data type mappings (source: http://msdn.microsoft.com/en-us/library/ms141036.aspx)

5. Here’s the part that’s not obvious. You must select .Net Framework Data Provider for SqlServer as the destination. Then, enter the following information.

· Data Source – This is the fully qualified DNS name (FQDN) of your SQL Azure server.

· Initial Catalog – This must be an existing database on the SQL Azure server.

· User ID

· Password

6. Click Edit Mappings.

7. Uncheck the Nullable box for your primary key column. Did I mention that a SQL Azure table must have a primary key? Notice that there isn’t a way to specify the primary key in this dialog. We’ll have to add that to the SQL statement manually. Click the Edit SQL button.

8. Add the “Primary Key” option to the declaration of your primary key column, and click OK.

Note: If you’re using a clustered primary key, please see SQL Server Books Online for the syntax.

9. Review the data type mappings. Note that I receive warnings about the default DT_STR types, so I ignore them.

10. Keep the default setting, Run immediately, click Next, and then click Finish on the next screen.

11. Finally, review the status of the import, and enjoy using your data in SQL Azure.

RS1.EXE works with SSRS 2008 R2 with SP1

Thanks to my anonymous friend, Baptiste Lefrançois, it appears that my RS1.exe build still works with SQL Server Reporting Services 2008 R2, but you need Service Pack 1. Here's my original post:

SQL Server 2008 Reporting Services RS.EXE Supporting Forms Authentication

And here's the description, in my gracious friend's own words:

"Hello Joe,

Thanks for your help, I've understood my mistake but finally my problem was an official bug of SQL Server Report Service. I just want to tell you how I resolved it for next person who will be in the same situation. My problem was the LogonUser didn't return any cookie, and my authCookie was always null, never affected :( The specific error message was : "Authorization ticket not received by LogonUser". But I've already followed all recommended procedures on the msdn but never resolve my problem. My authentication form on ReportServer page worked perfectly with any web navigator, but with a console application impossible, allways the same [... :)] error =/ I've tried to authenticate thanks of navigator on ReportsManager page and... surprise I got the same error : "Authorization ticket not received by LogonUser". After lot's of search and googling , I've read an article explaining this bug. It was in fact an official bug and Microsoft published a fix whish was after included in the SQL SERVER 2008R2 SP1. I had only the SQL SERVER 2008R2 with no update. After install the SP1, I tested your "old" RS Utility for form authentication, rs1.exe. And It works perfectly now. Thank's so much ! Maybe my bug and the solution I've found will be helpfull for the future ;)

Thanks a lot, So Nice! =)

Baptiste"

XMA/ECMA call-based export does not support multi-valued attribute-level deltas

Here's a seemingly undocumented feature of the XMA/ECMA. I've got an XMA that's doing call-based exports, and I've noticed that it doesn't contain atomic add & remove operations at the item level in a multi-valued attribute list. Instead, it's giving me the entire list of items in the object's current state.

This is interesting, because when I look at the pending export in the sync engine, I see the atomic operations.

When I examine the arguments passed into the ExportEntry API call, I see a Replace at the top level, but nothing on the multi-valued attribute (member in this case).

[ExportEntry]

modificationType:   Replace      
changedAttributes:  member
csentry:            [Microsoft.MetadirectoryServices.Impl.CSEntryMAImpl] CS Role CN=ROLE-CRM-Test1
DN:                 CN=ROLE-CRM-Test1
ObjectClass:        Microsoft.MetadirectoryServices.Impl.GenericValueCollection
ObjectType:         Role         
RDN:                CN=ROLE-CRM-Test1
displayName         [String]            ROLE-CRM-Test1
member              [Reference]         CN=007528
                                     CN=dev.userA
                                     CN=dev.userB
                                     CN=dev.userC
                                     CN=dev.userD
                                     CN=dev.userE
                                     CN=dev.userF

(Wouldn't it be nice if you could just serialize the CSEntry object?)

So, I looked around on the forums, and sure enough, Markus confirms my observation:

"If members is in the list of changed attributes, the member attribute of the CSEntry contains the most recent value for this attribute.

"If you need to determine the individual change for each member, you need to calculate this. The ECMA doesn’t provide multi-valued attribute level changes."

Rebecca Croft also informs me that not even the file-based export supports item-level deltas on multi-valued attributes.

I'd love to be proven wrong about this...

Powershell: get process ID by window name/title

Powershell is cool.

get-process | where {$_.mainwindowtitle -match "pattern"} | format-table id, name, mainwindowtitle -autosize

SSRS data processing extension, Windows integrated security, and impersonation

I've been playing around with Craig Martin's SSRS Data Processing Extension for FIM. (Great stuff; thanks for posting it, Craig!) I had to do some troubleshooting with Windows integrated security and Windows credentials stored securely on the server.

I noticed that the IDbConnection.Open method was being called as the impersonated Windows user:

2010-11-11 14:56:37,932 --4-- DEBUG [FimDataProcessingExtension.FimConnection]    

   [Microsoft.ReportingServices.DataProcessing.IDbConnection.Open] Current user info:
   Name               : TEST\joe.zamora
   IsAuthenticated    : True
   AuthenticationType : Kerberos
   ImpersonationLevel : Impersonation

However, the IDbCommand.ExecuteReader method was not run under the context of the Windows user:

2010-11-11 14:56:37,934 --4-- DEBUG [FimDataProcessingExtension.FimConnection]    

   [GetData] Current user info:
   Name               : TEST\svc_ssrs
   IsAuthenticated    : True
   AuthenticationType : Kerberos
   ImpersonationLevel : None

Well, turns out that this is by design. Here's the official word from Microsoft:

Impersonation and Custom Data Processing Extensions

If your custom data processing extension connects to data sources using impersonation, you must use the Open method on either the IDbConnection orIDbConnectionExtension interfaces to make the request. Alternately, you can store the user identity object (System.Security.Principal.WindowsIdentity) and then reuse it in the other data processing extension APIs.

In previous releases of Reporting Services, all custom data processing extensions were called under user impersonation. In this release, only the Open method will be called while impersonating the user. If you have an existing data processing extension that requires integrated security, you must modify your code to use the Openmethod or store the user identity object.

Thus, you should save the current Windows identity to a local variable in the IDbConnection.Open method:

if (this.integratedSecurity)
{
    this.windowsIdentity = WindowsIdentity.GetCurrent();
}

And then you can use it later in the other API calls:

private WindowsImpersonationContext impersonationContext;
internal void MaybeImpersonate()
{
    if (this.integratedSecurity)
    {
        impersonationContext = this.windowsIdentity.Impersonate();
    }
}

That'll teach me for not reading the documenation. ;)

Data source name not found and no default driver specified

Ahhh, another chance to give back to the community. It's bittersweet. It feels good to contribute, but you really go through the fire to figure out something that no one else has.

This one is an error message that I was getting from SQL Server Integration Services (SSIS). I recently inherited a package (isn't that a nice excuse :) and I switched the connection string from Windows integrated to SQL auth. Pretty standard operation, wouldn't you say? Well, I've been around the block enough to not be totally shocked when I got a few error messages:

An error occured on the SSIS Listener Microsoft.SqlServer.Dts.Runtime.Package/Connection manager "JOESPLACE\MSSQLSERVER.TEST" : SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available.  Source: "Microsoft OLE DB Provider for ODBC Drivers"  Hresult: 0x80004005  Description: "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".

An error occured on the SSIS Listener Microsoft.SqlServer.Dts.Runtime.TaskHost/Execute SQL Task : Failed to acquire connection "JOESPLACE\MSSQLSERVER.TEMPEST". Connection may not be configured correctly or you may not have the right permissions on this connection.

An error occured while processing the file C:\temp.txt. Details: There was an error executing the SSIS package C:\test.dtsx.  Please check the event log for more information.

Okay, so there's an error in the connection string. Let the troubleshooting begin. The thing about this little guy is that he just wouldn't go away. I tried a bunch of different changes to the connection string; nothing worked.

This package is a little different because we're using a variable to specify the table. I suspected that this had something to do with it, so I tried a bunch of different things. It must have been after I switched to an existing table and then back to the table variable that it started working. I didn't know it at the time, because I was being a little sloppy with my trial-and-error.

Anyway, after I got it to work, I compared the dtsx files before and after. Then, starting with the original version, I made one change at a time until it worked. Turns out that the fix was totally a one-liner. Aaarrggghhh! ...and here it is:

<property id="5852" name="OpenRowset" dataType="System.String" state="default" isArray="false" description="Specifies the name of the database object used to open a rowset." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">[dbo].[TEMPEST]</property>

In the original file, the entry was blank; that's it.

A couple more bizarre things about this problem:

• The package would run in Visual Studio, but not after being published.
• I deleted the [dbo].[TEMPEST] table and it still worked.

I meant to fix this a while back, but just now got around to it. I think the problem was actually that I was missing the driver in the connection string, just like the error message suggests. Evidently, you can't just use any old .NET connection string; it has to have the driver in it. Ugh.