Hello,
can anyone point me to a list of the various DTS.Connection properties. I
need to know which properties to set to import a fixed field file.

Thanks,
Erik

Best thing to do is save a package containing a Flat File Connector as a VB
module and read the way MS do it.

Really very good as well.

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Erik Torkildsen" <erik.torkildsen (AT) proscon (DOT) no> wrote

I want to dynamically build the DTS package for each fixed field file
import, so I don't think I can do it that way. For delimited files I have
been able to do this by setting these values on the DTS connection and using
DTS.DataPumpTask to get the data from file :

..ConnectionProperties.Item("Data Source").Value = sNewFileAndPathName
..ConnectionProperties.Item("Mode").Value = 1
..ConnectionProperties.Item("Row Delimiter").Value = vbCrLf
..ConnectionProperties.Item("File Format").Value = 1
..ConnectionProperties.Item("Column Delimiter").Value = oFileImpDef.ColSep
..ConnectionProperties.Item("File Type").Value = 1
..ConnectionProperties.Item("Skip Rows").Value = 0
..ConnectionProperties.Item("Text Qualifier").Value =
oFileImpDef.TextQualifier
..ConnectionProperties.Item("First Row Column Name").Value = False

But I have not found a list or documentation of these connection properties
anywhere, but just found them by googling...

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> skrev i melding
news:ekAbGElAFHA.2572 (AT) TK2MSFTNGP10 (DOT) phx.gbl...

Can you not build a Fixed Field size file import in a package, save to VB
and then look at how to do it.
That's how I would do it.

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Erik Torkildsen" <erik.torkildsen (AT) proscon (DOT) no> wrote