Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Professional SQL Server 2005 Integration Services Expand / Collapse
Author
Message
Posted Saturday, May 10, 2008 7:10 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:32 AM
Points: 33,055, Visits: 15,165
Comments posted to this topic are about the item Professional SQL Server 2005 Integration Services






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #498422
Posted Monday, May 12, 2008 6:12 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, August 11, 2013 1:09 PM
Points: 80, Visits: 580
Is it just me or does Wrox have a thing for case studies? It's just a matter of personal preference but I don't really care for them.


Post #498693
Posted Monday, May 12, 2008 10:02 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:36 PM
Points: 5,300, Visits: 1,378
Sorry Steve I am not with you this time. I personally don't like WROX books. They may be reach in content but I don't like their way of explanations. I agree with webooth that it is personal preference purely.



Post #498942
Posted Monday, May 12, 2008 11:04 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 6:26 AM
Points: 1,521, Visits: 3,036
I used this book to get going with SSIS. I would rate it a bit lower than Steve did, maybe 3.5-4.0, but then I'm not buds with the authors ;). This is one of just a few SSIS books available and it is vastly better than the $44.99 Microsoft Press "Step by Step" volume which, as its name implies gives step by plodding step for various tasks -- with very little exposition or explanation.

One other thing about the "Professional...." red-cover book worth mentioning is that it has a sequel, "Expert SQL Server 2005 Integration Services" from two of the larger team of "Professional..." authors. The "Expert..." book could be considered a second-semester text for those who've covered the basics in the first book.
Post #498974
Posted Monday, May 12, 2008 11:23 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:32 AM
Points: 33,055, Visits: 15,165
It's definitely personal preference, which is why I wanted to point that out with this book. I like case studies and walking through samples more than abstract code with step by step instructions. Probably people like me need examples more than explanations to getting going.

The Apress book might be better if you don't like this one. I have a short review on that one coming next week.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #498982
Posted Monday, May 12, 2008 1:18 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, July 13, 2014 8:07 PM
Points: 324, Visits: 376
I read this book...It is very good book and covered almost all topics for SSIS. A very good book...Recommanded by me for SSIS.
Post #499067
Posted Monday, May 12, 2008 1:27 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 17, 2014 7:55 AM
Points: 2,805, Visits: 3,067
I have this book and I don't find it super helpful.
On page 216, it talked about ActiveX script task, it said 'Visual Basic.Net' is the only language supported by the script task in SSIS 2005' and I found it not true.
When I use ActiveX script, the language is VB Script, Jscript, SignedJavaScript Class and SIgnedVBScript Class. The picture had the following tab - Script language, PrecompileScript Into Binary code, EntryPoint, ReadOnlyVariable, ReadWriteVariable. I only see Language, script and EntryMethod when I open the ActiveX script task editor. Am I missing something here? or my book is too old? It is the first edition.
Post #499074
Posted Monday, May 12, 2008 1:41 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 6:26 AM
Points: 1,521, Visits: 3,036
Loner, I think you're confusing the Script Task with the ActiveX Script Task. I've been using an on-line edition of the book at the subscription-based site www.books24x7.com. The section I think you're looking at is titled "Scripting Overview" and does distinguish among ActiveX task, Script Task, Script Component and Expression Language.

ActiveX Script Task: This task has been with DTS since SQL Server 7.0. It allows the execution of a script written in an ActiveX scripting language, such as VBScript. This task was included for backward compatibility with previous DTS packages and will be removed in the next version of SQL Server, so now is the time to upgrade to the newer components. This task will not be discussed further in this chapter.

Script Task: This task is the replacement for the ActiveX script task and is used primarily for controlling package execution. It allows the execution of a script written in Visual Basic.NET. Unfortunately, Visual Basic.NET is the only language you can use to write a script using this task. From your script, however, you can use assemblies written in other .NET languages such as C# or COM components through COM-Interop.

Script Component: This component allows for the creation of a totally custom transformation. This component is useful when the built-in transformations are not powerful or flexible enough for your needs.

Expression Language: SQL Server Integration Services includes an expression language that allows you to set variable values and perform other operations.

Post #499089
Posted Tuesday, May 13, 2008 7:28 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, May 5, 2014 1:57 PM
Points: 545, Visits: 643
Personally, I would give this a 3 out of 5. I think that Microsoft SQL Server 2005 Integration Services by Kirk Haselden is a far superior book.

"Beliefs" get in the way of learning.
Post #499579
Posted Tuesday, May 13, 2008 9:29 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 19, 2013 8:20 PM
Points: 174, Visits: 100
Personally, I feel you are very biased..
This book was written prematurely to get to market fast. Very sloppy and some of the examples, I couldnt even get to work...

I feel many of the WROX are of the same low calibre. I avoid them now...I would give it 1 ot of 5..
Post #499742
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse