I have created a DTS package that relies on a Text Input file as the source. The output is a SQL Server database/dataset.
The text input file is referenced via a file DSN. In the file DSN I have outlined the directory, format and that it’s Fixed Length. I have also defined all the fields, sizes and type.
Now in the DTS Connection properties task, Connection1 I point to the file DSN. Then I create a second DTS Connection, Connection2, properties task which references the output SQL Server database/dataset. I link the two Connection properties with a data transformation pipeline.
Now here is the problem. If I right-click on the data transformation pipeline then select properties then select transformations I get this SQL Error:
HResult of 0X80040e09 (-2147217911) returned. Unexpected error occurred. An error result was returned without an error message.
Why am I getting this problem ?