Hi

wondering if someone can point me in the right direction. i currently have
a DTS package that imports data from 300+ flat files and updates a main
table with results from it.

i need to add some additional checking which forces me to record the
filename and the results if they hit certain criteria.

my question is from using a modified version of the "SQLDTS.com Loop Import
and Archive (246).dts" (package, which i thank the creators for :-) )
can i record the filename that it is using into a table?

system: windows 2003, SQL Server 2000 sp4

many thanks
Simon

Hello Simon,

Sure you can. The filename is held in a variable. You can then use an ExecuteSQL
task to insert this value into a table.


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

hi Simon,
After that all the files has been loaded you could check out every
connection (text file source) and to retrieve the value for the "Datasource"
property.

--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''''s hard to provide information
without seeing the code. location: Alicante (ES)


"Simon Whale" wrote:

thanks Allan,

found the exact article i need on sqldts.com

http://www.sqldts.com/default.aspx?234

Regards
Simon Whale

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Hello Simon,

Glad it helped.

Also there is this article

Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com