Guidance

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roy - 04 Jul 2005 04:48 GMT

I have a scanario like I want to push the data from SQL Server to dBase and
dBase to SQL Server but the problem is that dBase database is on the
different machine so can any body tell me before making the DTS Package what
inforamtion I need ?

Thanks

Reply to this Message

Mike Epprecht (SQL MVP) - 04 Jul 2005 12:33 GMT

Hi

Since dBase is addressed with a file path, the SQL Server and Agent account
need to be running under an account that has permissions on the file and
share on the destination server.
You need to approprioate driver on the SQL Server for dBase

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

> I have a scanario like I want to push the data from SQL Server to dBase and
> dBase to SQL Server but the problem is that dBase database is on the
> different machine so can any body tell me before making the DTS Package what
> inforamtion I need ?
>
> Thanks

Reply to this Message

Roy - 06 Jul 2005 04:17 GMT

Thanks

> Hi
>
[quoted text clipped - 18 lines]
> >
> > Thanks

Reply to this Message