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

[387 byte] By [chicolax33] at [2007-12-19]

«« Remoting with Reflection problems
»» Extending Team Build.

# 1

did you stop and restart Integration Services? is it running under a domain administrator account?

PaulFuhrmann at 2007-9-9 >

top of Msdn Tech,SQL Server,SQL Server Integration Services...

# 2

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.

chicolax33 at 2007-9-9 >

# 3

I'm having the exact same problem. I'm about to install CTP SP1 to see if it corrects the problem.

RonnieMiller at 2007-9-9 >

# 4

I uninstalled and re-installed the complete application.... twice.. And now it seems to work. Nothing to do with SP1.

chicolax33 at 2007-9-9 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Question about 'Flat file source not option for importing data', No.325852,Posted by chicolax33

Flat file source not option for importing data

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Site Classified