/// <summary> /// Generates SQL post deployment script that pushes R code into a table /// as well as /// </summary> private void CreatePostDeploymentScriptFile(SqlSProcPublishSettings settings, EnvDTE.Project targetProject, string targetFolder, EnvDTE.ProjectItem targetProjectItem, SProcMap sprocMap) { var postDeploymentScript = Path.Combine(targetFolder, PostDeploymentScriptName); var g = new SProcScriptGenerator(_fs); var script = g.CreatePostDeploymentScript(settings, sprocMap); _fs.WriteAllText(postDeploymentScript, script); var item = targetProjectItem.ProjectItems.AddFromFile(postDeploymentScript); item.Properties.Item("BuildAction").Value = "PostDeploy"; }