SQL 7 schedule package failed

[joesng]

I am new to SQL. I am trying to schedule an existing package, and I could figure out why I am getting this error message.

Microsoft SQL-DMO (ODBC SQLState:42000)
Microsoft][ODBC sql server driver][sql server]login failed for user'(null)'. reason: not associated with a trusted SQL server connection.

Can somebody help?

 

[bev]

This is almost certainly due to the stored procedure being "owned" by TheAdministrator rather than by a SQL User with admin rights.
Bev

 

[joesng]

Really appreciate the quick respond.
What this is, is a about 50 DTS package that I've created to pull data from Foxpro/Netware into SQL 7. So the owner for this DTS package is "domain/administrator", so what can I do to change the ownership of this package without risking the 50 packages? Any books that you can recommend for a new user like me?

 

[tlbroadbent]

Check the SQLDTS website for info on changing a package owner.

http://www.sqldts.com/main.asp?nav=1,6,212,0

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.