Hi
I have a table which has about 60 fields(columns).
When I create a DTS, in the destination tab after pressing Execute
button, nothing happens.
If I select only 25 fields It works and If I select them all its not
working as I said earlier notthing happends after pressing executer
button.
I need to export to csv file....I have no idea is there any other
ways.. need help

Thanks

On the face of it there sounds nothing wrong. I have certainly done this in
the past with no problems.

When you say "Does Nothing" what do you mean?

Does it not export?
Does it error?
Does it not run?



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Panch" <apanchanathan (AT) gmail (DOT) com> wrote

In the Destination tab

1. Clicked on the 'Define Column' button
2. In the Define Column Window I clicked on 'Populate from Source'
Button
3. As a result Nothing comes-up. No columns populated
4. If I do the Step 3 again, Enterprise Manger Colses.

Ahhh, then this box has just had SP3/3a applied.

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

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Panch" <apanchanathan (AT) gmail (DOT) com> wrote