Fail when execute DTS package

Question

Fail when execute DTS package

sindchg

SSC Journeyman

Points: 81
More actions
August 30, 2002 at 2:25 am

#79567

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

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

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

Antares686 SSC Guru Points: 125444 More actions · Answer 1

Where is the program running, is it on the server or at a workstation? If the later have you tried running the DTS package thru EM and verify the issue that way, the reason is DTS will execute local to the machine that fires it (under normal circumstances, there are ways around), an thus that machines configuration may be the key.

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

sindchg SSC Journeyman Points: 81 More actions · Answer 2

My program is running on the server side. I've tried to execute the DTS package and it works, only when i run this ***moPackage.LoadFromSQLServer "LSC", "sa", "",,,,,"BRP2MS"*** Vb Script it will give me error. I think its because something wrong with the security setting in the Sql server.

Antares686 SSC Guru Points: 125444 More actions · Answer 3

Not sure, can you post the VBScript making sure o remove security info. I need to see how you got to this poitn and what may be missing. Maybe Andy Warren will see this and have a bit to add as this seems to be up his alley more so than mine.

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

sindchg SSC Journeyman Points: 81 More actions · Answer 4

I manage to fix this problem by changing the computer name... ?????....but i still don;t know why it happened...initially the computer name is 'OFFICE'...whats wrong with "OFFICE" ?...I already install in other PC with the same computer name "OFFICE" and its ok...only this one can not.