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

sqlcuriousAsked:
Who is Participating?
 
Darran BrownConnect With a Mentor DBACommented:
Hi
The best way to do this is using the wizard to create the package for you.
Using SQL Server Management Studio, right click the database and right click. Choose TASKS - Export Data.
Select the database and table(s) on the source page, click next.
Select Excel and a place for the spreadsheet on the destination page, click next.
On the next page you can click the "Edit Mappings" button to change any column names in the destination if neeed.
On the final page you can save as an SSIS package aswell as running.

To go from Excel to Database right click new database and choose Tasks - Import data and do the same, selecting the spreadsheet as the source.

Hope it helps
0
 
sqlcuriousAuthor Commented:
Actually i wanted to do it using BIDS .how can i do it using BIDS? Cant i implement looping and do it?i need to do some error handling in SSIS too?please clarify
0
 
sqlcuriousAuthor Commented:
i need to put the data from three databases into one excel sheet right ? since web application uses only one database
0
 
sqlcuriousAuthor Commented:
i dd not get the answer that i want.So i will post this question again so that more experts can give their suggestions
0
All Courses

From novice to tech pro — start learning today.