Link to home
Start Free TrialLog in
Avatar of uma_
uma_

asked on

bulk import query in sql 2008

When i run the query i get zero rows affected .what i am doing wrong?

The query i am trying is

Bulk insert SDCData
from 'C:\WORKDRIVE\SHOPTHEWEB_DROPBOX\My
Dropbox\ShopTheWeb\bulkupload\mobile_phones_and_accessories.txt'
 WITH
   (
       FIELDTERMINATOR = '\t',
       ROWTERMINATOR = '\n',
       CODEPAGE='TEXT',
         DATAFILETYPE='char',
       FIRSTROW = 2,
       KEEPNULLS
       )


Table structure:

CREATE TABLE [dbo].[SDCData](
       [OFFER_ID] [varchar](25) NULL,
       [OFFER_TITLE] [varchar](96) NULL,
       [PRICE] [varchar](50) NULL,
       [OFFER_DESCRIPTION] [varchar](1024) NULL,
       [MERCHANT_ID] [varchar](50) NULL,
       [MERCHANT_NAME] [varchar](18) NULL,
       [MERCHANT_SKU_NUMBER] [varchar](21) NULL,
       [SDC_PRODUCT_ID] [varchar](50) NULL,
       [MPN] [varchar](14) NULL,
       [CATEGORY_NAME] [varchar](24) NULL,
       [STOCK] [varchar](8) NULL,
       [CATEGORY_ID] [varchar](50) NULL,
       [STOCK_DESCRIPTION] [varchar](76) NULL,
       [IMAGE_URL] [varchar](97) NULL,
       [MAX_IMG_WIDTH] [varchar](50) NULL,
       [MAX_IMG_HEIGHT] [varchar](50) NULL,
       [SHIPPING_RATE] [varchar](50) NULL,
       [SHIPPING_WEIGHT] [varchar](50) NULL,
       [ZIP_CODE] [varchar](20) NULL,
       [MANUFACTURER] [varchar](14) NULL,
       [ATTRIBUTES] [varchar](136) NULL,
       [MIN_CATEGORY_BID] [varchar](50) NULL,
       [MERCHANT_CATEGORY_BID] [varchar](50) NULL,
       [OFFER_URL_MIN_CATEGORY_BID] [text] NULL,
       [OFFER_URL_MERCHANT_CATEGORY_BID] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
Mobile-Phones-and-Accessories.zip
Avatar of lof
lof
Flag of United Kingdom of Great Britain and Northern Ireland image

Please keep it in one post. There is no need to cross post it.
For people interested in the problem I will post solution under original question
https://www.experts-exchange.com/questions/25026450/mssql-2008-query.html?cid=1572&anchorAnswerId=26202761#a26202761
Avatar of uma_
uma_

ASKER

Hi,

The solution u provided i tried still it is not working.

I first post the comment in that post only no reply for an hour so i look for some other experts to get the help.Is it wrong?
ASKER CERTIFIED SOLUTION
Avatar of lof
lof
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial