Books for Yokun

Hello Guys,
I am completely familiar with DTS and database programming and I'd like to
start learning about Yokun version .Which books do you suggest for Analysis
services and SSIS and Sql server 2005?
ThanksFor AS, you should refer to Chris Webb's list, here:
http://spaces.msn.com/members/cwebbbi/Blog/cns!1pi7ETChsJ1un_2s41jm9Iyg!322.
entry
For SSIS, I don't think there are any books out yet, but I know that Kirk
Haselden is working on one for release early next year. You'll want to
watch for that one. He's the dev lead on the SSIS team so he knows a thing
or two about the product :)
Finally, for general SQL Server 2005 topics, I would appreciate it if you
would look at the link in my signature!
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"J-T" <J-T@.nospam.com> wrote in message
news:u1kOWdS8FHA.1280@.TK2MSFTNGP10.phx.gbl...
> Hello Guys,
> I am completely familiar with DTS and database programming and I'd like to
> start learning about Yokun version .Which books do you suggest for
> Analysis services and SSIS and Sql server 2005?
> Thanks
>|||Thanks a lot
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:uQOkDgW8FHA.2616@.TK2MSFTNGP15.phx.gbl...
> For AS, you should refer to Chris Webb's list, here:
> http://spaces.msn.com/members/cwebbbi/Blog/cns!1pi7ETChsJ1un_2s41jm9Iyg!32
2.entry
> For SSIS, I don't think there are any books out yet, but I know that Kirk
> Haselden is working on one for release early next year. You'll want to
> watch for that one. He's the dev lead on the SSIS team so he knows a
> thing or two about the product :)
> Finally, for general SQL Server 2005 topics, I would appreciate it if you
> would look at the link in my signature!
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "J-T" <J-T@.nospam.com> wrote in message
> news:u1kOWdS8FHA.1280@.TK2MSFTNGP10.phx.gbl...
>

Blocking issue in DTS package running on 2005

I'm testing an existing 2000 DTS package in 2005. A Data Transformation Task selects from a view and loads a table that was just truncated. The view definition contains a subselect selecting data off the table,

View: select ... from a, (select ... from b) b2 ON ...

Table to insert into: b

There is blocking going on during the execution of the package. The select * from view (Source) and the insert bulk into the table (Destination) are blocking each other. This does not happen in 2000.

Is there a command that I can put in the view definition subselect that will allow me to just grab the data that it can without worrying about blocking? Would READCOMMITTED or READUNCOMMITED work without impact on the view? Other recommendations?

Has anyone ever run into this?

I found that when you uncheck the Table Lock box of the Data Transformation Task, that this blocking does not occur. Does anyone know why this is required in 2005 but works fine in 2000 with the box checked?