Solved

SSIS - Dbase file to SQL 2008 Table

Posted on 2011-03-07
4
140 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 500 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

828 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