?
Solved

SSIS - Dbase file to SQL 2008 Table

Posted on 2011-03-07
4
Medium Priority
?
163 Views
Last Modified: 2013-12-20
I have a system using Dbase database. I want to convert those dbase database into microsoft SQL 2008 regularly(schedulling itself once a day ). Can you please tell me simple steps which i don't need to buy third party software? I just want data in sql server so i can use them for reporting purpose. I want to use SSIS utility.
0
Comment
Question by:AungMyat
  • 2
4 Comments
 
LVL 9

Accepted Solution

by:
kaminda earned 1500 total points
ID: 35065475
Hi,

Without importing your data to SQL Server your can query them using SQL, there are two ways either to use a LinkedServer to you dBase or use OpenRowSet.

Here you will get a good step by step explaination.

http://blog.dbase.integralwebsolutions.co.za/2008/10/accessing-dbase-tables-with-ms-sql.html 

Thanks
0
 

Author Comment

by:AungMyat
ID: 35065719
But I need to import data in sql for reporting service. there is other reason i need to have dbase data in sql table.
0
 
LVL 1

Expert Comment

by:lalitgada
ID: 35067863
try using ssis component " transfer database Task"
0
 

Author Comment

by:AungMyat
ID: 35117762
can you explain in detail how it is done.. thanks
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
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…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses

755 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