Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
svicky9
Posting Yak Master
232 Posts |
 Posted - 2005-08-09 : 15:30:13
|
| Hi guys How to convert flat files systems to relational Databases.can DTS do that.We are presently using a flat file system called Cardbox(www.cardbox.com)I want to import the files from cardbox to Sql server...is it possible.Thank youVicky |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-08-09 : 15:34:59
|
| Looks like it stores images and the like.Do you see the menu item where it says exchange?You'll neeed to look that up, or find a way to export all the data.Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-09 : 15:35:29
|
| Yes DTS can import the data into a SQL Server database, but that doesn't necessarily make it relational.Tara |
|
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2005-08-09 : 15:44:10
|
| thank youThere is an option import and export to CSV filesFrom there its easyVicVicky |
|
|
|
|
|
|
Flat files to Relational Databases