private void Expand(List<string> bimlScriptPaths, Project project, string projectDirectory)
{
var tempTargetDirectory = Path.Combine(Path.GetTempPath(), Path.GetRandomFileName());
try
{
Directory.CreateDirectory(tempTargetDirectory);
// Get the General output window, and use that to write out our BIML "compilation" messages
this.ApplicationObject.ToolWindows.OutputWindow.Parent.SetFocus();
IOutputWindowFactory service = ((System.IServiceProvider)project).GetService(typeof(IOutputWindowFactory)) as IOutputWindowFactory;
IOutputWindow outputWindow = service.GetStandardOutputWindow(StandardOutputWindow.Build);
outputWindow.Clear();
outputWindow.ReportStatusMessage("Expanding BIML");
// Set status here as well as calling method, as that wasn't showing - Check and cleanup later
ApplicationObject.StatusBar.Animate(true, vsStatusAnimation.vsStatusAnimationDeploy);
ApplicationObject.StatusBar.Progress(true, "Generating SSIS Packages", 1, 3);
ValidationReporter validationReporter = BimlUtility.GetValidationReporter(bimlScriptPaths, project, projectDirectory, tempTargetDirectory);
// If we have errors show them, and finish
if (validationReporter.HasErrors)
{
ApplicationObject.StatusBar.Animate(false, vsStatusAnimation.vsStatusAnimationDeploy);
ApplicationObject.StatusBar.Progress(false, "Generating SSIS Packages", 3, 3);
BimlUtility.ProcessValidationReport(outputWindow, validationReporter, false);
}
else
{
// We can compile OK, but show warnings if we have them
if (validationReporter.HasWarnings)
{
BimlUtility.ProcessValidationReport(outputWindow, validationReporter, true);
}
// Write a closing message to the output window, since we have completed OK
outputWindow.ReportStatusMessage("BIML expansion completed.");
ApplicationObject.StatusBar.Progress(true, "Generating SSIS Packages", 2, 3);
List<string> newProjectFiles = new List<string>();
string[] newPackageFiles = Directory.GetFiles(tempTargetDirectory, "*.dtsx", SearchOption.AllDirectories);
newProjectFiles.AddRange(newPackageFiles);
#if (!YUKON && !KATMAI)
//IF DENALI or later...
// Read packages AND project connection managers
string[] newConnFiles = Directory.GetFiles(tempTargetDirectory, "*.conmgr", SearchOption.AllDirectories);
newProjectFiles.AddRange(newConnFiles);
#endif
var safePackageFilePaths = new List<string>();
var conflictingPackageFilePaths = new List<string>();
foreach (var tempFilePath in newProjectFiles)
{
string tempFileName = Path.GetFileName(tempFilePath);
string projectItemFileName = Path.Combine(projectDirectory, tempFileName);
if (File.Exists(projectItemFileName))
{
conflictingPackageFilePaths.Add(tempFilePath);
}
else
{
safePackageFilePaths.Add(tempFilePath);
}
}
if (conflictingPackageFilePaths.Count > 0)
{
var dialog = new MultipleSelectionConfirmationDialog(conflictingPackageFilePaths, projectDirectory, safePackageFilePaths.Count);
if (dialog.ShowDialog() == DialogResult.OK)
{
foreach (var filePath in dialog.SelectedFilePaths)
{
safePackageFilePaths.Add(filePath);
}
}
else
{
return;
}
}
#if (DENALI || SQL2014)
/*
* Make sure that the package correctly references the Project connection manager, if used
*/
List<ProjectConnectionManagerInfo> prjConnInfoList = new List<ProjectConnectionManagerInfo>();
// STEP 1 - Store all existing Project Connection Managers
foreach (ProjectItem item in project.ProjectItems)
{
if (item.Name.EndsWith(".conmgr"))
{
string fileFullPath = item.FileNames[0];
XmlReader r = new XmlTextReader(fileFullPath);
XmlDocument doc = new XmlDocument();
doc.Load(r);
//XmlNamespaceManager xmlnsManager = new XmlNamespaceManager(doc.NameTable);
//xmlnsManager.AddNamespace("DTS", "www.microsoft.com/SqlServer/Dts");
XmlElement node = doc.DocumentElement;
string prefix = node.GetPrefixOfNamespace("www.microsoft.com/SqlServer/Dts");
XmlAttribute xaObjectName = node.Attributes[prefix + ":ObjectName"];
XmlAttribute xaDTSID = node.Attributes[prefix + ":DTSID"];
if (xaObjectName == null) throw new ApplicationException("ObjectName attribute cannot found.");
if (xaDTSID == null) throw new ApplicationException("DTSID attribute cannot found.");
prjConnInfoList.Add(new ProjectConnectionManagerInfo(fileFullPath, xaObjectName.Value, xaDTSID.Value));
r.Close();
}
}
// STEP 2 - For all the Connection Managers that have to be inserted in the solution,
// if a connection manager with the same name alread exists, use the existing GUID
// to avoid corrupting the package that will be inserted
foreach (var tempFilePath in safePackageFilePaths)
{
if (tempFilePath.EndsWith(".conmgr"))
{
string fileFullPath = tempFilePath;
XmlReader r = new XmlTextReader(fileFullPath);
XmlDocument doc = new XmlDocument();
doc.Load(r);
//XmlNamespaceManager xmlnsManager = new XmlNamespaceManager(doc.NameTable);
//xmlnsManager.AddNamespace("DTS", "www.microsoft.com/SqlServer/Dts");
XmlElement node = doc.DocumentElement;
string prefix = node.GetPrefixOfNamespace("www.microsoft.com/SqlServer/Dts");
bool saveRequired = false;
ProjectConnectionManagerInfo pcmi = prjConnInfoList.Find(x => System.IO.Path.GetFileName(x.FileFullPath) == System.IO.Path.GetFileName(fileFullPath));
if (pcmi != null)
{
XmlAttribute xaDTSID = node.Attributes[prefix + ":DTSID"];
if (xaDTSID == null) throw new ApplicationException("DTSID attribute cannot found.");
xaDTSID.Value = pcmi.DTSID;
saveRequired = true;
}
else
{
XmlAttribute xaObjectName = node.Attributes[prefix + ":ObjectName"];
XmlAttribute xaDTSID = node.Attributes[prefix + ":DTSID"];
if (xaObjectName == null) throw new ApplicationException("ObjectName attribute cannot found.");
if (xaDTSID == null) throw new ApplicationException("DTSID attribute cannot found.");
prjConnInfoList.Add(new ProjectConnectionManagerInfo(fileFullPath, xaObjectName.Value, xaDTSID.Value));
}
r.Close();
if (saveRequired) doc.Save(fileFullPath);
}
}
// STEP 3 - For Each NEW package make sure that the Project Connection Manager
// points to the correct GUID
foreach (var tempFilePath in safePackageFilePaths)
{
if (tempFilePath.EndsWith(".dtsx"))
{
string fileFullPath = tempFilePath;
XmlReader r = new XmlTextReader(fileFullPath);
XmlDocument doc = new XmlDocument();
doc.Load(r);
XmlNamespaceManager xmlnsManager = new XmlNamespaceManager(doc.NameTable);
xmlnsManager.AddNamespace("DTS", "www.microsoft.com/SqlServer/Dts");
XmlElement root = doc.DocumentElement;
XmlNodeList nodes = root.SelectNodes("//connection", xmlnsManager);
foreach (XmlNode n in nodes)
{
string refID = n.Attributes["connectionManagerRefId"].Value;
ProjectConnectionManagerInfo pcmi = prjConnInfoList.Find(x => "Package.ConnectionManagers[" + x.ObjectName + "]" == refID);
if (pcmi == null)
{
pcmi = prjConnInfoList.Find(x => "Project.ConnectionManagers[" + x.ObjectName + "]" == refID);
}
if (pcmi != null)
{
// If a local connection manager does NOT exists, then point to the project connection manager
XmlNode node = root.SelectSingleNode("/DTS:Executable/DTS:ConnectionManagers/DTS:ConnectionManager[@DTS:refId=\"" + pcmi.ObjectName + "\"]", xmlnsManager);
if (node == null)
{
n.Attributes["connectionManagerID"].Value = pcmi.DTSID + ":external";
n.Attributes["connectionManagerRefId"].Value = "Project.ConnectionManagers[" + pcmi.ObjectName + "]";
}
}
}
r.Close();
doc.Save(fileFullPath);
}
}
#endif
// Add files to VS Project
foreach (var tempFilePath in safePackageFilePaths)
{
string projectItemFilePath = Path.Combine(projectDirectory, Path.GetFileName(tempFilePath));
File.Copy(tempFilePath, projectItemFilePath, true);
project.ProjectItems.AddFromFile(projectItemFilePath);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
try
{
if (Directory.Exists(tempTargetDirectory))
{
Directory.Delete(tempTargetDirectory);
}
}
catch (Exception)
{
}
}
}
private void Expand(List <string> bimlScriptPaths, Project project, string projectDirectory)
{
var tempTargetDirectory = Path.Combine(Path.GetTempPath(), Path.GetRandomFileName());
try
{
Directory.CreateDirectory(tempTargetDirectory);
// Get the General output window, and use that to write out our BIML "compilation" messages
this.ApplicationObject.ToolWindows.OutputWindow.Parent.SetFocus();
IOutputWindowFactory service = ((System.IServiceProvider)project).GetService(typeof(IOutputWindowFactory)) as IOutputWindowFactory;
IOutputWindow outputWindow = service.GetStandardOutputWindow(StandardOutputWindow.Build);
outputWindow.Clear();
outputWindow.ReportStatusMessage("Expanding BIML");
// Set status here as well as calling method, as that wasn't showing - Check and cleanup later
ApplicationObject.StatusBar.Animate(true, vsStatusAnimation.vsStatusAnimationDeploy);
ApplicationObject.StatusBar.Progress(true, "Generating SSIS Packages", 1, 3);
ValidationReporter validationReporter = BimlUtility.GetValidationReporter(bimlScriptPaths, project, projectDirectory, tempTargetDirectory);
// If we have errors show them, and finish
if (validationReporter.HasErrors)
{
ApplicationObject.StatusBar.Animate(false, vsStatusAnimation.vsStatusAnimationDeploy);
ApplicationObject.StatusBar.Progress(false, "Generating SSIS Packages", 3, 3);
BimlUtility.ProcessValidationReport(outputWindow, validationReporter, false);
}
else
{
// We can compile OK, but show warnings if we have them
if (validationReporter.HasWarnings)
{
BimlUtility.ProcessValidationReport(outputWindow, validationReporter, true);
}
// Write a closing message to the output window, since we have completed OK
outputWindow.ReportStatusMessage("BIML expansion completed.");
ApplicationObject.StatusBar.Progress(true, "Generating SSIS Packages", 2, 3);
List <string> newProjectFiles = new List <string>();
string[] newPackageFiles = Directory.GetFiles(tempTargetDirectory, "*.dtsx", SearchOption.AllDirectories);
newProjectFiles.AddRange(newPackageFiles);
#if (!YUKON && !KATMAI)
//IF DENALI or later...
// Read packages AND project connection managers
string[] newConnFiles = Directory.GetFiles(tempTargetDirectory, "*.conmgr", SearchOption.AllDirectories);
newProjectFiles.AddRange(newConnFiles);
#endif
var safePackageFilePaths = new List <string>();
var conflictingPackageFilePaths = new List <string>();
foreach (var tempFilePath in newProjectFiles)
{
string tempFileName = Path.GetFileName(tempFilePath);
string projectItemFileName = Path.Combine(projectDirectory, tempFileName);
if (File.Exists(projectItemFileName))
{
conflictingPackageFilePaths.Add(tempFilePath);
}
else
{
safePackageFilePaths.Add(tempFilePath);
}
}
if (conflictingPackageFilePaths.Count > 0)
{
var dialog = new MultipleSelectionConfirmationDialog(conflictingPackageFilePaths, projectDirectory, safePackageFilePaths.Count);
if (dialog.ShowDialog() == DialogResult.OK)
{
foreach (var filePath in dialog.SelectedFilePaths)
{
safePackageFilePaths.Add(filePath);
}
}
else
{
return;
}
}
#if (DENALI || SQL2014)
/*
* Make sure that the package correctly references the Project connection manager, if used
*/
List <ProjectConnectionManagerInfo> prjConnInfoList = new List <ProjectConnectionManagerInfo>();
// STEP 1 - Store all existing Project Connection Managers
foreach (ProjectItem item in project.ProjectItems)
{
if (item.Name.EndsWith(".conmgr"))
{
string fileFullPath = item.FileNames[0];
XmlReader r = new XmlTextReader(fileFullPath);
XmlDocument doc = new XmlDocument();
doc.Load(r);
//XmlNamespaceManager xmlnsManager = new XmlNamespaceManager(doc.NameTable);
//xmlnsManager.AddNamespace("DTS", "www.microsoft.com/SqlServer/Dts");
XmlElement node = doc.DocumentElement;
string prefix = node.GetPrefixOfNamespace("www.microsoft.com/SqlServer/Dts");
XmlAttribute xaObjectName = node.Attributes[prefix + ":ObjectName"];
XmlAttribute xaDTSID = node.Attributes[prefix + ":DTSID"];
if (xaObjectName == null)
{
throw new ApplicationException("ObjectName attribute cannot found.");
}
if (xaDTSID == null)
{
throw new ApplicationException("DTSID attribute cannot found.");
}
prjConnInfoList.Add(new ProjectConnectionManagerInfo(fileFullPath, xaObjectName.Value, xaDTSID.Value));
r.Close();
}
}
// STEP 2 - For all the Connection Managers that have to be inserted in the solution,
// if a connection manager with the same name alread exists, use the existing GUID
// to avoid corrupting the package that will be inserted
foreach (var tempFilePath in safePackageFilePaths)
{
if (tempFilePath.EndsWith(".conmgr"))
{
string fileFullPath = tempFilePath;
XmlReader r = new XmlTextReader(fileFullPath);
XmlDocument doc = new XmlDocument();
doc.Load(r);
//XmlNamespaceManager xmlnsManager = new XmlNamespaceManager(doc.NameTable);
//xmlnsManager.AddNamespace("DTS", "www.microsoft.com/SqlServer/Dts");
XmlElement node = doc.DocumentElement;
string prefix = node.GetPrefixOfNamespace("www.microsoft.com/SqlServer/Dts");
bool saveRequired = false;
ProjectConnectionManagerInfo pcmi = prjConnInfoList.Find(x => System.IO.Path.GetFileName(x.FileFullPath) == System.IO.Path.GetFileName(fileFullPath));
if (pcmi != null)
{
XmlAttribute xaDTSID = node.Attributes[prefix + ":DTSID"];
if (xaDTSID == null)
{
throw new ApplicationException("DTSID attribute cannot found.");
}
xaDTSID.Value = pcmi.DTSID;
saveRequired = true;
}
else
{
XmlAttribute xaObjectName = node.Attributes[prefix + ":ObjectName"];
XmlAttribute xaDTSID = node.Attributes[prefix + ":DTSID"];
if (xaObjectName == null)
{
throw new ApplicationException("ObjectName attribute cannot found.");
}
if (xaDTSID == null)
{
throw new ApplicationException("DTSID attribute cannot found.");
}
prjConnInfoList.Add(new ProjectConnectionManagerInfo(fileFullPath, xaObjectName.Value, xaDTSID.Value));
}
r.Close();
if (saveRequired)
{
doc.Save(fileFullPath);
}
}
}
// STEP 3 - For Each NEW package make sure that the Project Connection Manager
// points to the correct GUID
foreach (var tempFilePath in safePackageFilePaths)
{
if (tempFilePath.EndsWith(".dtsx"))
{
string fileFullPath = tempFilePath;
XmlReader r = new XmlTextReader(fileFullPath);
XmlDocument doc = new XmlDocument();
doc.Load(r);
XmlNamespaceManager xmlnsManager = new XmlNamespaceManager(doc.NameTable);
xmlnsManager.AddNamespace("DTS", "www.microsoft.com/SqlServer/Dts");
XmlElement root = doc.DocumentElement;
XmlNodeList nodes = root.SelectNodes("//connection", xmlnsManager);
foreach (XmlNode n in nodes)
{
string refID = n.Attributes["connectionManagerRefId"].Value;
ProjectConnectionManagerInfo pcmi = prjConnInfoList.Find(x => "Package.ConnectionManagers[" + x.ObjectName + "]" == refID);
if (pcmi == null)
{
pcmi = prjConnInfoList.Find(x => "Project.ConnectionManagers[" + x.ObjectName + "]" == refID);
}
if (pcmi != null)
{
// If a local connection manager does NOT exists, then point to the project connection manager
XmlNode node = root.SelectSingleNode("/DTS:Executable/DTS:ConnectionManagers/DTS:ConnectionManager[@DTS:refId=\"" + pcmi.ObjectName + "\"]", xmlnsManager);
if (node == null)
{
n.Attributes["connectionManagerID"].Value = pcmi.DTSID + ":external";
n.Attributes["connectionManagerRefId"].Value = "Project.ConnectionManagers[" + pcmi.ObjectName + "]";
}
}
}
r.Close();
doc.Save(fileFullPath);
}
}
#endif
// Add files to VS Project
foreach (var tempFilePath in safePackageFilePaths)
{
string projectItemFilePath = Path.Combine(projectDirectory, Path.GetFileName(tempFilePath));
File.Copy(tempFilePath, projectItemFilePath, true);
project.ProjectItems.AddFromFile(projectItemFilePath);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
try
{
if (Directory.Exists(tempTargetDirectory))
{
Directory.Delete(tempTargetDirectory);
}
}
catch (Exception)
{
}
}
}
