Workflow is the only way i can think of.
Do the checking for the file up front of any transformation. if the file is
not there then do not attempt the import and move on.
Workflow
(http://www.sqldts.com/default.aspx?103)
--
--
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
Quote:
I am using multiple transform data tasks to import into SQL Server 2000
about 20 dbase 5 tables. I have each individual table have a data transform
|
task to move into sql. Some times a dbase source table may not be present,
for correct reasons. Right now it errors out if a source table it missing.
Is there any way to say if that table is not present in the source, do not
do the transform data task??
Quote:
Otherwise I will be getting many errors when I go to run this. Thanks,
|
Re: transform data task missing source -
04-13-2004
, 09:00 AM
Linear Mode
