Hello,
I am trying to run a dtsx file as a trusted connexion. I was able to do it with the dtsrun.
When i run it the following way, it works fine but i don't want to fill the sql user and password:
dtexec /f mydts.dtsx /conn RIS;"Data Source=server1;User ID=user1;Password=toto;Initial Catalog=cata1;Provider=SQLNCLI.1;Persist Security Info=True;Auto Translate=False;" /conn SOURCE_DB;"Data Source=server2;User ID=sa;Password=titi;Initial Catalog=cata2;Provider=SQLNCLI.1;Persist Security Info=True;Auto Translate=False;" /Rep EWI > "test.log"
Can somebody help?
Thanx
Regards
Franck