DTS Question - copy table from SQL server to non-SQL server

I'm breaking into SQL 2000, and have completed a DTS package that imports and massages a file and creates a table with about 200M records.

Now I want to add a process that will export the table to a directory on a Windows 2000 server, in a format such as Access, dBase, or someting else, to make the table available for users who do not have assces to SQL 2000.

I'm having a problem deciding which DTS 'Task' should be used. I've tried several, but haven't stumbled on the correct one, or if I have, haven't realized it because of error messages.

Any tips to get me started will be appreciated.

Thanks,

RandyFirst, add a connection object that specifies your preferred destination (Access, text, Excel, whatever). Then, holding down your CTRL key, select first the source connection (your server), then click on the destination connection (the one you just added). Next click on the data pump task (aka Transform Data Task; it's the black arrow pointing to the yellow...er...thingy).

Then define your source query (or table), your destination and any mapping changes you want to make.

Best of luck,

hmscott

...or, contact Brett Kaiser about how to do a BCP... ;-)sqlsql

DTS Help

You can add SQL Task with respective connection and
validate your data. When successfuly completed copy your
objects.
Joanna

>--Original Message--
>I have a package that contains an Copy Objects Task. I
want to have a step
>to check a value in another table before executing the
copy task. Not sure
>how to accomplish this. Any help would be greatly
appreciated. Thanks.
>.
>Ok. How would I make not execute the next step if the validation failed?
"Joanna" wrote:

> You can add SQL Task with respective connection and
> validate your data. When successfuly completed copy your
> objects.
> Joanna
>
> want to have a step
> copy task. Not sure
> appreciated. Thanks.
>