I would guess you are referring to using the Import Export
Wizard. Right click on a database in SSMS and select Tasks,
then select Import Data. That will bring up the Import
Export Wizard.
You could also use SSIS in 2005 like you would use DTS in
2000. To open SSIS, go to your SQL Server 2005 folder in
your programs group and start up SQL Server Business
Intelligence Development Studio. You can create a new
Integration Services Project from there.
-Sue
On Fri, 5 May 2006 08:22:15 -0700, "R Weeden"
[quoted text, click to view] <rweeden@wesd.k12.az.us> wrote:
>In SQL2000 there is a tool to import CSV files. Where is the import tool in
>SQL2005?
>
>Bob W
>
THAT is the issue. The Import Export issue does not appear on the menu. I
also tried the method you suggested in the second paragraph and the option
is not there to create a new Integration Service Project.
Is there something that is not loading with SQL Server 2005 Express that
should be there to do this?
Bob Weeden
[quoted text, click to view] "Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:m0fn52po3vidu1cka8r199qbp5vdleo7a5@4ax.com...
>I would guess you are referring to using the Import Export
> Wizard. Right click on a database in SSMS and select Tasks,
> then select Import Data. That will bring up the Import
> Export Wizard.
> You could also use SSIS in 2005 like you would use DTS in
> 2000. To open SSIS, go to your SQL Server 2005 folder in
> your programs group and start up SQL Server Business
> Intelligence Development Studio. You can create a new
> Integration Services Project from there.
>
> -Sue
>
> On Fri, 5 May 2006 08:22:15 -0700, "R Weeden"
> <rweeden@wesd.k12.az.us> wrote:
>
>>In SQL2000 there is a tool to import CSV files. Where is the import tool
>>in
>>SQL2005?
>>
>>Bob W
>>
>
SQL Express doesn't support SSIS....that's why you want to
make sure to post versions with your question : )
-Sue
On Fri, 5 May 2006 15:16:12 -0700, "R Weeden"
[quoted text, click to view] <rweeden@wesd.k12.az.us> wrote:
>THAT is the issue. The Import Export issue does not appear on the menu. I
>also tried the method you suggested in the second paragraph and the option
>is not there to create a new Integration Service Project.
>
>Is there something that is not loading with SQL Server 2005 Express that
>should be there to do this?
>
>Bob Weeden
>
>
>"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
>news:m0fn52po3vidu1cka8r199qbp5vdleo7a5@4ax.com...
>>I would guess you are referring to using the Import Export
>> Wizard. Right click on a database in SSMS and select Tasks,
>> then select Import Data. That will bring up the Import
>> Export Wizard.
>> You could also use SSIS in 2005 like you would use DTS in
>> 2000. To open SSIS, go to your SQL Server 2005 folder in
>> your programs group and start up SQL Server Business
>> Intelligence Development Studio. You can create a new
>> Integration Services Project from there.
>>
>> -Sue
>>
>> On Fri, 5 May 2006 08:22:15 -0700, "R Weeden"
>> <rweeden@wesd.k12.az.us> wrote:
>>
>>>In SQL2000 there is a tool to import CSV files. Where is the import tool
>>>in
>>>SQL2005?
>>>
>>>Bob W
>>>
>>
>
Don't see what you're looking for? Try a search.
