i'm 2 days late on having this working and still don't have an answer...

here is the call:
SetConnections(oPackage.Steps.Item, oConnection) <<it
wouldn't even compile unless I did something like this:
SetConnections(oPackage.Steps.Item(1), oConnection) <<but
that's not right either...because it calls my
oStep.GetExecutionErrorInfo function and gives me this
error:
Package failed error: hexnumbers...Step ordinal '1'(base
1) is out of range.

heres the code:
Private Sub SetConnections(ByRef oPackage As DTS.Package,
ByRef oConnection As DTS.Connection)
'Connection 1 to mink
With oConnection
oConnection.Catalog = "minkbackup"
oConnection.DataSource = "SERVER05"
oConnection.ID = 1
oConnection.UseTrustedConnection = True
End With
oPackage.Connections.Add(oConnection)
'UPGRADE_NOTE: Object oConnection may not be
destroyed until it is garbage collected. Click for
more: 'ms-help://MS.VSCC.2003/commoner/redir/redirect.htm?
keyword="vbup1029"'
oConnection = Nothing

if you know of any other code that will do this:
i have these files needing to go into these tables in sql server 2000:

Program.txt = TBL_Client(a table)
BatchGroup.txt = TBL_Group(a table)
Catalog.txt = TBL_Catalog(a table)
Item.txt = TBL_MasterItem(a table)
ItemSold.txt = TBL_ItemsSold(a table)
Seller.txt = TBL_Seller(a table)

they will always have the same format...something like this:

"HSHS02","M100011","000289000","1106","3",""
"HSHS02","M100011","000289000","1140","3",""
"HSHS02","M100016","000289000","1143","1",""
"HSHS02","M100011","000289000","1509","3",""


..Net programmer
trintsmith (AT) hotmail (DOT) com

Please do not post the same message under different subjects. See Darren's reply to your other post


--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org