June 4, 2010 at 11:03 am
Hello all,
I'm using the Advantage ADO.NET provider to query an advantage file and load some data in a SQL DB. I want to get the last 90 days of data. This will be running daily. Problem is the datareader task in data flow doesn't let you use parameters which is what I was gonig to use to feed the date into the selest statement. The datareader task also doesn't have an expression property where you can define your SQL statement either on the fly either.
Since it doesn't have these things I'm thinking I'd just use DateAdd and GetDate in my the sql window in the datareader task. Unfortunately this doesn't work either as these fuctions do not exist in the Advantage ADO.NET provider.
Does anyone know if there is a way to use parameters in the data reader task? Or is there some alternative method I can use?
All I want to do is something like: Select MyField From MyTable where MyDate = ?
Thanks,
Strick
June 4, 2010 at 12:17 pm
First, I have never used this provider so I admit up-front I am grasping..
No parameters or expressions.. Ok, Does it have an option to accept the query command from a variable like the built-in OLEDB source (Data Access Method: SQL Command From Variable)?
Do you connect directly to the file or is there a server, a quick google search indicated there might be a server. If you are connecting to the file I would say if you don't have a way to change the command at run-time you are screwed because providers don't run commands like GETDATE or DATEADD, those are handled by the DB engine. If you are connecting to a server you might just have to find its syntax for saying today - 90 days.
Sorry I can't be more help..
CEWII
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply