Programmatically exporting and importing data SQL Server 2000 and

What should I use to import and export data from, to, and accross SQL Server
2000 and 2005. Need to export to a file and then import from a file.
Currently my program uses SQLDMO, which is very easy to use, powerfull, and
works great with SQL Server 2000. But it is not supported by SQL Server
2005, also, 2005's SMO doesn't have such functionality. SQL Server 2005's
Integration Services (SSIS) is availbale for this, but don't know if it
supported in 2000. There is also a 'bcp' command, but this isn't even part
of SQL Server 2005 Enterprise 64-Bit edition, so I don't want to make clients
install extra components for this. I beleive it is standard on Server 2000
though. I tried to play around with DTS, or Data Transformation
Import/Export Wizard, is this the only thing I can use that will work the
same way for SQL Server 2000 and 2005.
NoFear wrote:
> What should I use to import and export data from, to, and accross SQL
> Server 2000 and 2005. Need to export to a file and then import from
> a file. Currently my program uses SQLDMO, which is very easy to use,
> powerfull, and works great with SQL Server 2000. But it is not
> supported by SQL Server 2005, also, 2005's SMO doesn't have such
> functionality. SQL Server 2005's Integration Services (SSIS) is
> availbale for this, but don't know if it supported in 2000. There is
> also a 'bcp' command, but this isn't even part of SQL Server 2005
> Enterprise 64-Bit edition, so I don't want to make clients install
> extra components for this. I beleive it is standard on Server 2000
> though. I tried to play around with DTS, or Data Transformation
> Import/Export Wizard, is this the only thing I can use that will work
> the same way for SQL Server 2000 and 2005.
SQL-DMO is supported on SQL 2005.
David Gugick - SQL Server MVP
Quest Software