Home Forums Programming SMO/RMO/DMO VBS Script : Using DMO to export data from SQLServer to csv file RE: VBS Script : Using DMO to export data from SQLServer to csv file

  • Just thought of something.  Why don't you set up views for each table, use the views to convert your datetime data into char data and use the ExportData method on the view instead of the table.

    Again, a lot of work depending on the amount of tables in your database.

    Anyone got any better options?


    When in doubt - test, test, test!

    Wayne