dbTalk Databases Forums  

Yukon DTS: DTSTransactionOption Enumeration

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


Discuss Yukon DTS: DTSTransactionOption Enumeration in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jamie
 
Posts: n/a

Default Yukon DTS: DTSTransactionOption Enumeration - 06-15-2004 , 08:32 AM






Hello,

Dunno if anyone out there is yet au fait with Yukon DTS - hopefully
there's someone...

Containers have a property called TransactionOption the possible
values for which are enumerated by an enumeration called
DTSTransactionOption. The enumerated values are
NotSupported|Supported|Required

Anyone know/care to hazard a guess as to what these 3 values mean? I
can't find anything on Google or Technet. My natural assumption is
whether the Container participates in a parent transaction or not but
I would expect only 2 possible answers for this (TRUE|FALSE), a la DTS
2000.

cheers
Jamie

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Yukon DTS: DTSTransactionOption Enumeration - 06-15-2004 , 08:43 AM






You might want to come up on the Yukon Private Newsgroups and ask this Q.

--

----------------------------

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


"Jamie" <jamiekthomson (AT) blueyonder (DOT) co.uk> wrote

Quote:
Hello,

Dunno if anyone out there is yet au fait with Yukon DTS - hopefully
there's someone...

Containers have a property called TransactionOption the possible
values for which are enumerated by an enumeration called
DTSTransactionOption. The enumerated values are
NotSupported|Supported|Required

Anyone know/care to hazard a guess as to what these 3 values mean? I
can't find anything on Google or Technet. My natural assumption is
whether the Container participates in a parent transaction or not but
I would expect only 2 possible answers for this (TRUE|FALSE), a la DTS
2000.

cheers
Jamie



Reply With Quote
  #3  
Old   
Jamie
 
Posts: n/a

Default Re: Yukon DTS: DTSTransactionOption Enumeration - 06-15-2004 , 09:45 AM



Ah OK, pardon me.

What and where are the Yukon private newsgroups?
I'm assuming from the word "Private" that not just anyone has access to them. Do you have to be part of the Beta program?

cheers
Jamie

"Allan Mitchell" wrote:

Quote:
You might want to come up on the Yukon Private Newsgroups and ask this Q.

--

----------------------------

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


"Jamie" <jamiekthomson (AT) blueyonder (DOT) co.uk> wrote in message
news:6007d4b6.0406150532.6923b313 (AT) posting (DOT) google.com...
Hello,

Dunno if anyone out there is yet au fait with Yukon DTS - hopefully
there's someone...

Containers have a property called TransactionOption the possible
values for which are enumerated by an enumeration called
DTSTransactionOption. The enumerated values are
NotSupported|Supported|Required

Anyone know/care to hazard a guess as to what these 3 values mean? I
can't find anything on Google or Technet. My natural assumption is
whether the Container participates in a parent transaction or not but
I would expect only 2 possible answers for this (TRUE|FALSE), a la DTS
2000.

cheers
Jamie




Reply With Quote
  #4  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Yukon DTS: DTSTransactionOption Enumeration - 06-15-2004 , 12:47 PM



Yes you do have to be part of the Beta Program.

Did you get your's through PASS or some other conference?

You should have the help files.
What build are you using?



--
--

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


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

Quote:
Ah OK, pardon me.

What and where are the Yukon private newsgroups?
I'm assuming from the word "Private" that not just anyone has access to
them. Do you have to be part of the Beta program?

cheers
Jamie

"Allan Mitchell" wrote:

You might want to come up on the Yukon Private Newsgroups and ask this
Q.

--

----------------------------

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


"Jamie" <jamiekthomson (AT) blueyonder (DOT) co.uk> wrote in message
news:6007d4b6.0406150532.6923b313 (AT) posting (DOT) google.com...
Hello,

Dunno if anyone out there is yet au fait with Yukon DTS - hopefully
there's someone...

Containers have a property called TransactionOption the possible
values for which are enumerated by an enumeration called
DTSTransactionOption. The enumerated values are
NotSupported|Supported|Required

Anyone know/care to hazard a guess as to what these 3 values mean? I
can't find anything on Google or Technet. My natural assumption is
whether the Container participates in a parent transaction or not but
I would expect only 2 possible answers for this (TRUE|FALSE), a la DTS
2000.

