First of all

Using sp_ as a prefix to a stored proc is considered a performance hit. SQL
Server will first look for this SP in master before the local DB.

Without doubt the best way to see how DTS hangs together is to build the
package in designer first and then save as a VB module. You can then see
the relevant parts of the package

Why are you doing this using code? Using code in the way I think you are
using it means that you are rebuilding a package every time.

From what I see of the thing you are trying to do are you trying to execute
a proc for every row in a table/csv file?



--

----------------------------

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


"A Fu" <AFu (AT) discussions (DOT) microsoft.com> wrote

trying to do here would work:
property. I've assigned Column objects to the UpdateQueryColumns property.
The parameters come from the csv flat file.