Importing Data into SQL 2005

I tried to import a table from SQL 2000 server to SQL 2005 server. Between
SQL 2000 servers I can choose to drop the current table if it exists at
destination. However in SQL Server Management Studio there is no option to
drop the existing table. Do I miss something here? How do you guys import
in this case? Thanks.It gets worse. The "object transfer" component doesn't take indexes,
identity properties, constraints or pretty much anything except the raw
table structure. DTS was a good data migration utility and a decent ETL
platform. SSIS is a great ETL tool and a poor data migration tool.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"ME" <ME@.mail.com> wrote in message
news:ONJ1$SwGHHA.3540@.TK2MSFTNGP02.phx.gbl...
>I tried to import a table from SQL 2000 server to SQL 2005 server. Between
>SQL 2000 servers I can choose to drop the current table if it exists at
>destination. However in SQL Server Management Studio there is no option to
>drop the existing table. Do I miss something here? How do you guys import
>in this case? Thanks.
>|||You are correct.
now it comes to fun part: to create SSIS package I must purchase license for
Visual Studio?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23r$SwowGHHA.1264@.TK2MSFTNGP03.phx.gbl...
> It gets worse. The "object transfer" component doesn't take indexes,
> identity properties, constraints or pretty much anything except the raw
> table structure. DTS was a good data migration utility and a decent ETL
> platform. SSIS is a great ETL tool and a poor data migration tool.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "ME" <ME@.mail.com> wrote in message
> news:ONJ1$SwGHHA.3540@.TK2MSFTNGP02.phx.gbl...
>|||SQL Server 2005 Developer edition is $50 and includes the BI workbench.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"ME" <ME@.mail.com> wrote in message
news:u0yaw2wGHHA.4904@.TK2MSFTNGP04.phx.gbl...
> You are correct.
> now it comes to fun part: to create SSIS package I must purchase license
> for Visual Studio?
>
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:%23r$SwowGHHA.1264@.TK2MSFTNGP03.phx.gbl...
>|||> now it comes to fun part: to create SSIS package I must purchase license f
or Visual Studio?
No, the Visual Studio IDE is shipped with SQL Server. It is called Business
Intelligence Development
Studio.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ME" <ME@.mail.com> wrote in message news:u0yaw2wGHHA.4904@.TK2MSFTNGP04.phx.gbl...reen">
> You are correct.
> now it comes to fun part: to create SSIS package I must purchase license f
or Visual Studio?
>
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:%23r$SwowGHHA.1264@.TK2MSFTNGP03.phx.gbl...
>