I have a dstx file on the file system. It does not contain any sensitive data (passwords). We have a utility program that allows the entry of AS400 connection userid and password. The connection is tested and then the dtsx is updated with the userid and
password. then Microsoft.SQLServer.Dts.Runtime - Application class - SaveToSqlServerAs is used to deploy the package. app.SaveToSqlServerAs(packagefile, Nothing, dtsxpath, servername, Nothing, Nothing).
I would like not to have to update a file with the userid and password. Woudl rather read in the XML file in memmory and make the changes there. But is there a way to Save the package to Sql Server from memory instead of the file system?
I would not go about this the way you are. Why is the password and username not entered into an SSIS configuration(either XML or a database table)?. This way when you update the username and password the package looks to the configuration and doesn't need
to change at all. You can read more here: http://technet.microsoft.com/en-us/library/ms141682.aspx
Thanks for you suggestion. But our process works a certain way for a certain reason. Configurations are not an option. Is there a way to Save the package to Sql Server from memory instead of the file system?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.