quick SSIS question - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

quick SSIS question

Author

Topic

albertkohl
Aged Yak Warrior

740 Posts

Posted - 2010-02-25 : 11:27:56

is there any way to pump data from one OLE source, into two separate OLE sources depending on what column?

i dont think i can use a conditional split, because i'm not splitting it up by row, just by columns.

Thanks!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-02-25 : 11:31:25

what do you mean by that? can you explain?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

albertkohl
Aged Yak Warrior

740 Posts

Posted - 2010-02-25 : 11:54:15

for example... i have a SQL Table with

Firstname
Lastname
Address
City
State
Zip
Invoice
Amount
Date
ID

i wanna split the data into two separate tables, one that's just:
first
last
address
city
state
zip
ID

and another that's
invoice
amount
date
id

but i wanna try and do it with only one ole source... the table i'm splitting up is about 32 MILLION records so i dont wanna have to read data out of it twice if i dont have to.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-02-25 : 11:58:16

ok. then you could you single oledb source, then use multicast to create two copies of metadata then give one of to your one output and ignore unwanted columns and similarly for second copy take other columns and ignore first ones

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

albertkohl
Aged Yak Warrior

740 Posts

Posted - 2010-02-25 : 17:42:35

wierd... so i tie my OLE DB Source to the Multicase, and when i open the editor, it's totally blank... never used a multicast, so i'm a little lost now :(

albertkohl
Aged Yak Warrior

740 Posts

Posted - 2010-02-25 : 17:57:11

WOOHOO! i got it, that's PERFECT thanks!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-02-26 : 08:13:24

Welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources