SQL Server Performance

Invalid use of default parameter error

Discussion in 'SQL Server DTS-Related Questions' started by ndramkumar, Mar 27, 2006.

  1. ndramkumar New Member

    Hi all,<br /><br />I am getting the error "Invalid use of default parameter" when I run the DTS which uses VBScript language. DTS calls a package residing in another system. The destination system where the DTS is published is added as a linked server.<br /><br />What is the reason for this error.<br /><br />Here are the details of the DTS:<br /><br />1. The database connection uses the format "Driver={SQL Server};SERVER=;UID=<img src='/community/emoticons/emotion-4.gif' alt=';P' />WD=;DATABASE=" and I had set connection and command time out.<br /><br />2. Records are retrieved using recordset.open method of ADODB.<br /><br />3. For command object it is used as INSERT INTO TABLE (columns list) VALUES (?,?,?,....)<br /><br /><br />Please any body help me out in this problem asap.<br /><br />Thanks and Regards,<br />Ram Kumar N D

Share This Page