dbTalk Databases Forums  

Flat File - Different row types - still confused

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Flat File - Different row types - still confused in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Darrick
 
Posts: n/a

Default Flat File - Different row types - still confused - 10-09-2006 , 07:13 PM






I'm trying to process header/detail lines in a flat file, something I've seen
a few examples of, but still have some questions. I've seen Allan Mitchell's
comments and an example on sqlis.com (thanks for the fine examples!), and
tried an example from a BOL post. Still, I have a question about approach.

If I have several header/detail formats AND want to allow users to specify
their own format (I'm building a front-end that creates packages from user
spec's), is there a problem with storing the row formats in metadata and
consuming that at package runtime, so that I only have 1 script component
with 1 input (flatfile) and perhaps x (max supported) outputs, and I
determine the format of the output (number and type) columns by reading my
metadata at package run time?

OR, should I create fixed output formats based on the metadata (output
column formats) when I generate the packages? Thus having 1-off script
components, rather than my own, metadata consuming component, preset
component?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.