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 |
|
akuniyoshi
Starting Member
2 Posts |
 Posted - 2002-12-04 : 12:21:30
|
| Hello again, Now, I have other problem: I want to import some dbf (foxpro) files to SQL Server 2000 and I want to choose the rows that are inside a specific date range. To do this, I'm using, inside the DTS, the Transformation Data Task. I chose the Other ODBC Connection and, if I wouldn't put the date field in the criteria, everything is fine. If I put, a error occurs. I use the following query : Select number, emission from NFWHERE (emission = { d getdate()-60})and I receive the following error: [Microsoft] [ODBC Visual Fox Pro Driver] Syntax error or access violation.Somebody could help me? Thanks, Adriana |
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2002-12-04 : 12:32:02
|
| I believe this *might* be a permission violation. Not sure on how FoxPro works, but you will probably need to give the appropiate permissions to the MSDTC account in order to access the DBF file.***************************************Death must absolutely come to enemies of the code! |
 |
|
|
scootermcfly
Yak Posting Veteran
66 Posts |
Posted - 2002-12-05 : 08:53:13
|
| You need to make sure that the query is valid for FoxPro, not SQL Server.The date funciton in FoxPro is date(), so your query would be:Select number, emission from NF WHERE (emission = (date()-60))Hope that helps,Scooter McFly |
|
|
|
|
|
|
|
|
Importing DBF Files