I created a DTS Package with a custom task that exports data from a SQL Server to an excel file using VB.NET. I loop throug about 200 records to create a file name for each excel file. So I dynamically chage the file name for each package and dynamically change the SQL Query string. Which means I run about 200 packages at about the same time. These excel files do not have huge amounts of data in them.
Sometimes it will complete all 200 files. Other times it will fail and give me the following error:
An unhandled exception of type 'System.NullReferenceException' occurred in mscorlib.dll
Additional information: Object reference not set to an instance of an object.
Does this have something to do with the connection time-out? I am quite new to DTS. Any help will be appreciated.