I have a database at mysql over a different host. In DSN connection I am
providing all necessary information to connect to that database. The
connection is verified too. Now when I do Import/Export wizard for data
import I select MySQL as my source and SQL Server as my destination table.
Now I am running this query that is working fine in sql query analyzer and
returning me the results that it should do but as soon as i implement them in
DTS query builder it doesn't like it and gives me this error "runtime error:
data provider or other service returned an E_FAIL status". I tried to some
how validates the sql syntax and then when I ran that query again it doesn't
show me the records. I am so stuck don't know what the heck is sql server
want from me. I want to do is a simple import of data using a query so that I
don't have to import all old data from the table. The query is somewhat like
this
SELECT * from sometable where startdate <= getdate() and
startdate>=dateadd(day,-1,getdate())

Please help me o' sql lord!

never mind. I found the solution. I was doing such a dumb thing.

"Imran Prasla" wrote: