streetprog
Technical User
Can anyone give me some pointers on how to use a linked server in a DTS Package? The only thing I can see to do is to connect to the SQL Server directly but scheduling this is giving me some problems due to an error I'm getting:
Error string: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I'm using SQL Server Enterprise Manager with Window's authentication. I have a local server on my PC and I'm running a query against a network server. The DTS package works fine when I run it directly but not when I try and schedule it.
Error string: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I'm using SQL Server Enterprise Manager with Window's authentication. I have a local server on my PC and I'm running a query against a network server. The DTS package works fine when I run it directly but not when I try and schedule it.
