Getting this Error trying to Import a .CSV File into SQL Server?

I'm trying to import a .CSV file into SQL Server 2005. For some reason it won't work. Please see the attached screenshot of the error message.

Thanks,

It looks like SSIS (SQL Server Integration Services) has not been installed.

I'll ask our Network Admin. about this.

Bruce,

I tried to install components from the SQL Server 2005 master disk and it said that I basically had no more components to install, meaning I've installed everything there is to install that came with SS 2005. IIS was not installed so I installed that thru the "Add Programs" option from the Control Panel but that still didn't fix my problem.

Did you do a Custom install?

No, but I just tried and it said that there was nothing else new to install.

Here is another screenshot of the problem I'm having.

Did you try completely uninstalling it and reinstalling it?

What did your Admin have to say?

No, I didn't try that. Maybe that might have something to do with it.

Ok, well since you have CD's What version do you have. You know MS is infamous for having 10 or more different versions when one would do just fine... Since it is complaining about your product level...

Here is the information from the "About" menu item.

Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

Mine are:

Microsoft SQL Server Management Studio Express 9.00.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.832
Operating System 5.1.2600

You seem to be out of date with a few things...

please don't post screen shots in .doc format! We don't all have msword installed. (and i KNOW wordpad opens them but it's failing on the graphics filter)

These links should help you solve the problem

http://blogs.msdn.com/michen/archive...ufficient.aspx
http://msdn2.microsoft.com/en-us/library/aa337371.aspx

Thanks Bruce, I'll pass this information on to our Network Administrator.