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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Data Import - header and trailer files

Author  Topic 

john.burns
Posting Yak Master

100 Posts

Posted - 2007-07-05 : 13:44:03
anyone know how to :
detect header row and insert to table a
process data rows and insert to table b
detect trailer row and import to table a

thanks

igorblackbelt
Constraint Violating Yak Guru

407 Posts

Posted - 2007-07-06 : 10:34:29
It can sound a little silly, but I would write a little program that would do it for me, based on record length.
If record < X goes there
If record > Y goes there
If record <> Z goes there


---
"Try not to become a man of success but rather try to become a man of value."
Go to Top of Page

tmitch
Yak Posting Veteran

60 Posts

Posted - 2007-07-16 : 23:09:41
What differentiates a header/trailer row from a row of real data?
Go to Top of Page
   

- Advertisement -