I am new to DTS and could use a little advice on creating a DTS package. I
am import a few .txt files and they need to be imported in a particular
order (File A first, then File B). What I have now is an text file (source)
connected to a Microsoft OLEDB provider for SQL connected with a data
transform task. Then I have another text file (source) connected to another
Microsoft OLEDB provider for SQL connected with a data transform task. The
first Microsoft OLEDB provider for SQL is connected to the second text file
(source) with a success workflow. Is this the way I should be doing this,
or is there a better way?

Thanks for your help

Tim

If you need to load in a given order I would do this


TextFileConnection1 ---Pump --->SQL ServerCon1



--
--

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


"Tim Kelley" <tim.kelley (AT) iddonline (DOT) com> wrote