I have a Text File (Source) Connection object. I need to dynamically control
the Record Length to properly read some non-standard CSV files.

When you use the Text File Properties dialog and specify a Row Delimiter of
NONE you have to also specify the Record Length.

I need to specify the Record Length value dynamically. I cannot find the
property option for this value.

Could use some help here.

If I get what you mean then does this work?

Function Main()


dim cn

set cn = DTSGlobalVariables.Parent.Connections("Text File (Source)")

cn.ConnectionProperties("Column Lengths").Value = 4


Main = DTSTaskExecResult_Success
End Function

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Jamie Carper" <JamieCarper (AT) discussions (DOT) microsoft.com> wrote

Hi Allan,

If you drop a Text File (Source) Object and then access the Text File
Properties dialog. If you select "Fixed Field Information" with a Row
Delimiter of "<None>" you then have to specify the length of the row. There
is an option in the Dialog box to do so when you click Next. However I
cannot find it's equivalent in the Object's properties for programming
purposes.

Jamie

"Allan Mitchell" wrote: