DTS Odbc Error

  • I have a DTS package that runs just fine, but when i try to open the properties of thr data transformation task, i get the error message:

    Error source: ODBC Providers for for ODBC Driver

    Datasource name not found, no default driver found.

     

     

    [font="Comic Sans MS"][/font]It is what it is.

  • This was removed by the editor as SPAM

  • Lara,

    I have seen similar behavior when the package has been created on one machine, but gives you the error when opening properties on another.

    Example...

    You create a package with a specific DSN ( or source file etc), sav e and execute the package. All is well. Now go to a different machine that has access to that SQL Server and access the properties.....You will probably get that error IF a DSN of the same name does NOT exist on your current machine.

  • Thanks a lot.

    i found it weird too. especially since, whne you remote the box the server is sitting on and you open enterprise manager , you can see the dts package , to design view and all is well,

    the error only occurs when you try to open the dts via em, from the programmer's machine

    [font="Comic Sans MS"][/font]It is what it is.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply