Tuesday, December 9, 2014

Things you learn hands-on in my SQL Server Integration Services book

With over 24 hands-on exercises this book covers,
  • A detailed explanation of designing over 20 important SSIS tasks using hands-on examples.
  • Use of Visual Studio 2005's IDE as related to SSIS development.
  • Working with single and multiple tasks; working with more than 20 different tasks.
  • Connecting to Microsoft Access, Flat Files, Excel Spread Sheets, and third party vendor products such as Oracle.
  • Linking data source and data destination to a task.
  • Learn sending emails and understand FTPing with SSIS.
  • Transform data from a source going to a destination.
  • Using the scripting support provided by the IDE.
  • Learn tasks such as web service and XML new in SQL Server 2005.
  • Monitor the data as it is being transported, also new in SQL Server 2005
  • Understand event bubbling and Learn to handle events

  • Packed with over 24 hands-on examples; no experience of SQL Server Integration Services required. Knowledge of DTS helpful but not essential.

    PowerShell Pro Tools is a Visual Studio Community 2017 extension that you can try free

    I see there is at least one extension, PowerShell Pro Tools that you can download. You can find it in the Visual Studio Community 2017...