Hi

On my task I enter in the SQL query as the source and if I do preview, the correct data is shown. For my destination I have a .txt file, but when I try to 'Populate from Source' and 'Execute' Nothing happens. The column names in the Destination Box remain blank.. If I try to click on the 'Define Columns' button again, I get an application error and DTS crashes out.. It should return 24 fields and < 400 chars.

Has anyone seen this before? Its driving me crazy, its part of a project that has to be complete by Friday and the rest of the DTS package is running normally.

Thanks in advance.

Hi,

I ran into exactly the same problem today as well. It happens on two different SQL Servers. I partly resolved the problem by reducing the number of destination fields by altering the underlying datasource (view). This isn't what I want though!

I tried to look for patches / solutions, but I haven't found anything yet.

regards,

Guido

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Try this KB for size-

http://support.microsoft.com/default...b;en-us;814113

--
Darren Green
http://www.sqldts.com
"Guido" <g.hollander (AT) brunel (DOT) nl> wrote

of destination fields by altering the underlying datasource (view). This
isn't what I want though!