Solved

SSIS packages

Posted on 2011-03-14
4
355 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:
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql join/ assign small # first 10 81
Merge Statement 3 39
Restrict result set 1 34
Getting same value for every field in SQL 2 21
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
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.

914 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

17 Experts available now in Live!

Get 1:1 Help Now