Solved

SSIS packages

Posted on 2011-03-14
4
361 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 2

Accepted Solution

by:
Darran Brown earned 500 total points
ID: 35129284
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
ID: 35129434
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
ID: 35129717
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
ID: 35130911
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

Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

696 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