?
Solved

SSIS packages

Posted on 2011-03-14
4
Medium Priority
?
362 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 1500 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

777 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