January 13, 2023

MC TNT Header dots fade with byline 2017 06 01 l r

Lead Article - Programming

TechTip: Data Source Base Project, Part 2

In Part 2 we look at creating our data source SSIS base package.  Click here to review Part 1.

By Tom Snyder

Editor’s Note: This article is excerpted from chapter 5 of Extract, Transform, and Load with SQL Server Integration Services--with Microsoft SQL Server, Oracle, and IBM DB2, by Thomas Snyder and Vedish Shah.

Finally! We have installed all our software and set up our databases. Now we can start creating our SSIS packages. We will be completing this chapter by creating a new SSIS package that will contain our data sources and could be reused as the starting point for any new SSIS packages. We will walk through the creation to support the project overview; however, now is a great opportunity for you to custom-tailor your data sources so they fit your intended environment setup.

Featured White Paper

Why Migrate When You Can Modernize?

The Modernization Dilemma: Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production.

By LANSA, An Idera, Inc. Company

Editor's Note: This article is excerpted from the white paper, Why Migrate When You Can Modernize? available for download in the MC Press White Paper Center.

Your IBM i developers are approaching retirement and you see no sure way to fill their positions with experienced developers. Young developers have not heard of the IBM i, RPG or COBOL; and they prefer languages they know.

If you’ve experienced one or more of these pain points, you may also be caught between maintaining your existing applications and the uncertainty of moving to something new.

Webcast Learning

   LANSA

 

Supply Chain is becoming increasingly complex and unpredictable. From raw materials for manufacturing to food supply chains, the journey from source to production to delivery to consumers is marred with inefficiencies, manual processes, shortages, recalls, counterfeits, and scandals.

In this webinar, we discuss how:

  • Low-Code facilitates the development of Supply Chain Collaborative Portals.
  • Value Chain integration enhances visibility, timeliness, and consistency.
  • New technologies help modernize and expand ERP and Legacy Platform support.

 

Watch Now.
White Paper Download

   Profound Logic

 

More than ever, there is a demand for IT to deliver innovation.

Your IBM i has been an essential part of your business operations for years. However, your organization may struggle to maintain the current system and implement new projects.

The thousands of customers we've worked with and surveyed state that expectations regarding the digital footprint and vision of the company are not aligned with the current IT environment.

Get your copy of this important guide today! Download your copy today!
Application Dev

Operating Systems

Database

Programming

Management & Career

System Administration

Featured News

IBM Launches New Way to Partner Through IBM Partner Plus

Offers Enhanced Incentives, Access and Support to Help New and Existing Partners Win with Clients

By IBM Corporation

IBM today announced IBM Partner Plus, a new program that reimagines how IBM engages with its business partners through unprecedented access to IBM resources, incentives and tailored support to deepen their technical expertise and help speed time to market. The program is designed to fuel growth for new and existing partners, including resellers, hyperscalers, technology providers, independent software vendors and systems integrators, by putting them in control of their earning potential. IBM Partner Plus is central to the company's Hybrid Cloud and AI strategy and aims to empower partners to help clients automate, secure and modernize their businesses.

Upcoming Events
MC Press Bookstore