April 28, 2009 at 11:31 am
If I do not use a Text Qualifier, text fields are not enclosed in quotes. If I use a single quote or the double quote both numeric and text data are enclosed in the quotes.
The import utility will not process numeric data that is enclosed in quotes.
I new to SQL Server but I have used export and import on SQL server 2000 and they work fine.
Can anyone help me?
Thanks
April 28, 2009 at 7:33 pm
For some reason, all of your source data is being treated as text. If source data is properly recognised as numeric, the text qualifier will not be applied to it.
To check this, when you are running the wizard, click on the 'Edit Transform' button on the Configure Flat File Destination dialog. That will take you into a screen where you can view and, if necessary, amend the datatypes of the fields which you are exporting.
I am assuming that this is just a one-off export? If not, you may need to edit the package created by the wizard in BIDS to get it refined and working exactly as you want it.
Phil
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply