skip to content
SQL Server integration services using Visual Studio 2005 : a beginners guide Preview this item
ClosePreview this item
Checking...

SQL Server integration services using Visual Studio 2005 : a beginners guide

Author: Jayaram Krishnaswamy; Anand Narayanaswamy
Publisher: Birmingham, U.K. : Packt Pub., ©2007.
Series: From technologies to solutions.
Edition/Format:   eBook : Document : EnglishView all editions and formats
Summary:
Explains how to program and maintain databases and client-server systems using SQL to retrieve data and control operations.
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

 

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Additional Physical Format: Print version:
Krishnaswamy, Jayaram.
SQL server integration services using Visual Studio 2005.
Birmingham : Packt Pub., ©2007
(OCoLC)220914329
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Jayaram Krishnaswamy; Anand Narayanaswamy
ISBN: 9781847193322 1847193323 1847193315 9781847193315 1281236756 9781281236753
OCLC Number: 263352458
Notes: Title from title screen.
Description: 1 online resource (vii, 301 pages) : illustrations.
Contents: SQL Server Integration Services Using Visual Studio 2005; SQL Server Integration Services Using Visual Studio 2005; Credits; About the Author; Acknowledgements; About the Reviewers; Preface; What This Book Covers; What You Need for This Book; Who is This Book for; Conventions; Reader Feedback; Customer Support; Errata; Questions; 1. SSIS Basics; SQL Server Integration Services; Objects Used in SSIS; The SSIS Package; The Control Flow Elements; Data Flow Components; Data Source Components; Data Transformation; Data Flow Destinations; Connection Managers; Variables; Event Handlers. Log ProvidersDebugging and Diagnostic Features; Summary; 2. Creating a BI Project for SSIS in Visual Studio 2005; Business Intelligence using Microsoft Products; Resources Used for Creating Projects; Creating Your First BI Project for SSIS; Launching VS 2005 and Creating a BI Project for Integration Services; Business Intelligence Project Properties; Overview of the Project Window; Canvas for Package Design; Control Flow; Data Flow; Event Handlers; Package Explorer; The Toolbox; Adding Items not Available in the Toolbox; Toolbox Items; The Solution Explorer; Getting Various Windows. Server Explorer WindowBookmark Window; Class View and Code Definition Windows; Object Browser; Error List Window; Output Window; Properties Window; Tasks List Window; Toolbox Window; Find Results Window; Other Windows; Debug Windows; BI Related Items in Tools/Options; Property Pages and Folders of the Project; Executing the Package and Saving the Project; Hands-On Exercises; Hands-On Exercise 1; Hands-On Exercise 2; Hands-On Exercise 3; Summary; 3. Sending Email with a SSIS Package; Hands-On Exercise One: Sending an Email Using the SMTP Server. Hands-On Exercise Two: How to Find Your ISP's SMTP Server?Summary; 4. Transferring Data to a Text File; Hands-On Exercise: Transferring Data to a Text File; Step 1: Creating a BI Project and Adding a Data Flow Task; Step 2: Adding Connection Manager for the DataReader; Step 3: Configuring the Source; Step 4: Adding a Flat File Destination and Establishing a Path from DataReader Source; Step 5: Configuring the Flat File Destination Component; Step 6: Build and Execute the Package; Summary; 5. Transferring Data to a Microsoft Excel File; Hands-On Exercise: Transferring Data to an Excel File. Step 1: Creating a BI Project and Adding a Data Flow TaskStep 2: Configuring the DataReader's Connection Manager; Step 3: Configuring the DataReader Source; Step 4: Adding a Character Map Transformation; Step 5: Adding an Excel Destination and Establishing a Path to It from the Character Map Data Flow Component; Step 6: Configuring the Excel Destination Component; Step 7: Testing the Package; Summary; 6. Data Transfer to an MS Access Database; Hands-On Exercise: Transferring Data to an Access Database; Step 1: Creating a BI Project and Adding a Data Flow Task.
Series Title: From technologies to solutions.
Responsibility: Jayaram Krishnaswamy ; reviewer, Anand Narayanaswamy.

Abstract:

Explains how to program and maintain databases and client-server systems using SQL to retrieve data and control operations.

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/263352458> # SQL Server integration services using Visual Studio 2005 : a beginners guide
    a schema:CreativeWork, schema:Book, schema:MediaObject ;
    library:oclcnum "263352458" ;
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/801526980#Place/birmingham_u_k> ; # Birmingham, U.K.
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/enk> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/801526980#Topic/computers_data_processing> ; # COMPUTERS--Data Processing
    schema:about <http://experiment.worldcat.org/entity/work/data/801526980#CreativeWork/microsoft_visual_studio> ; # Microsoft Visual studio.
    schema:about <http://experiment.worldcat.org/entity/work/data/801526980#Topic/relational_databases> ; # Relational databases
    schema:about <http://experiment.worldcat.org/entity/work/data/801526980#CreativeWork/sql_server> ; # SQL server.
    schema:about <http://id.worldcat.org/fast/864205> ; # Client/server computing
    schema:about <http://dewey.info/class/005.7585/e22/> ;
    schema:about <http://id.worldcat.org/fast/1376937> ; # SQL server.
    schema:about <http://id.worldcat.org/fast/888037> ; # Database management
    schema:about <http://id.worldcat.org/fast/1389599> ; # Microsoft Visual studio.
    schema:about <http://experiment.worldcat.org/entity/work/data/801526980#Topic/sql_computer_program_language> ; # SQL (Computer program language)
    schema:bookFormat schema:EBook ;
    schema:contributor <http://experiment.worldcat.org/entity/work/data/801526980#Person/narayanaswamy_anand> ; # Anand Narayanaswamy
    schema:copyrightYear "2007" ;
    schema:creator <http://viaf.org/viaf/255003180> ; # Jayaram Krishnaswamy
    schema:datePublished "2007" ;
    schema:description "Explains how to program and maintain databases and client-server systems using SQL to retrieve data and control operations."@en ;
    schema:description "SQL Server Integration Services Using Visual Studio 2005; SQL Server Integration Services Using Visual Studio 2005; Credits; About the Author; Acknowledgements; About the Reviewers; Preface; What This Book Covers; What You Need for This Book; Who is This Book for; Conventions; Reader Feedback; Customer Support; Errata; Questions; 1. SSIS Basics; SQL Server Integration Services; Objects Used in SSIS; The SSIS Package; The Control Flow Elements; Data Flow Components; Data Source Components; Data Transformation; Data Flow Destinations; Connection Managers; Variables; Event Handlers."@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/801526980> ;
    schema:genre "Electronic books"@en ;
    schema:inLanguage "en" ;
    schema:isPartOf <http://experiment.worldcat.org/entity/work/data/801526980#Series/from_technologies_to_solutions> ; # From technologies to solutions.
    schema:isSimilarTo <http://www.worldcat.org/oclc/220914329> ;
    schema:name "SQL Server integration services using Visual Studio 2005 : a beginners guide"@en ;
    schema:productID "263352458" ;
    schema:publication <http://www.worldcat.org/title/-/oclc/263352458#PublicationEvent/birmingham_u_k_packt_pub_2007> ;
    schema:publisher <http://experiment.worldcat.org/entity/work/data/801526980#Agent/packt_pub> ; # Packt Pub.
    schema:url <http://proquest.safaribooksonline.com/9781847193315> ;
    schema:url <http://www.myilibrary.com?id=123675&ref=toc> ;
    schema:url <http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=265390> ;
    schema:url <http://public.eblib.com/choice/publicfullrecord.aspx?p=979980> ;
    schema:url <http://public.ebookcentral.proquest.com/choice/publicfullrecord.aspx?p=979980> ;
    schema:url <http://proquest.safaribooksonline.com/640> ;
    schema:url <http://site.ebrary.com/id/10449802> ;
    schema:url <http://www.books24x7.com/marc.asp?bookid=25571> ;
    schema:url <http://www.myilibrary.com?id=123675> ;
    schema:url <http://proquest.tech.safaribooksonline.de/9781847193315> ;
    schema:workExample <http://worldcat.org/isbn/9781281236753> ;
    schema:workExample <http://worldcat.org/isbn/9781847193315> ;
    schema:workExample <http://worldcat.org/isbn/9781847193322> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/263352458> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/801526980#CreativeWork/microsoft_visual_studio> # Microsoft Visual studio.
    a schema:CreativeWork ;
    schema:name "Microsoft Visual studio." ;
    .

<http://experiment.worldcat.org/entity/work/data/801526980#Person/narayanaswamy_anand> # Anand Narayanaswamy
    a schema:Person ;
    schema:familyName "Narayanaswamy" ;
    schema:givenName "Anand" ;
    schema:name "Anand Narayanaswamy" ;
    .

<http://experiment.worldcat.org/entity/work/data/801526980#Place/birmingham_u_k> # Birmingham, U.K.
    a schema:Place ;
    schema:name "Birmingham, U.K." ;
    .

<http://experiment.worldcat.org/entity/work/data/801526980#Series/from_technologies_to_solutions> # From technologies to solutions.
    a bgn:PublicationSeries ;
    schema:hasPart <http://www.worldcat.org/oclc/263352458> ; # SQL Server integration services using Visual Studio 2005 : a beginners guide
    schema:name "From technologies to solutions." ;
    schema:name "From technologies to solutions" ;
    .

<http://experiment.worldcat.org/entity/work/data/801526980#Topic/computers_data_processing> # COMPUTERS--Data Processing
    a schema:Intangible ;
    schema:name "COMPUTERS--Data Processing"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/801526980#Topic/relational_databases> # Relational databases
    a schema:Intangible ;
    schema:name "Relational databases"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/801526980#Topic/sql_computer_program_language> # SQL (Computer program language)
    a schema:Intangible ;
    schema:name "SQL (Computer program language)"@en ;
    .

<http://id.worldcat.org/fast/1376937> # SQL server.
    a schema:CreativeWork ;
    schema:name "SQL server." ;
    .

<http://id.worldcat.org/fast/1389599> # Microsoft Visual studio.
    a schema:CreativeWork ;
    schema:name "Microsoft Visual studio." ;
    .

<http://id.worldcat.org/fast/864205> # Client/server computing
    a schema:Intangible ;
    schema:name "Client/server computing"@en ;
    .

<http://id.worldcat.org/fast/888037> # Database management
    a schema:Intangible ;
    schema:name "Database management"@en ;
    .

<http://viaf.org/viaf/255003180> # Jayaram Krishnaswamy
    a schema:Person ;
    schema:familyName "Krishnaswamy" ;
    schema:givenName "Jayaram" ;
    schema:name "Jayaram Krishnaswamy" ;
    .

<http://worldcat.org/isbn/9781281236753>
    a schema:ProductModel ;
    schema:isbn "1281236756" ;
    schema:isbn "9781281236753" ;
    .

<http://worldcat.org/isbn/9781847193315>
    a schema:ProductModel ;
    schema:isbn "1847193315" ;
    schema:isbn "9781847193315" ;
    .

<http://worldcat.org/isbn/9781847193322>
    a schema:ProductModel ;
    schema:isbn "1847193323" ;
    schema:isbn "9781847193322" ;
    .

<http://www.worldcat.org/oclc/220914329>
    a schema:CreativeWork ;
    rdfs:label "SQL server integration services using Visual Studio 2005." ;
    schema:description "Print version:" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/263352458> ; # SQL Server integration services using Visual Studio 2005 : a beginners guide
    .

<http://www.worldcat.org/title/-/oclc/263352458>
    a genont:InformationResource, genont:ContentTypeGenericResource ;
    schema:about <http://www.worldcat.org/oclc/263352458> ; # SQL Server integration services using Visual Studio 2005 : a beginners guide
    schema:dateModified "2017-12-28" ;
    void:inDataset <http://purl.oclc.org/dataset/WorldCat> ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.