or if you have another machine with the enterprise version of the tools copy this reg key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ClientSetup\Checksum

make sure you back up your existing one in case there are...

OK I have managed to import it and it splits it up into the correct rows, this is what I did using the client components version 9.00.4028.00:

Choose "Flat File Source"

Browse...

If you save your ssis package and a copy of the csv with a few lines in it - can you post it here?

You get this error because there is nothing listening on port 443 or it is blocked at a firewall level.

Have a read through this and make sure you have added...

Check in the services that the instance is running and is called the same name as you are trying to connect to.

after you select "Flat File Source" have you put " in the "Text Qualifier" box - the default is <none>

ed

bcp /?

usage: bcp {dbtable | query} {in | out | queryout | format} datafile

[-m maxerrors] [-f formatfile]...

I get the same issue here seems very odd - 9.0.4028.

Anyway it looks like you can get all the tables if you add a top X:

SELECT TOP 99.9 PERCENT ...