sqlcurious
asked on
SSIS packages
Hi experts
i have just started using SSIS.I am new in SSIS
I need to do the data convertion using SSIS.I have the application based on windows that uses three databases and have altogether 50 tables.
Now the windows application is being transformed into web application that has also around 50 tables.The web application uses only one database.The table structures in the windows application and
web application are different and also the column name are different.
MY req is ,At first i need to transfer the windows data to excel by creating one package and then excel to web database by creating another package.
So how can i proceed using SSIS with three different databases in windows and different table structures in windows and web database.Do i need to transfer tables one by one?
In the mean time i need to do some error handling too.I have no idea how long will it take but i have been told that it will take me more than a week to do
So i need detail steps to proceed.Any help is highly appreciated
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i need to put the data from three databases into one excel sheet right ? since web application uses only one database
ASKER
i dd not get the answer that i want.So i will post this question again so that more experts can give their suggestions
ASKER