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 |
|
1fred
Posting Yak Master
158 Posts |
 Posted - 2002-11-18 : 13:18:11
|
| My online web site is running on MySQL, every day I want to get the new data to my Staging Area on MS SQL Server 2000. I am building a DTS to get this new data. In a "sql task" I select the Max ID from my table and use this value as a parameter. I a second task I am making a query like this on the MySQL datasource :"select * from Table where ID > ?" to transfer only the data from the last day in a "transform data Task". In my "transform Data task" when I type that query and choose parameters I have the following message :"The SQL statement does not contain any parameters". Anybody got this problem before, and, is Parameters only usable from MS server to MS server? My parameter value is ok, but I can't use it in my "transfer data task"Thanks |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-11-18 : 14:01:37
|
| TrySelect * from Table where [ID] > ?ID is a reserved word it might be causing a problem. |
 |
|
|
1fred
Posting Yak Master
158 Posts |
Posted - 2002-11-18 : 14:26:27
|
| The name of my key is [sent_key], I just wrote ID as an example, but putting the[] is not working. |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-11-18 : 15:03:29
|
| Can you link the two servers and write a stored procedure in the sql server that gets called from the dts package. This way your passing the parameters to sql server.EXECUTE mystoredproc ?Edited by - ValterBorges on 11/18/2002 15:05:09 |
|
|
|
1fred
Posting Yak Master
158 Posts |
Posted - 2002-11-18 : 16:32:48
|
| I don't know why, but there have been a few tread in this forum about Mysql as a linked server, I can see my table, but can't query them. Looks like a catalog problem.... Maybe I'll do something in php |
|
|
|
|
|
|
DTS Parameters