| Author |
 Topic  |
|
|
pradeep_21
Starting Member
9 Posts |
 Posted - 04/25/2012 : 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
Flowing Fount of Yak Knowledge
USA
1608 Posts |
Posted - 04/25/2012 : 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
India
47097 Posts |
Posted - 04/25/2012 : 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/
|
|
|
| |
Topic |
|
SSIS using BI
