Solved

SSIS packages

Posted on 2011-03-14
4
354 Views
Last Modified: 2012-05-11


   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

0
Comment
Question by:sqlcurious
  • 3
4 Comments
 
LVL 2

Accepted Solution

by:
Mr_B earned 500 total points
Comment Utility
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
 

Author Comment

by:sqlcurious
Comment Utility
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
 

Author Comment

by:sqlcurious
Comment Utility
i need to put the data from three databases into one excel sheet right ? since web application uses only one database
0
 

Author Closing Comment

by:sqlcurious
Comment Utility
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

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now