SQL Server integration services using Visual Studio 2005 : a beginners guide /
Saved in:
Author / Creator: | Krishnaswamy, Jayaram. |
---|---|
Imprint: | Birmingham, U.K. : Packt Pub., ©2007. |
Description: | 1 online resource (vii, 301 pages) : illustrations |
Language: | English |
Series: | From technologies to solutions From technologies to solutions. |
Subject: | |
Format: | E-Resource Book |
URL for this record: | http://pi.lib.uchicago.edu/1001/cat/bib/11179197 |
MARC
LEADER | 00000cam a2200000Ma 4500 | ||
---|---|---|---|
001 | 11179197 | ||
006 | m o d | ||
007 | cr zn||||||||| | ||
008 | 080904s2007 enka ob 001 0 eng d | ||
005 | 20240711194429.2 | ||
015 | |a GBB747495 |2 bnb | ||
016 | 7 | |a 018011517 |2 Uk | |
019 | |a 427868194 |a 614436669 |a 715160029 |a 743196424 |a 765143009 |a 804665472 |a 815556213 |a 823112846 |a 1058078241 |a 1103280158 | ||
020 | |a 9781847193322 |q (electronic bk.) | ||
020 | |a 1847193323 |q (electronic bk.) | ||
020 | |a 1847193315 | ||
020 | |a 9781847193315 | ||
020 | |a 1281236756 | ||
020 | |a 9781281236753 | ||
020 | |z 9781847193315 | ||
035 | |a (OCoLC)263352458 |z (OCoLC)427868194 |z (OCoLC)614436669 |z (OCoLC)715160029 |z (OCoLC)743196424 |z (OCoLC)765143009 |z (OCoLC)804665472 |z (OCoLC)815556213 |z (OCoLC)823112846 |z (OCoLC)1058078241 |z (OCoLC)1103280158 | ||
035 | 9 | |a (OCLCCM-CC)263352458 | |
037 | |a CL0500000067 |b Safari Books Online | ||
040 | |a NUI |b eng |e pn |c NUI |d N$T |d UMI |d IDEBK |d CEF |d OCLCQ |d E7B |d OCLCQ |d B24X7 |d DEBSZ |d OCLCQ |d OCLCF |d OCLCQ |d YDXCP |d EBLCP |d OCLCQ |d COO |d AGLDB |d LIV |d OCLCQ |d MERUC |d OCLCQ |d OCLCO |d REB |d VTS |d NLE |d AU@ |d OCLCQ |d OCLCO |d UKMGB |d STF |d M8D |d UKAHL |d VT2 |d OCLCQ |d OCLCO |d BRF | ||
049 | |a MAIN | ||
050 | 4 | |a QA76.9.D3 |b K75 2007eb | |
072 | 7 | |a COM |x 018000 |2 bisacsh | |
100 | 1 | |a Krishnaswamy, Jayaram. | |
245 | 1 | 0 | |a SQL Server integration services using Visual Studio 2005 : |b a beginners guide / |c Jayaram Krishnaswamy ; reviewer, Anand Narayanaswamy. |
260 | |a Birmingham, U.K. : |b Packt Pub., |c ©2007. | ||
300 | |a 1 online resource (vii, 301 pages) : |b illustrations | ||
336 | |a text |b txt |2 rdacontent | ||
337 | |a computer |b c |2 rdamedia | ||
338 | |a online resource |b cr |2 rdacarrier | ||
490 | 1 | |a From technologies to solutions | |
500 | |a Title from title screen. | ||
504 | |a Includes bibliographical references and index. | ||
520 | |a Explains how to program and maintain databases and client-server systems using SQL to retrieve data and control operations. | ||
505 | 0 | |a 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. | |
505 | 8 | |a 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. | |
505 | 8 | |a 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. | |
505 | 8 | |a 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. | |
505 | 8 | |a 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. | |
630 | 0 | 0 | |a SQL server. |0 http://id.loc.gov/authorities/names/n90684343 |
630 | 0 | 0 | |a Microsoft Visual studio. |0 http://id.loc.gov/authorities/names/n98043868 |
630 | 0 | 7 | |a Microsoft Visual studio. |2 fast |0 (OCoLC)fst01389599 |
630 | 0 | 7 | |a SQL server. |2 fast |0 (OCoLC)fst01376937 |
650 | 0 | |a Database management. |0 http://id.loc.gov/authorities/subjects/sh85035848 | |
650 | 0 | |a Client/server computing. |0 http://id.loc.gov/authorities/subjects/sh93000502 | |
650 | 7 | |a COMPUTERS |x Data Processing. |2 bisacsh | |
650 | 7 | |a SQL (Computer program language) |2 blmlsh | |
650 | 7 | |a Relational databases. |2 blmlsh | |
650 | 7 | |a Client/server computing. |2 fast |0 (OCoLC)fst00864205 | |
650 | 7 | |a Database management. |2 fast |0 (OCoLC)fst00888037 | |
655 | 0 | |a Electronic books. | |
655 | 4 | |a Electronic books. | |
700 | 1 | |a Narayanaswamy, Anand. |4 rev | |
776 | 0 | 8 | |i Print version: |a Krishnaswamy, Jayaram. |t SQL server integration services using Visual Studio 2005. |d Birmingham : Packt Pub., ©2007 |z 9781847193315 |z 1847193315 |w (OCoLC)220914329 |
830 | 0 | |a From technologies to solutions. |0 http://id.loc.gov/authorities/names/no2008038412 | |
903 | |a HeVa | ||
929 | |a oclccm | ||
999 | f | f | |i 9719ada5-01e0-5033-8af0-68903e262426 |s 2cd00230-6509-58de-bb24-0b3f6731377d |
928 | |t Library of Congress classification |a QA76.9.D3 K75 2007eb |l Online |c UC-FullText |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e000xna&AN=265390 |z eBooks on EBSCOhost |g ebooks |i 12259155 |