SQL Server Performance Forum – Threads Archive

Automation of DTS?

I am wondering whether it is possible to automate the DTS activities by a job schedule.If possible then pls explain.

you can schedule the DTS from the DTS wizard

The thing is that I dont want all the row from the source table only newly insered row(hourly basis) should be transfered to the dest table.How to achive this

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50316 has used linked server
checked this

Yes that a good post.How Can I create a linked server ;for MY SQL server linked with MS SQL server.

http://www.eggheadcafe.com/ng/microsoft.public.sqlserver.connect/post21256021.asp

I added a link MYSQL server to MSSQL server by using sp_addlinkedserver.But when I clicked the tree view of linked server I can see only 2 objects there table and view.When I further clicked on table I cant see any table,though I had 2 tables in my mssql db.Where I am wrong.
Here is what I have done.
sp_addlinkedserver @server = ‘ip pf MSSQLserver’, @srvproduct = ‘MSDASQL’,@provider = ‘MSDASQL’, @datasrc =’dMSSQLData’,@location = ‘ip of MYSQL server’,@provstr = ‘Driver={MySQL ODBC 3.51 Driver}’ ,@catalog =’tbl_test’
I guess I am placing wrong value for @datasrc.
Please help to fix this issue

How about the login used to connect to Mysql database, ensure the login has required privileges. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Here is what I had done to login to linked server.
sp_addlinkedsrvlogin @rmtsrvname = ‘ip of MYSQL server’, @useself = ‘false’ , @locallogin = ‘sa’ , @rmtuser = ‘root’ , @rmtpassword = ‘u8h^4’

I am wondering where I am wrong

Create a ODBC DSN using MySQL drivers and set up your linked server to use this DSN instead.

How to accomplish this task"Create a ODBC DSN using MySQL drivers "

Here is the error what I got after clicking on the tree view of linked server to see the tables.<br />Error 7399<img src=’/community/emoticons/emotion-3.gif’ alt=’:O’ />LEDB PROVIDER’MSDASQL’ reported an error.The provider did not give any information about the error.OLE DB error trace[OLE/DB provider ‘MSDASQL’ IDBInitilize ::Initialize returned 0x80004005: The provider did not give any information about the error.]

check Creating MySQL ODBC Data Source section of http://webappguru.net/articles/phpmyadmin_instructions.html

I tried using dsn but still after creation of linked server I got the same error<br />Error 7399<img src=’/community/emoticons/emotion-3.gif’ alt=’:O’ />LEDB PROVIDER’MSDASQL’ reported an error.The provider did not give any information about the error.OLE DB error trace[OLE/DB provider ‘MSDASQL’ IDBInitilize ::Initialize returned 0x80004005: The provider did not give any information about the error.]

Can any one please try to make a MYSQL link server and chect whether they are also facing same problem.MYSQL is free and can be downloaded fromhttp://dev.mysql.com/downloads/.Please test and inform me.Any kind of contribution for this post is highly appreciable.

]]>