cheers
Jamie






Reply With Quote
  #5  
Old   
Jamie
 
Posts: n/a

Default Re: Yukon DTS: DTSTransactionOption Enumeration - 06-15-2004 , 04:11 PM



My company (Conchango) are part of the beta program hence we have the software. We joined the beta program before I joined the company though so I wasn't one of the named reps (or whatever it is you have to be). We are represented on the PAC however so my manager is trying to get me a new account for the Yukon newsgroups and associated stuff through his contacts!

The help files don't cover the answer to my question at the start of this thread even though I'm on a post-beta 1 version. In the meantime I'm happy conversing/exploring through the regular channels and in this particular case I can make a pretty good guess as to the answer!

cheers
Jamie


"Allan Mitchell" wrote:

Quote:
Yes you do have to be part of the Beta Program.

Did you get your's through PASS or some other conference?

You should have the help files.
What build are you using?




Reply With Quote
  #6  
Old   
Jamie
 
Posts: n/a

Default Re: Yukon DTS: DTSTransactionOption Enumeration - 06-15-2004 , 04:11 PM



My company (Conchango) are part of the beta program hence we have the software. We joined the beta program before I joined the company though so I wasn't one of the named reps (or whatever it is you have to be). We are represented on the PAC however so my manager is trying to get me a new account for the Yukon newsgroups and associated stuff through his contacts!

The help files don't cover the answer to my question at the start of this thread even though I'm on a post-beta 1 version. In the meantime I'm happy conversing/exploring through the regular channels and in this particular case I can make a pretty good guess as to the answer!

cheers
Jamie


"Allan Mitchell" wrote:

Quote:
Yes you do have to be part of the Beta Program.

Did you get your's through PASS or some other conference?

You should have the help files.
What build are you using?




Reply With Quote
  #7  
Old   
Darren Green
 
Posts: n/a

Default Re: Yukon DTS: DTSTransactionOption Enumeration - 06-17-2004 , 08:15 AM



If you are on the beta program then you are covered by an NDA. The only
build released publicly without an NDA is beta 1, but beta participants must
still be careful when talking publicly about this build as they may have had
access to the NDA information through the beta program itself, in particular
later builds.

Just by looking at the values however it seems reasonable that they follow
to existing transaction model, such as .Net frame work classes
(http://msdn.microsoft.com/library/de...-us/cpguide/ht
ml/cpconautomatictransactionsnetframeworkclasses.asp)

If you want more then please follow up in private groups, or get a colleague
who has access to do this in the meantime.


--
Darren Green
http://www.sqldts.com



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

Quote:
My company (Conchango) are part of the beta program hence we have the
software. We joined the beta program before I joined the company though so I
wasn't one of the named reps (or whatever it is you have to be). We are
represented on the PAC however so my manager is trying to get me a new
account for the Yukon newsgroups and associated stuff through his contacts!
Quote:
The help files don't cover the answer to my question at the start of this
thread even though I'm on a post-beta 1 version. In the meantime I'm happy
conversing/exploring through the regular channels and in this particular
case I can make a pretty good guess as to the answer!
Quote:
cheers
Jamie


"Allan Mitchell" wrote:

Yes you do have to be part of the Beta Program.

Did you get your's through PASS or some other conference?

You should have the help files.
What build are you using?






Reply With Quote
  #8  
Old   
Jamie
 
Posts: n/a

Default Re: Yukon DTS: DTSTransactionOption Enumeration - 06-17-2004 , 08:26 AM



Thanks Darren, will do. Hopefully my Yukon beta account will be forthcoming.
I'll be more wary next time!!!

"Darren Green" wrote:

Quote:
If you are on the beta program then you are covered by an NDA. The only
build released publicly without an NDA is beta 1, but beta participants must
still be careful when talking publicly about this build as they may have had
access to the NDA information through the beta program itself, in particular
later builds.

Just by looking at the values however it seems reasonable that they follow
to existing transaction model, such as .Net frame work classes
(http://msdn.microsoft.com/library/de...-us/cpguide/ht
ml/cpconautomatictransactionsnetframeworkclasses.asp)

If you want more then please follow up in private groups, or get a colleague
who has access to do this in the meantime.


--
Darren Green
http://www.sqldts.com




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.