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 |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2012-01-31 : 10:31:44
|
| I can't find it and <insert search engine> is no help.I have a very simple SSIS package that imports data from a csv file into a table, nothing fancy just a straight import. The problem I have is that the csv file has the headers in the first row and I cannot for the life of me find where to tell it to skip the first row (or to use the first row as the field names).tiasteve-----------What color do you want that database? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-01-31 : 10:45:40
|
I'm creating that kind SSIS-import packages by using the wizard.There in one of the dialogs you are able to mark something like 'Header in first row' or so...
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-31 : 13:28:27
|
quote:
Originally posted by elwoos
I can't find it and <insert search engine> is no help.I have a very simple SSIS package that imports data from a csv file into a table, nothing fancy just a straight import. The problem I have is that the csv file has the headers in the first row and I cannot for the life of me find where to tell it to skip the first row (or to use the first row as the field names).tiasteve-----------What color do you want that database?
you mark it inside properties of connection manager for csvthe property is a checkbox by name 'headers in first row'------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2012-02-03 : 06:18:29
|
| Many thanks guys-----------What color do you want that database? |
|
|
|
|
|
|
I'm sure there is an easy answer to this but...