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 |
|
dkirzner
Starting Member
1 Post |
 Posted - 2009-02-23 : 13:26:26
|
| Is there a script that can be written to end the data flowafter reading the first record ?(would rather not incur the overhead of reading the entire file viaa split transformation that throws away every record based on an expression - would also like to avoid having to do a bulk insertto a mp table limiting to 1 record - am looking for a clean solution) |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-02-23 : 13:43:48
|
| Can you be a little more specific. You just want the first record to be read from an external file? You dont care about the remaining contents or is that needed for another insert as well? |
 |
|
|
|
|
|
SSIS - Reading only a single header record