Link to home
Start Free TrialLog in
Avatar of Davehudsn
Davehudsn

asked on

SQL Server 2000 - DTS Designer Crashes Trying to Define Columns

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!
ASKER CERTIFIED SOLUTION
Avatar of arbert
arbert

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Davehudsn
Davehudsn

ASKER

FOR MODERATOR -- I NO LONGER SEE AN OPTION TO CLOSE OUT / CANCEL THIS QUESTION......  PLEASE  CLOSE THIS QUESTION AS UNANSWERED.
Hey Arbert -  Sorry it took me a while to close this one out.  Took me a while to get a resolution back from the client.

And you were right....... they did not have the latest service pack.  Once installed, it worked fine.