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

thanks!

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


"kdabda" <anonymous (AT) discussions (DOT) microsoft.com> wrote

in check and or transformation.

exactly. I have it set so that I have 1 data source and 1 data destination, and then like 20 DP tasks in between the 2. Is there a way to check for the file and then either turn on or off the DP task? Or how should I check for the file and then import if it is there, do I have to set up all seperate dts for each file?