Hi,


We just migrated from SQL 2000 to 2005. We moved over the dts packages but
they don't seem to work anymore. Do I need to do some editing to them to make
them work but keep them as dts packages? What they should be doing is
selecting data from a table then putting that data into an excel file. They
seem to pull the data with the select statement fine but fail to insert data
into the excel file. Any ideas why? Do I need to edit them since SQL 2005
works differently? Any help is greatly appreciated.

Thanks.