SQL 2005 Import Data

#1

Hi,

I am seeing some basic problems with SQL 2005 Import Data feature. We have
some text files that needs to be imported into SQL Tables. Using SQL 2000 we
were able to import the files without problems but with 2005 it does not work
the same way. For example String Identifier does not identify the string
within quotes correctly.
I know there are many other ways to import the data including bcp. This was
a easy to use method that can be done by amateurs too.
Please let me know if anyone has a workaround for this Or if this has been
fixed through some other options...

Thanks in advance!

#2

Hello JK,

Without seeing the setup of the file or sample rows of data it is diffucult
to know where the import is going wrong.

are you able to provide more info?

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:

Hi,

I am seeing some basic problems with SQL 2005 Import Data feature. We
have some text files that needs to be imported into SQL Tables. Using
SQL 2000 we were able to import the files without problems but with
2005 it does not work the same way. For example String Identifier does
not identify the string within quotes correctly. I know there are many
other ways to import the data including bcp. This was a easy to use
method that can be done by amateurs too. Please let me know if anyone
has a workaround for this Or if this has been fixed through some other
options...

Thanks in advance!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL 2005 Import Data

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

SQL 2005 Import Data - 05-22-2006 , 05:24 PM

Re: SQL 2005 Import Data - 05-25-2006 , 04:29 AM