DTS document or ebook

Hi,

I need deep knowledge about DTS tasks. Can anyone send me an e-book or
related document about DTS packages. (Links on the Internet site are
generally advertisement or not working links).

Thanks,

Veysel Can DemirSQL Server Books Online is a good place to start. Then check out the
following sites:

www.sqldts.com
www.sqldev.net
http://vyaskn.tripod.com/sql_server...t_practices.htm

Here are some SQL Server DTS books:
http://vyaskn.tripod.com/sqlbooks.htm#dts
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/

"Veysel" <veysel_can_demir@.yahoo.co.uk> wrote in message
news:7d1e7961.0408110845.3d69a25d@.posting.google.c om...
> Hi,
> I need deep knowledge about DTS tasks. Can anyone send me an e-book or
> related document about DTS packages. (Links on the Internet site are
> generally advertisement or not working links).
> Thanks,
> Veysel Can Demir|||
Hi,

First of all thanks for answer. But there is a little problem, I think
that you did not understand me. I do not want book advertisements. I
need free e-books or pdf documents that I can teach me DTS.

Thanks,

Veysel Can

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||www.sqldts.com is a good place for info

DTC-getting started

Hello everyone,
Can you please post links of "getting started" tutorials on DTC?
Thanks!
> Hello everyone,
> Can you please post links of "getting started" tutorials on DTC?
Start with
http://msdn.microsoft.com/library/de..._dev_3lrn.asp.
You will find more links in the article.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com

DTC (C!) fails on same server

Is it a known issue that DTC will fail using SQL OLE defined links from and
to the same server? If I change servers within the link properties all is
well. If I link to myself, or another instance on myself, this is what I
get:
Server: Msg 7391, Level 16, State 1, Line 1
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the
specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d00a].
It makes sense that it fails, in a way, because DTC is being both a target
and a sender.
Thanks,
JohnMSDTC does not work in loopback mode. From BOL, topic "loopback linked
servers":
Loopback linked servers cannot be used in a distributed transaction.
Attempting a distributed query against a loopback linked server from within
a distributed transaction causes an error:
Msg: 3910 Level: 16 State: 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Transaction context in use by
another session.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"John Beatty" <jbeatty@.wmsgaming.com> wrote in message
news:%23faMtUzKFHA.2136@.TK2MSFTNGP14.phx.gbl...
> Is it a known issue that DTC will fail using SQL OLE defined links from
> and
> to the same server? If I change servers within the link properties all is
> well. If I link to myself, or another instance on myself, this is what I
> get:
> Server: Msg 7391, Level 16, State 1, Line 1
> The operation could not be performed because the OLE DB provider
> 'SQLOLEDB'
> was unable to begin a distributed transaction.
> [OLE/DB provider returned message: New transaction cannot enlist in the
> specified transaction coordinator. ]
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
> ITransactionJoin::JoinTransaction returned 0x8004d00a].
> It makes sense that it fails, in a way, because DTC is being both a target
> and a sender.
> Thanks,
> John
>
>

DSN Using Trusted Connection When SQL Authentication is selected

I am trying to help an in-house developer with his database. He has develope
d an Access front-end that links to SQL tables. The tables are linked using
an ODBC DSN with SQL Server Authentication selected. WHen a user opens the d
atabse, they get one of two
error messages, based on the user. THey eith get ODBC Call failed and can no
t go any further, or they get Connection failed, and the SQL Server login di
alog, where they have to uncheck Trusted connection and enter the appropriat
e username and password. W
e want it to just authenticate based on the settings in the DSN without open
ing a logn box.You can trace the calls using ODBC Trace to see exactly why the call
failed. Also, the developer's connection string may be being used and
could be stored in the system table. You'll need to modify this before
distributing the app.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

DSN Using Trusted Connection When SQL Authentication is selected

I am trying to help an in-house developer with his database. He has developed an Access front-end that links to SQL tables. The tables are linked using an ODBC DSN with SQL Server Authentication selected. WHen a user opens the databse, they get one of two
error messages, based on the user. THey eith get ODBC Call failed and can not go any further, or they get Connection failed, and the SQL Server login dialog, where they have to uncheck Trusted connection and enter the appropriate username and password. W
e want it to just authenticate based on the settings in the DSN without opening a logn box.
You can trace the calls using ODBC Trace to see exactly why the call
failed. Also, the developer's connection string may be being used and
could be stored in the system table. You'll need to modify this before
distributing the app.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.