SQL Server 2000 - DTS Designer Crashes Trying to Define Columns
Posted on 2005-03-31
I am having a problem creating a DTS package in SQL Server 2000
I have a SQL DB as a Source using a Query
My Destination is a pipe delimited text file.
I have tried this 2 ways:
1) Totally empty desitnation file and doing "populate from source"
2) With a text file that has all the column heads in it as the first row.
When I go to "Destination" it pops up the box and properly shows all the columns in the file.... or if I do "populate from source" it gives me the grid with all the columns.
However, when I click on "Execute" it just closes the box and none of the columns show up under the Destination box where all the columns should listed.
If I click "define columns" again it causes DTS Designer and EM to completely crash and close out!
Is there some kind of limit on the number of columns that DTS can handle???
I can not figure out how to get around this and its driving me crazy!