Re: SSIS - Flat Files

David,

I'm not aware of any easy/automatic way to use your existing custom
format files through the SSIS Designer.

When creating a Flat File Connection Manager specify fixed width in
the Format dropdown on the General tab. Then on the Columns tab use
the GUI to define column widths after defining row width.

Andrew Watt [MVP]

On Wed, 19 Apr 2006 14:41:01 -0700, Wiseman82
<Wiseman82@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I've started learning SSIS and I'd like to replace our import tool with an
SSIS project. The data warehouse is populated from flat files (fixed width
format) - there are a handful of different formats and all the files are
quite wide ~300 columns. I already have custom format files used by our
current import tool - these are stored as csv files that specify column
names, start, end and length of each column. e.g.

; Comments at start of file starting with a semi-colon
columnname, start, end, length
MyColumnName, 1, 2, 2
MyColumnName2, 3, 6, 4

Is there an easy method to create a flat file connection from these format
files? It would be time consuming to create these by hand - Is there an easy
way to create these connections. I know you can create custom data sources -
the existing flat file data source is fine, but an easy method to enter the
specification would be useful.

Many Thanks,

David
.

Relevant Pages

  • Re: Trying to export flat file
    ... I tried building that in a macro, using text format instead of XLS, and I get ... the same thing as if I export with the File->Export command, ... > Substitute your own query name and the name you want for the export file. ... >>I am trying to export a flat file of data, ...
    (microsoft.public.access.gettingstarted)
  • Re: convert from char(6) to datetime
    ... using one of the format codes ... I receive a very much unstructured flat file, which I import into a SQL ... one of the flat file columns is ... "The conversion of char data type to smalldatetime data type resulted in an ...
    (microsoft.public.sqlserver.connect)
  • Re: port binding in flat file receive sample
    ... You can treat the flat file assembler/disassembler the same way you would ... format for the disassembler is flat file, and the destination format for the ... > 1)i did not undestand how output port got binded to the orchestration. ...
    (microsoft.public.biztalk.general)
  • Re: receiveing flat files
    ... I think is the file format, it seems likely that we can parse it. ... > the flat file disassembler in the receive pipeline. ... > map just the vaule part with the schema i provide. ...
    (microsoft.public.biztalk.general)
  • Re: Need performance help
    ... Monitor utility output to Comma Separated Value format files. ... At least one CSV file must be specified. ... the matching parameters from all the files are shown on the same chart. ... specify the commands on the command line. ...
    (comp.os.vms)