What about having like 20 transformations in 1 dts

Should I check for each file up front and if not there then disable the individual transformation

Any ideas how to check for multiple files and then turn on or off multiple transformations in one dts? I don't mind using the exact names of the files in check and or transformation

A transformation is a mapping between a SourceColumn and a
DestinationColumn. Do you mean a DataPump task?.

You can very reasonably have 20 DP tasks in one package yes. Should you
check for the file for each of your DP tasks? Yes if you want to do things
gracefully.



--
--

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


[quoted text, click to view]
transformations in one dts? I don't mind using the exact names of the files
in check and or transformation.
[quoted text, click to view]