?
Solved

SQL Server 2000 - DTS Designer Crashes Trying to Define Columns

Posted on 2005-03-31
3
Medium Priority
?
328 Views
Last Modified: 2012-08-13
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!
0
Comment
Question by:Davehudsn
  • 2
3 Comments
 
LVL 34

Accepted Solution

by:
arbert earned 1500 total points
ID: 13678468
Are you running designer on the server or your client?  Do you have SP3A installed on the server AND the client?  Clients tools that haven't been patched are really buggy with DTS....

I would also make sure you have the latest MDAC installed.

Brett
0
 

Author Comment

by:Davehudsn
ID: 13735867
FOR MODERATOR -- I NO LONGER SEE AN OPTION TO CLOSE OUT / CANCEL THIS QUESTION......  PLEASE  CLOSE THIS QUESTION AS UNANSWERED.
0
 

Author Comment

by:Davehudsn
ID: 13919085
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.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Suggested Courses

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question