?
Solved

SQL Server 2000 - DTS Designer Crashes Trying to Define Columns

Posted on 2005-03-31
3
Medium Priority
?
321 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

764 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