How can I schedule a DTS Package on Enterprise Manager. I've created a package from the Import Wizard and have modified some code so that it checks for the existence of a table. Now I want to execute it everyday at a certain time. I don't have much idea about this as all this I'm doing the very...
Hi,
I have a DTS Package in which I import data from ORACLE server into the SQL Server every night. The Problem is that everytime it tries to create a new table it gives an error because I saved my import procedure through the wizard. But can I do something so that this checks for the existence...
I want to count the number of records present in a table. So, for that I gave the statement as :
qosSql = "SELECT * From tblMonthlySub"
qosRs.Open qosSql, qosConn, 3, 3, 1
MsgBox (qosRs.RecordCount)
although there are more than 300 records present in the table but...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.