To Process files on a different domain using SSIS 2005

Question

Post reply

To Process files on a different domain using SSIS 2005

Viewing 5 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

sandeep rawat Ten Centuries Points: 1317 More actions · Answer 1

Hi ,

Follow following steps it will help u .

Use "Foreach Loop Container" to get your username/password and paths to variables

use "FTP Task" copy that file (Receive file) to local path .

use "Data Flow" process the file

use "File Task" delete file from local

use "FTP Task" copy that file to Archived (Send file) Remote location on that server

use "FTP Task" remove file delete remote file

Thanks ,

Sandeep Rawat

Neharika_Malhotra SSC Veteran Points: 201 More actions · Answer 2

The problem is that i do not have a FTP server so cant use FTP tasks. I have to implement without FTP. 🙁

sandeep rawat Ten Centuries Points: 1317 More actions · Answer 3

Then you can try

1 run package on all domain.

2 not sure will work but can try using comman name and password

COZYROC One Orange Chip Points: 28499 More actions · Answer 4

This is impossible with the current version of SSIS. You cannot impersonate or use domain credentials other than the credentials under which your package is executing.

So the suggestion with the FTP task will work and it looks like a nice workaround for this limitation.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Amar009 Mr or Mrs. 500 Points: 552 More actions · Answer 5

You will have to make your Domain a Trusted Domain of the other one and then run the package.