SQL Server Performance Forum – Threads Archive
another import/export problem
In SQL2000, when I do import/export, there is DBaseV in the destination. InSQL 2005, there is such selection. How can I make DBaseV export in SQL 2005?
Thanks.
Sorry. I mean there is no such selection in SQL 2005.
i am not sure why they have removed this… but one workaround for this is export to excel document from SQL Server and then use Excel SaveAs to create foxpro table. This is just a workaround… Madhu
SSIS comes into picture, to decline usage of DTS MS discontinued this. Refer tohttp://msdn2.microsoft.com/en-us/library/aa337084.aspx
quote:
You can connect to a dBASE or other .DBF database file in an Integration Services package by using an OLE DB connection manager and selecting the Microsoft OLE DB Provider for Jet 4.0.
You can connect to a dBASE or other .DBF database file in an Integration Services package by using an OLE DB connection manager and selecting the Microsoft OLE DB Provider for Jet 4.0.
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>