SQLTeam.com | Weblogs | Forums

SSIS CSV Correct format


#1

i have a ssis package to read csv file and load in into a databse . The proble is the file i am getting is like this when i open it in notepad++ .i wonder if this is the correct ssis file format as i cant read the contents of file,No Record when i preview

MODEL_DSC , MODEL_CD , DERIVATIVE_CD , VIN NUMBER , OUT_GATE DATE , DISTRIBUTION_CD , POL CD , POD CD
X152 Jaguar (XK) , W5 , W5MCE , SALCA2BGXGH551590 , 2015-08-28 , , GBSOU , MXVER

It shows nul before and after the column values and data value . how to do the settings in flat file connection manager .
NulX152 Jaguar (XK) Nul, W5Nul , Nul W5MCE nul , Nul SALCA2BGXGH551590 , 2015-08-28 , , GBSOU , MXVER
like this