In SQLServer2005 they've done away with DTS ( which annoys me because it was the primary task i used Enterprise Manager for in the SQL2K database) and replaced it with SSIS - a "far more flexible and programmable" method of data import and export. It can loop through fields, have quite a lot of logic in it, and might do what you need.
It's terrible for doing what I do most - copying databases from one server to another but it's brilliant for exporting data to other formats, such as CSVfiles, Access databases, Xcel spreadsheets, even simple text files. There are examples in the Books on Line and in a great many web sites - i know i've found them all while i'm looking for something to show me how to export and import tables between servers. So in short, to do what you want SSIS may be what you want. Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237158 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
