CodePartners - Software Development - Dallas, Texas Software Development - Sage Accpac Customization - SageCRM Customization
Login
pay invoice online  |  remote assistance  |  
  • INTERNET APPLICATION DEVELOPMENT

    • Services
      • Web Application Development
      • Mobile Applications
      • Integration Solutions
      • Staff Augmentation
    • Technologies
    • How we work
    • About us
    • Success stories
    • Blog
  • MID MARKET ERP DEVELOPMENT

    • Intacct
    • Sage CRM
    • Sage
    • Sage Component Catalog
    • How We Work
    • About Us
    • Success Stories
    • Blog

Blog

CodePartners Blog

rss


Export Data with SSIS, Part 2

SHARE THIS
Facebook twitter linkedin Print Print
Print Email

by Sheila Zhang

In a previous blog, I started explaining how to perform complex data transfers. When you need to manipulate the source data much to fit the destination -- such as the ETL process (extract – transform – load) -- you can use SSDT (SQL Server Data Tool) to develop a SSIS solution.

The development language of SSIS is different from other development languages that need you to type multiple lines of codes. In most cases, you create a virtual diagram with a WYSIWYG (What You See Is What You Get) editor. The diagram displays your operating flow. At each step, you configure the conditions that allow the step to process.

Follow these steps to create a new SSIS project with SSDT (SQL Server Data Tool). SSDT is a special version of Visual Studio.

  1. Create a new project in Visual Studio 2010.
  2. Under Installed Templates, select Integration Services -> Integration Services Project.
  3. Given the name to the new project, and then click OK.

 

Once you create the project, you can see the flow controls in SSIS Toolbox on the left.

Simply drag a control and drop it on the Control Flow panel. To duplicate the import/export wizard, you simply drag a data flow task to control flaw panel.

And then add a source control and a destination control to data flow panel.

The source’s configuration can be a database table.

 

To configure destination file, you need to complete two settings:

1.       File location, and format and columns:

 

2.       Next, map the fields between the source data table and destination file.

 

Now, you can run the package. A green check mark shows successful operations. If you see a red X mark on some steps, that means the step failed.

 

This is a very simple SSIS package.  This might give you an idea how complex a process can be.

Here is how to visualize it.

 




Comments are closed.
On April 23, 2014 in Development [Post:by]
Tagged With: export data, SSDT, SQL server, visual studio / 2687 Views

Search

Categories

  • General (166) rss
  • Development (158) rss
  • Success Stories (40) rss
  • Products (29) rss
  • Uncategorized (18) rss
  • BTerrell Group (5) rss
  • Project Management (22) rss
  • Web Development (57) rss
  • Web application (33) rss
  • Integration (19) rss
  • Mobile Development (7) rss

Archives

  • 2015
    • January (5)
    • February (7)
    • March (6)
    • April (5)
    • May (2)
  • 2014
    • January (13)
    • February (12)
    • March (13)
    • April (12)
    • May (11)
    • June (12)
    • July (11)
    • August (13)
    • September (10)
    • October (8)
    • November (6)
    • December (4)
  • 2013
    • April (73)
    • May (22)
    • June (20)
    • July (20)
    • August (22)
    • September (19)
    • October (13)
    • November (12)
    • December (7)

Tags

.NET Accpac app development application customization application development automation Azure C# cloud components Crystal Reports customization development ERP general ledger HTML5 Intacct Intacct Platform Services integration JQuery load balancer mass update mobile development OCR Order Entry outsourcing PO pricing product development project management REST Sage 300 ERP Sage CRM software integration trigger user interface Visual Studio web application web development website development Workforce Go! .NET ACA accpac Ajax Amazon AP invoices application development Arxis ASP.NET automation Axure BTerrell Group C# Cloud computing CodePartners Constant Contact credit card processing CRM crystal reports custom software Customer Service Customization Delete team project design phase Development doc-link DRILLDWNLK ERP event Excel GLAFS Intacct Intacct Advantage Intacct Platform Services Integration Java script JavaScript jQuery Kerr Consulting LinkedIn Microsoft MSSQL Offshoring outsourcing payroll PCI compliance PCI-DSS Pivot PJC project management sage Sage 300 Sage 300 ERP Sage Accpac ERP Sage CRM Smart Rule social media software testing SQL SQL Query SQL Server staff augmentation sub-ledger success success story TFS Trouble shooting UI design Visual Studio WCF Web API web application web design web development Webinar website Windows Windows Azure XML
Email this article from Codepartners.com
Separate multiple addresses with commas(,)
To: *   Copy me
Subject:
From: *
Message:
ABOUT US / CONTACT US / NEWS & EVENTS
CodePartners / 17250 Dallas Parkway, Ste. 225 / Dallas, Texas 75248 / Phone: 214-647-2611 / Toll Free: 866-647-2611 / Fax: 214-647-2612 / info@codepartners.com
© 2006 - 2015 codepartners.com All Rights Reserved.