SSIS using BI - 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

SQL Server 2008 Forums

SSIS and Import/Export (2008)

SSIS using BI

Author

Topic

pradeep_21
Starting Member

9 Posts

Posted - 2012-04-25 : 08:19:23

HI folks,

Im totally new in SSIS, how can i configure multiple database in single ssis package.

Im using Data flow task,OLEDB Source,OLEDB Destination.

If i add more than one OLEDB source and destination its getting error

scenario:

If i run this package in first time there is no issues. It was insert both destination tables. But if i did any modification in source tables after that i run the package it was appended in first destination table but not appended in 2nd destination table.

Please help me i have to implement this on live server ASAP.

Thanks
Pradeep

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2012-04-25 : 11:02:37

what is the error description?

<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-04-25 : 14:48:23

quote:
Originally posted by pradeep_21

HI folks,

Im totally new in SSIS, how can i configure multiple database in single ssis package.

Im using Data flow task,OLEDB Source,OLEDB Destination.

If i add more than one OLEDB source and destination its getting error

scenario:

If i run this package in first time there is no issues. It was insert both destination tables. But if i did any modification in source tables after that i run the package it was appended in first destination table but not appended in 2nd destination table.

Please help me i have to implement this on live server ASAP.

Thanks
Pradeep

After each change in metadata in source (add/removing columns as well as change of datatype/length precision) you need to open the data flow task and double click on source and configure the mappings again in mappings tab to include newly added columns or pick up changes. If you're not doing it, any newly added column will not transfer data to corresponding column in destination

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources