Fail when execute DTS package

  • Hi all,

    I have a DTS package to be execute from my program. all along this program always work fine. But I just face a problem yesterday that it keep giving me an error. the err message is something like "Cannot find server or access denied". What i have done is I test the connection use the odbc & query analyzer to connect to the same sever and the same login & password and its ok... looks like no problem with the connection, i don't understand why i keep facing this error. Need yr help 😉

    Thx

  • Please do not crosspost. Duplicate message, please see post/replies in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=6517&FORUM_ID=6&CAT_ID=1&Topic_Title=Fail+when+execute+DTS+package&Forum_Title=Security

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • Sorry, because i confused which category it should be

  • It happens, posting once pretty much will guarantee a view of it as mos folks use the Active Threads item to view the discussion board (at least I do).

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

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

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