|
Home > Archive > MS SQL Server DTS > July 2005 > Table to CSV fails
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Table to CSV fails
|
|
|
| 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
| |
| Allan Mitchell 2005-07-23, 3:23 am |
| 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@gmail.com> wrote in message
news:1122078596.019738.271490@g47g2000cwa.googlegroups.com...
> 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
>
| |
| Panch 2005-07-23, 11:23 am |
| 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.
| |
| Allan Mitchell 2005-07-23, 8:38 pm |
| Ahhh, then this box has just had SP3/3a applied.
http://support.microsoft.com/defaul...kb;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@gmail.com> wrote in message
news:1122137754.889787.182580@g49g2000cwa.googlegroups.com...
> 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.
>
|
|
|
|
|