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 |
|
avinashs
Starting Member
1 Post |
 Posted - 2013-05-06 : 23:59:35
|
| i would like to pass parameters to a mysql query using ado.net as the source of the query. SELECT * FROM userinfo where load_date > '2012-01-07' and load_date < '2012-01-14'i have a settings table in sql server that has my values select startdate , enddate from tblsettingi have managed to pass this values into ssis and if i ran a query against my sql server tables i am able to use this SELECT * FROM userinfo where load_date > ? and load_date < ?but when i change my source to ado.net connecting to mysql server , it does not like that syntaxplease advise what am i missing thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-07 : 00:15:25
|
| whats the error its throwing? is it a syntax error?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
ssis passing vaiables to ado.net source