Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sifu
Starting Member
8 Posts |
 Posted - 2006-12-12 : 00:34:51
|
| Hi everyone,I have encountered a problem trying to load data from a flat file to sql server. I'm using the Sql Server Integration Services (SSIS) wizard to import data. It's seem to run ok (no error messages) but when view the table I have just load it's all null. I can't explain why this is happening. Can anyone help or tell me what I've done wrong?The structure of the flat file is: state,cvmake,cvmodel,pvyear,...ntp,ford,falcon,2005,....ntp,holden,commodore,2001,....ntp,chevrolet,silverado,2003,.....,.,.,.,....,.,.,.,...ntp,suzuki,vitara,2000,....Cheers,Sifu |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-12 : 01:07:26
|
| Are you using proper datatypes? If you are importing data and using integer as datatype when importing names, nulls are inserted instead, just as you describe.Peter LarssonHelsingborg, Sweden |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
Sifu
Starting Member
8 Posts |
Posted - 2006-12-12 : 17:11:05
|
Hi Peter,Thanks for the reply.There are more than 5000 records in the flat file. The table after import only show 1 row of null value for all fieldnames. The results after the import in the table is:state cvmake cvmodel pvyear ..... date null null null null ..... nullIf I have incorrect datatype wouldn't it only showing null for that particular column (fieldname)? I probably didn't explain my well in the previous.Looking forward to your reply.CheersSifuAustraliaquote:
Originally posted by Sifu
Hi everyone,I have encountered a problem trying to load data from a flat file to sql server. I'm using the Sql Server Integration Services (SSIS) wizard to import data. It's seem to run ok (no error messages) but when view the table I have just load it's all null. I can't explain why this is happening. Can anyone help or tell me what I've done wrong?The structure of the flat file is: state,cvmake,cvmodel,pvyear,...ntp,ford,falcon,2005,....ntp,holden,commodore,2001,....ntp,chevrolet,silverado,2003,.....,.,.,.,....,.,.,.,...ntp,suzuki,vitara,2000,....Cheers,Sifu
|
|
|
|
Sifu
Starting Member
8 Posts |
|
|
|
|
|
|
|
Load data from flat file to sql server
blog thingie: http://weblogs.sqlteam.com/mladenp