Flat file source not option for importing data

I was getting the product error associated with the full version of SSIS not installed so I ran the installation again and selected the Integration Services check box.

Now when attempting to import data into a database, the drop down list doesn't have a flat file option.

How do I import data from a txt, csv file?

Thanks

PatrickCrofoot@.hotmail.com

did you stop and restart Integration Services? is it running under a domain administrator account?|||I have. And no..

Simply using SQL Server Management Studio and right clicking my db then choosing import data under tasks. There is no Flat File datasource.

So the other route was to attempt the tutorial via integration services. That's when I get the more descriptive error that the FLATFILE option is not installed correctly.

I've completely un-installed and re-installed SQL Server 2005 and all associated tools. Same problem.
|||I'm having the exact same problem. I'm about to install CTP SP1 to see if it corrects the problem.|||I uninstalled and re-installed the complete application.... twice.. And now it seems to work. Nothing to do with SP1.

Flat file source not option for importing data

I was getting the product error associated with the full version of SSIS not installed so I ran the installation again and selected the Integration Services check box.

Now when attempting to import data into a database, the drop down list doesn't have a flat file option.

How do I import data from a txt, csv file?

Thanks

PatrickCrofoot@.hotmail.com

did you stop and restart Integration Services? is it running under a domain administrator account?|||I have. And no..

Simply using SQL Server Management Studio and right clicking my db then choosing import data under tasks. There is no Flat File datasource.

So the other route was to attempt the tutorial via integration services. That's when I get the more descriptive error that the FLATFILE option is not installed correctly.

I've completely un-installed and re-installed SQL Server 2005 and all associated tools. Same problem.
|||I'm having the exact same problem. I'm about to install CTP SP1 to see if it corrects the problem.|||I uninstalled and re-installed the complete application.... twice.. And now it seems to work. Nothing to do with SP1.

First Time Installation of SQL Server 2005 Developer Edition

Just placed the SQL Server 2005 - Developer Edition into my Drive...

I get prompted with the following options..



This DVD contains 32-bit (x86) and 64-bit versions of this edition of SQL Server 2005. Click the link that matches your environment to begin



x86-based operating systems

x64-based operating systems

Itanuim-based operating syystems



I'm new to SQL Server... I just need to start learning how to use it... because it is being used at work... Don't need the all the features installed, just the normal table and query for the moment...



I will be installing it on my PC... i



Microsoft Windows XP - Home Edition - Version 2 - Service Pack 2



My local Hard Drive remaining capacity is 12.6GB

External Hard Drive remaining capacity is 11.0GB



Tried looking everywhere for the answer... lol (even looked at YouTube for a simple installation video...





Thanks for your helpWindowx XP Home Edition is a 32 bit operating system. You want the X86 code for use on XP Home Edition.

-PatP|||I'm new to SQL Server... I just need to start learning how to use it... because it is being used at work... Don't need the all the features installed, just the normal table and query for the moment...

As I only need to install the basic feature...

which one should i click?

SQL Server Database Services
Create a SQL Server fallover cluster
Analysus Services
Create an Analysis Server fallover cluster
Notification Services
Integration Services
Workstation components, Books Online development tools

Please help...|||On the Service Account section...

What should I click / Enter?

Username
Password
Domain

Under the... "Start Services at the end of setup" section, what should I tick?

SQL Server (tick already placed)
SQL Server Agent
SQL Brower

http://img.photobucket.com/albums/v675/akhlaq768/ServiceAccount.jpg

Many thanks

First Installation--doesn't see any tab at all

I am a newbie learning SRS 2000 by reading books, after I finish the
installation of SRS 2000 and open the it thru IE, it just shows the home
page without any tab on it. Any reason? I even point SRS to get data from
AdventureWorks 2000 but still the same situation.
Thank you for your help.Make sure u have set the proper credentials for the folder in IIS to view the
tab.
"Joe" wrote:
> I am a newbie learning SRS 2000 by reading books, after I finish the
> installation of SRS 2000 and open the it thru IE, it just shows the home
> page without any tab on it. Any reason? I even point SRS to get data from
> AdventureWorks 2000 but still the same situation.
> Thank you for your help.
>
>|||I actually create a user account under "My Computer" and then right click
and select "Manage" and then "Local Users and Group"
Is it what you were referring to?
That's the book I am reading on how to set up SRS 2000.
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=GB8Q40yBjn&isbn=0735621063&itm=1
Thanks.
"Suresh" <Suresh@.discussions.microsoft.com> wrote in message
news:5B1677B5-FACE-4D56-A73F-3A7A56FDDA0D@.microsoft.com...
> Make sure u have set the proper credentials for the folder in IIS to view
> the
> tab.
> "Joe" wrote:
>> I am a newbie learning SRS 2000 by reading books, after I finish the
>> installation of SRS 2000 and open the it thru IE, it just shows the home
>> page without any tab on it. Any reason? I even point SRS to get data from
>> AdventureWorks 2000 but still the same situation.
>> Thank you for your help.
>>