Hi ,

I created a DTS package to extract the *.csv files to
SQL server but I have some issue after running this
package.

For instance
in the csv file it consist 1 column call product code

Product Code
'1123
'0233

The single quotes (') in front of product code only show
when I double click on that cell.

After I transfer the data to SQL server , I cannot find
the product code = 0233.I can only see NULL values store
in the SQL for this product.

How to resolve this issue ?

TQ for helps

cell?

What cell? Sounds like Excel so have a read of this

Excel Inserts Null Values
(http://www.sqldts.com/default.aspx?254)

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Travis" <anonymous (AT) discussions (DOT) microsoft.com> wrote