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 |
|
john.burns
Posting Yak Master
100 Posts |
 Posted - 2007-08-15 : 11:55:52
|
| How t o capture a header record from a flat file and write it to different table.It seems that Conditional Split task doesn't work because it detects the different layout and errors out.any help would be appreciated.thanks |
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-08-15 : 13:37:50
|
| do u mean u want to create another table with same column names.or u need to insert the header into another table.please clarify. if its case one then just copy the data from flat file and truncate the dataAshley Rhodes |
 |
|
|
john.burns
Posting Yak Master
100 Posts |
Posted - 2007-08-15 : 15:08:48
|
| insert header to another table with different layout than detail records(table) |
|
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-08-15 : 15:17:25
|
| show some example of what you want to doAshley Rhodes |
|
|
|
|
|
|
Capture Header Record