SSIS Script Task
-
Hey All, I find myself here asking a question around SSIS which is somewhat out my comfort zone of C# but I have been tasked with some work, and I have came across a problem which I can't seem to over come. I have an SSIS Package which I am calling from the command line so its in the file system. Its encrypted with password etc. When I am logged in under my own domain user name the script executes perfectly. However; there is a network service user our support department has set up to run this job. When I run this package under this new user, the pacakge fails. My package has several tasks, however; the task which appears not to run in the Script task. Again, it runs under my own logon, just no with the service user logon. As a test, I added the service user to the administrator group on the computer the package is running, and the script task worked perfectly. (I think this might be important). I'm guessing I have a permissions issue with my new user. My thoughts are that it cannot execute vb scripts which I believe are internal to SSIS? If anyone has any thoughts, could you please help. Thanks in advance TF
-
Hey All, I find myself here asking a question around SSIS which is somewhat out my comfort zone of C# but I have been tasked with some work, and I have came across a problem which I can't seem to over come. I have an SSIS Package which I am calling from the command line so its in the file system. Its encrypted with password etc. When I am logged in under my own domain user name the script executes perfectly. However; there is a network service user our support department has set up to run this job. When I run this package under this new user, the pacakge fails. My package has several tasks, however; the task which appears not to run in the Script task. Again, it runs under my own logon, just no with the service user logon. As a test, I added the service user to the administrator group on the computer the package is running, and the script task worked perfectly. (I think this might be important). I'm guessing I have a permissions issue with my new user. My thoughts are that it cannot execute vb scripts which I believe are internal to SSIS? If anyone has any thoughts, could you please help. Thanks in advance TF
You need a Configuration File to store the credentials to the Server. To make sure if what you are saying 9is what am assuming. can you please send us the error ?
Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/