hi,

I'm trying to make a text file with the help of dts. First i have an excel file and i import it's data into the DB. I'm using an excel connection, a DB connection and for the destination text, a text(destination) connection. I' m using a query to take the data from the db with the help of Transform Data Task. When i have to define the destination columns i can't find any of them. If i press the Define Columns button then the Sql Server Enterprise Manager shows the below error:

"Microsoft Management Console has encountered a problem and needs to close. We are sorry for the inconvenience."

Any suggestions. It seems very strange.

Thank you.