I have to create a dts package which moves data for some tables from
Server A to Server B and C. There is a flag in Server A in some lookup
table which indicates whether Server B is available or not. Similarly
there is a availability flag for Server C stored in Server A. Data
should be moved from Server A to Server B or C only if the
corresponding server available flag is stored as true in the lookup
table on Server A. How to create the package which first checks if
Server B is available and then executes data transfform tasks to move
data from Server A to B. If Server B is not available it should then do
a similar check for Server C and execute the data transform tasks. If
both the servers B and C are not available then it shouldn't execute
any of the data transform tasks. I do not prefer creating multiple
packages one for each of the destination servers.

You will want to look at something like this to do the conditional parts.

Multiple Paths in Workflow
(http://www.sqldts.com/default.aspx?218)

You can read the values to test in a number of way (Dynamic Properties Task,
Execute SQL Task etc)

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


<ycmahesh (AT) gmail (DOT) com> wrote

Hi,

None of the links involving www.sqldts.com or www.sqlis.com work.
All you get is an empty page on WinXP SP2 IE6 and Mozilla Firefox.

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