Uh, hows about good 'ol BCP?
Notice, you'll have to change some parameters for your environment

Don't flame me if this don't work.


IF object_id('sp_bcp_scripts') >99999
drop procedure sp_bcp_scripts
go
create procedure sp_bcp_scripts (@dbname varchar(50))AS
BEGIN
/* The Script below creates a Stored Procedure that
returns a Macro SQL Statement which when executed
will inturn return BCP Out Statements of all the
tables in a given database passed as a parameter
Author : Seshu Kanuri, DBA, EB2B Commerce, Inc.
*/

declare @sqlstr varchar(4000)
select @sqlstr="select 'bcp '+" +"'"+ @dbname +"..'"+ '+name+'+ "' OUT prod_Db/DataIn/'"+'+name+'+ "'.dat -c -e prod_Db/DataOut/' " + '+name+'+" '.err -S Prod1 -U sa -P oasis -t ¢' from sysobjects where type='U' order by name "
select @sqlstr
/* To run the script - Execute sp_bcp_scripts Northwind */
end
go


-----Original Message-----
From: Long, Charles (euler:eti) [mailto:Charles.[Email Address Removed]
Sent: Tuesday, May 14, 2002 2:46 AM
To: 'Morgan.[Email Address Removed] [Email Address Removed] RE: sql 2000 to 7

I don't understand why a DTS package won't work. Where are you riunning it?

> -----Original Message-----
> From: Morgan.[Email Address Removed] [SMTP:Morgan.[Email Address Removed] Sent: Tuesday, May 14, 2002 10:42 AM
> To: [Email Address Removed] Subject: sql 2000 to 7
>
> Hi
>
> I have a sql 2000 database which i need to get onto a sql 7 server. I
> can't
> create a straight dts package as that won't work, is the only real option
> available is to export the data to an access db and then import from that
> on the sql 7 server.
>
> any help appreciated
>
> thanks
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed] unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page