I successfully execut SSIS package from C#.net But when i tried that using windows service then SSIS package is not execute. How i can execute ssis package which is stored as file using windows service.

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. This error occured when connected to remote sql server from windows service

I created Windows Service in C#.net In this Windows Service I successfully connect to local sql server 2000 install in My PC.Then I retrive data from local sql server 2000 and fill that data into one dataset.Now I Want to connect to remote sql server 2000 to insert that data into database of that sql server 2000.

I created Windows Service in C#.net. In Windows service I want to connect to remot sql server 2000 But I get Error "Login failed for user(sa)". In Windows Service first I retier data from local database but i cannot insert that data into database of remote sql server.