Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2009

    Exclamation Unanswered: Serious bug in DTS on SQL Server 2005

    Has anyone noticed this -

    If you use a versioned SP with some input parameters in the data transformation task of DTS on SQL Server 2005, you'll get an error while executing the package. The same DTS runs perfectly on SQL Server 2000.

    I hope everyone is familiar with versioning of a stored procedure by suffixing a semicolon and version number e.g. WP_GetDespatches;2

    Click image for larger version. 

Name:	bug.JPG 
Views:	111 
Size:	34.8 KB 
ID:	9793

    See the attached image showing the data transformation task properties. SP named WP_GetDespatches (version 2 having 2 parameters) is being called here. For some reason SQL Server 2005 finds the syntax invalid. Looks like its unhappy to see both ; and ? together whereas SQL Server 2000 has no problem with this.

    As a workaround I had to create a new stored procedure called WP_GetDespatches2 and had to use that instead like this -
    exec WP_GetDespatches2 ?,?

    Please share your ideas if you ever encountered this bug.
    Last edited by adonisaseem; 07-04-09 at 08:38.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    I've seen that problem, but it was fixed early in 2007. You need to apply service packs to both the DTS runtime and the SQL Server if you're still having that problem.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Jul 2009
    Thanks Pat Phelan for your post.

    We did apply SP3 on SQL Server 2005 but it didn't help. Which patch you applied on DTS runtime to make it work?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts