I would think you could design a DTS package and use ActiveX script so that you could control the data being exported, i.e. the format, default values, null value handling, etc. Just define necessary source and destination SQL Server (if both are SQL Server) and either use SQL query as a source or an SQL table or view then define appropriate destination table and use the Transformation tab for data transformation. There is always column-to-column copy or use ActiveX as I said earlier and control how the data is transformed from Source to Destination. I use this for file size around 140 MB and it works fine, though could run for 2 hours if run directly on server via Terminal Service connection or take up to 4 hours if ran using Enterprise Manager on my local machine using network connection. Note that if the file size is smaller than the one I mentioned, it would take much less time

Good site for help regarding DTS is Wrox Press (asptoday.com), PinnaclePublishing.com or there is always Microsoft

Hope this helps

I am looking for a way to export a few million records from a MS SQL Server
DB and subsequently import them into a similar table in another DB. This
should all be done in code.
Is there a specific strategy for this in order to happen as fast as
possible?
I can use either ADO or SQLDMO.
Thanks
Yannis