Posted by John Bell on 01/01/06 12:36

Hi

DTS can export into to multiple formats although a text file will probably
be the best for this instance. There are other tools such as BCP, but within
a DTS package you can produce workflow, error handling and conditional
handling within the same package. The packages themselves can be developed
and tested on one server and then transferred to their destination.

http://www.sqldts.com/default.aspx is a great site for resources and the
examples it has will save you time when developing your own solution.

John

"_(d)IEGO" <rey_guerrero@hotmail.com> wrote in message
news:1136093588.495122.66520@g44g2000cwa.googlegroups.com...
> John,
>
> Thanks for your patience. But I still have some questions :)
>
> What data format do you suggest I should export the data to? And is DTS
> the only way to achieve what I need?
>
> Rey
>

[Back to original message]