<div>
how can &nbsp;i do the error handling ?
</div>


<div>
i want to grade for the efforts
</div>


<div>
<div class="content wysiwyg-content">
i experts<br />
i have just started using SSIS.I am new in SSIS<br />
<br />
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.<br />
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<br />
web application are different and also the column name are different.<br />
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.<br />
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?<br />
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<br />
<br />
So i need detail steps to proceed.Any help is highly appreciated
</div>
</div>


i 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

Creating SSIS Package

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.