Package doest connect with any other external machine. Well I created package directly login on windows server, then from that I open sql server 2000 and went to DTS and...

I am executing theourgh DTS degin tool. Even if I run the job that created by package will give me the same error.

But everything is fine on windows auth.

this sql account has sysadmin previlege

I get an error when I try to execute

If i execute through windows auth it succeeds, but if I try to execute thorugh sql auth it fails.

thank you

thanks for the information but what do u mean by "user account has the proper share level and NTFS permissions for both locations".

thank you

sql service is running under local system account

thanks for the information, can you expain me in some detail how do i run the query with execution plan enabled.

thank you

thanks for the information, is thier anyway in sql 7.0 to identify which indexes should be dropped, one of my table have 11 indexes, and I am having issues...

I went to sql server log configuration and put the maximum error files upto 6. But my question is how to make smaller size of error log files, because my...

where do i check that in EM, i couldnt locate.

well my question is, how to generate multiple sql error log automatically. Everytime I do have a current error log, there are no archaieve logs. And my current error...

do you mean that i need to run this extended procedure to overcome this issue.

thanks that proc really helped me.

I haven't tried this one, well this is a prod server and I am thinking to start manually during off hour. Well I found in sql error log that "sql...