Re: Property Mapping in DTS Yukon SQL2005

#1

You would be better asking this on the Yukon NGs if you are a member of the
Beta programme.

I will tell you this though as it is not anything that you cannot know
yourself.

1. You can use "Configurations" to map a value to the server name
2. You would set the variable (Yes this is different in Yukon but still
valid). You would then use the variable in workflow to decide what you want
to do.

If you come up on the Betas NGs I can give you all the code you need and
show you exactly where you need to go.

--

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
"Vipul Shah" <Vipul Shah (AT) discussions (DOT) microsoft.com> wrote

Quote:

I am having trouble understanding Variables and Property Mapping. I have
following four variable:

I have two simple data pump task in my package - one does full table
transfer and another does partial table transfer based on the date value

provided in a variable. Following are the variables I need in my package.

Quote:

1. Source Server - which I want to map to ServerName of OLEDB Connection
(Source Connection)
A Flag, which indicates which route I should go - Partial or Full.
Usually in SQL2K 2. DTS, I used ActiveX Script to check the value of that

variable and executed the task (as outlined below):

Quote:

Function Main()
IF DTSGlobalVariables("gvRecoveryType").value = "Partial" THEN
Main = DTSStepScriptResult_ExecuteTask
ELSE
Main = DTSStepScriptResult_DontExecuteTask
END IF
End Function

These is no longer valid in SQLServer 2005 DTS. What should I do to
achive this logic.

3. Date value, which I will use to construct source SQL command. Something
like this:

"Select * from table1 where myDate > ?" Where "?" will be the variable
value.

Need help!

Thanks
Vipul Shah
Townsend Analytics, Ltd.
Chicago, IL
312-453-8267

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Property Mapping in DTS Yukon SQL2005

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Property Mapping in DTS Yukon SQL2005 - 07-01-2004 , 02:13 AM