• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • Last Modified:

Creating SSIS Package

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
0
sqlcurious
Asked:
sqlcurious
  • 2
1 Solution
 
lcohanDatabase AnalystCommented:
Why would you export data out into Excel and then back into SQL? Why not transfer existing tables from multiple Servers.Databases into one Server.Dabatase and start from there with your web app. You can leave all your source data untouched this way and alter the tables including data in your target database to be used by your web app. You can do this from SQL by right click a Database name in SSMS, select Export Data or Import Data from Tasks then you can easily walk through the SSIS wizzrad that pops up.
0
 
sqlcuriousAuthor Commented:
how can  i do the error handling ?
0
 
sqlcuriousAuthor Commented:
i want to grade for the efforts
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now