Ok, I've been working with SQL Server for a few years, but am compltetely stumped by this one....
Basically I have a csv file which comprises of a header, column names followed by column data as follows
"Created at ","6-May-2003 13:54:10","GMT" (FILE HEADER)
"Mgr1 Name","Mgr2 Name","Mgr3 Name","SE Name","SE_USER_ID","OPP_NO","SE_COUNTRY","SITE_ID","SITE_NAME","FRCST_CLOSE_DT","FRCST_PROD_REV","FRCST_SERV_REV","FRCST_ED_REV","CURRENCY_CD","PROB_CLOSE_PCT","STATUS_CD","TOP_DEAL_IND","TAS_PLAN_IND","PROB_WIN_PCT","MF_OPP_IND","OPP_SUMMARY_TXT","BLANK","TOPS_NAME","ADDRESS_1","ADDRESS_2","CITY","STATE","ZIP","COUNTRY","PERIL_IND","INSIDE_QTR_IND","E_BUSINESS","ENTERPRISE_MGMT","TEMP","OS390","PORTAL_MGMT","PREDICITIVE_ANAL","SECURITY","STORAGE","TIME","TIMECAP","VSE_VM","Mgr1ID","Mgr2ID","Mgr3ID","Row#","Mgr4 Name","Mgr4ID" (COLUMN NAMES)
"mgr1 data","mgr2 data","Mgr3 data","SE data", and so on (DATA)
"mgr1 data","mgr2 data","Mgr3 data","SE data", and so on (DATA)
"mgr1 data","mgr2 data","Mgr3 data","SE data", and so on (DATA)
Now, I just cannot get the damn data to import (using DTS) - it complains of too many columns being found in the current row. I've tried setting up the data transformation to skip x number of rows, first row has column names, etc, but no luck.
If I manually remove the first row (Created at......) and then import it works fine.
So, what do I need to do? I really could do without any manual intervention (ie modifying the source file).
Thx
Topic Options
Post Options
Thanks(0)
