Start Free TrialLog in
Avatar of groundhogday21
groundhogday21

asked on 

SSIS ETL package

I need an example of how to design a SSIS ETL package to extract data from a table and split it into multiple tables within the same database.
Microsoft SQL Server
Avatar of undefined
Last Comment
Steve Hogg
Avatar of Steve Hogg
Steve Hogg
Flag of United States of America image
Use the Multicast Transform to create multiple copeis of your Source Data. Then create as many Destination Connections as you want to receive the input. This lets you send different columns on the same row to different destination tables. Does that help?
Avatar of Steve Hogg
Steve Hogg
Flag of United States of America image
If you need to send the row of data from the source to a destination table based on conditions, use the Conditional Split transformation.
Avatar of PedroCGD
PedroCGD
Flag of Portugal image
Dear Friend,
I wrote a post in my blog about it...
Tell me more doubts you have to help you in detail.
regards!
Pedro

www.pedrocgd.blogspot.com
Avatar of groundhogday21
groundhogday21

ASKER

Thanks for the suggestions.  I have used DTS but relatively new  to SSIS.  If I had existing SSIS packages to work with, I would be able to modify as needed.  I am working from scratch and don't have much time since everything has to be done yesterday, so I am looking for quick examples I can use or download to modify.  Thanks in advance.
Avatar of PedroCGD
PedroCGD
Flag of Portugal image
OK.. give me the schema of your SQL Table and I make an SSIS Package example for you spliting it into several tables.
Ok?
Regards,
Pedro
ASKER CERTIFIED SOLUTION
Avatar of Steve Hogg
Steve Hogg
Flag of United States of America image
Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Microsoft SQL Server
Microsoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts

  • "Invaluable tool for our organization"

    Josh Regalski

  • "Your help has saved me hundreds of hours of internet surfing."

    @fblack61

  • "Just a dang good service!"

    @golferski

  • "Worth every penny."

    Steve Hougom

  • "It’s been a life saver."

    Maria Halt

  • "Best support site I’ve seen!"

    Bob Schneider

  • "I would be lost without them."

    @fblack61

  • "Saved my job multiple times."

    Walt Forbes

  • "I love this site."

    Maria Duwe

  • "Friendly respectful help."

    Andrew Kowtalo

  • "Such top-notch experts."

    @magento

  • "The best money I have ever spent."

    @rwheeler23

  • "Beyond any comprehensible value"

    George Morris

  • "Invaluable tool for our organization"

    Josh Regalski

Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo
© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent