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 |
|
Sn7
Starting Member
2 Posts |
 Posted - 2004-06-15 : 05:03:32
|
| HiI'm importing data from an excel doc into my database, I created a DTs package to do this, the problem is that the excel document has name headers in the first row and I can't import thses but only the data...Can I use the dtstransformstat_skiprow to skip the first row that has the headers?I've never used the dtstransformstat_skiprow statement before and don't know how it workks, can anyone help me out please. I need to skip row 1 in my excel docuement...Thanks |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-06-15 : 19:19:50
|
| Isn't there an option within the transform data task to ignore the first row? |
 |
|
|
|
|
|
Skipping a row (dtstransformstat_skiprow Statement