September 2nd, 2011, 02:01 AM
To Process files on a different domain using SSIS 2005
I am facing issues while accessing files on a different domain within my SSIS package.
I want to read a csv file on a different domain accessible with a username/password and moving its data to a SQL table(on the server from where my sql job will be executed). Then archive the file after processing on the same domain where file was initially placed.
Also, i have to write new files created through my SSIS package via file system tasks on the other domain.
Any pointers will be helpful.