This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0"?> | |
<package xmlns="http://schemas.microsoft.com/packaging/2010/07/nuspec.xsd"> | |
<metadata> | |
<id>_Dummy</id> | |
<version>1.0.0</version> | |
<authors>DBA</authors> | |
<owners>SpeakSQL</owners> | |
<licenseUrl>http://a.c</licenseUrl> | |
<projectUrl>http://a.c</projectUrl> | |
<requireLicenseAcceptance>false</requireLicenseAcceptance> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#requires -version 2.0 | |
<# | |
.SYNOPSIS | |
Deploy SSRS project to a Reporting server. | |
.DESCRIPTION | |
The Deploy-SSRSProject script installs an SSRS project(DataSource, DataSet, Report) file to a Reporting Server using ReportService20XX management endpoint. | |
http://technet.microsoft.com/en-us/library/ee640743(v=sql.105).aspx | |
1. Get datasource, report from the .rptproj file | |
2. Get report list from the $ReportListFile file |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="Windows-1252"?> | |
<Project xmlns="http://schemas.microsoft.com/developer/msbuild/2003" DefaultTargets="SSISBuild;SSISDeploy"> | |
<!--Requires a property called $(SSISProj) to be defined when this script is called--> | |
<UsingTask TaskName="DeploymentFileCompilerTask" AssemblyFile="C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\Microsoft.SqlServer.IntegrationServices.Build.dll" /> | |
<Target Name="SSISBuild" Condition="'$(SSISProj)' != ''"> | |
<PropertyGroup> | |
<SSISProjPath>.\$(SSISProj)\$(SSISProj).dtproj</SSISProjPath> | |
</PropertyGroup> | |
<Message Text="**************Building SSIS project: $(SSISProjPath) for configuration: $(CONFIGURATION)**************" /> | |
<DeploymentFileCompilerTask InputProject="$(SSISProjPath)" Configuration="$(CONFIGURATION)" ProtectionLevel="DontSaveSensitive"> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
USE [SSISDB] | |
GO | |
/** | |
.SYNOPSIS | |
Modified version of catalog.create_execution SP. | |
.DESCRIPTION | |
I created new version of catalog.create_execution SP to reslove the execution timed out error. | |
Permission check logic is not included. However, everything else is the same. | |
Works for 2012 and higher | |
.EXAMPLE |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
####################### | |
<# | |
.SYNOPSIS | |
Installs an SSIS project to a SSISDB. | |
.DESCRIPTION | |
I created this by modifying demo script shared by Bill Fellows through PASS session "Understanding the SSIS 2012 Deployment Model [LT-101]" | |
The Install-ISProject script installs an ispsc file to a SSISDB using MOM. | |
Works for 2012 and higher | |
.EXAMPLE | |
./Install-ISProject.ps1 -IspacFullName "D:\App_temp\SSIS\Test2\bin\Development\Test2.ispac" -ServerInstance "SpeakSQL\JY2012" -CatalogFolderName "DEV" -ISProjectName "test2" |
NewerOlder