<ycmahesh@gmail.com> wrote in message
news:1119920069.722154.173350@z14g2000cwz.googlegroups.com...
>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.
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:evGvmC6eFHA.612@TK2MSFTNGP12.phx.gbl...
> 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@gmail.com> wrote in message
> news:1119920069.722154.173350@z14g2000cwz.googlegroups.com...
>>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.
>>
>
>