art I of this two-part series exploring DTS tasks illustrated how to chain different types of tasks together to collect the information you need to process data contained in a
I installed MSDE SP3 as per MS’s directions. However, running Enterprise Manager and trying to register the SQL Server instance into a group (this is on the same box that
‘ Import the data contained in a CSV file into a new DataTable. By default the ‘ values are Tab delimited, but you can use the second overload version to
‘ Create a case-insensitive sorted list that combines the keys from two ‘ hashtables’ Example:’ Dim slist As SortedList = SortedListFromHashtables(hashTable1, hashTable2)Function SortedListFromHashtables(ByVal ht1 As Hashtable, _ ByVal ht2 As
‘ Finding all files with a given filespec into an ArrayList. Optionally scan ‘ also subdirectories of the input dir” Example:’ Dim files As New ArrayList’ FindFiles(files, “D:Articles”, “*.doc”, True)’
‘ Save the input DataTable to a CSV file. By default the values are Tab ‘ delimited, but you can use the second overload version to use any other ‘
‘ Load an assembly identified by the path or the partial name’ Note: requires Imports System.Reflection’ ‘ Examples:’ 1) Dim asm As [Assembly] = LoadAssembly(“System.Web”)’ 2) Dim asm As [Assembly]