Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Professional SQL Server 2005 Integration Services


Professional SQL Server 2005 Integration Services

Author
Message
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36300 Visits: 18752
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
My Blog: www.voiceofthedba.com
webooth
webooth
SSC Journeyman
SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)

Group: General Forum Members
Points: 84 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.



Anipaul
Anipaul
SSCertifiable
SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)

Group: General Forum Members
Points: 6279 Visits: 1407
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.



john.arnott
john.arnott
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1474 Visits: 3059
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 Wink. 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.
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36300 Visits: 18752
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
My Blog: www.voiceofthedba.com
RPSQL
RPSQL
SSC-Addicted
SSC-Addicted (472 reputation)SSC-Addicted (472 reputation)SSC-Addicted (472 reputation)SSC-Addicted (472 reputation)SSC-Addicted (472 reputation)SSC-Addicted (472 reputation)SSC-Addicted (472 reputation)SSC-Addicted (472 reputation)

Group: General Forum Members
Points: 472 Visits: 609
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.
Loner
Loner
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2918 Visits: 3329
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.
john.arnott
john.arnott
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1474 Visits: 3059
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.

Robert Frasca
Robert Frasca
SSChasing Mays
SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)

Group: General Forum Members
Points: 614 Visits: 742
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.
Michael David
Michael David
SSC-Enthusiastic
SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)

Group: General Forum Members
Points: 174 Visits: 108
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..
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search