- If you've recently installed Visual Studio 2019 (VS2019), and then installed the SQL Server Reporting Services (SSRS), the SQL Server Analysis Services (SSAS), and/or SQL Server Integration Services (SSIS) extensions, when you open a project you might be wondering where your menus went. How it was For example, if you had a report open in Continue reading 'BI: Wondering why your SSRS, SSAS.
- The backup with the current date using SSIS expressions Using scripts. In the next example, we will learn to combine expressions with the Script Task. The script task enriches the SSIS functionality and it can work with the SSIS variable. You can use C# or Visual basic to create code. In this article, we will use C#.
- When we build SSIS project it creates an ISPAC file under the bin folder. Besides, while deploying SSIS projects from Visual studio is equivalent to deploying ISPAC files in the back hood. Assuming a scenario when we have already deployed SSIS project under the SSISDB catalog.
Dec 18, 2019 The worst thing is that even having found the menu, sometimes the menu only shows two items (Work offline and Debug Progress Reporting). To make it show all the items again, click on the “Control Flow” area and then go back to the menu (it may be necessary to repeat this several times until it works).
By: Koen Verbeeck | Updated: 2020-07-02 | Comments | Related: More >DevOps
Problem
We are working on an Integration Services project with multiple developers. Someteam members work remotely, so it's not always easy to see which package someoneis working on. We'd like to use a git repository as a source control repository.This way we can also manage the code using branches. Is it possible to use git inVisual Studio?
Solution
Git is free and open-sourcedistributed version control system which has become very popular in the last years(one of the reasons is Github,a free online repository which was acquired by Microsoft). Git is distributed inthe sense that every developer has a local copy of the repository on his machine.When a developer makes changes, he/she first commits those against the local repository,then pushes the changes to the remote repository (on the server). If you'renew to the world of Git, these tips might help you get started:
Ssis In Visual Studio 2010
Visual Studio supports git for quite some time now. To follow along with thistip, you need Visual Studio (you can use thefreecommunity edition if needed) and theSSIS extension. The screenshots in this tip are taken with Visual Studio 2019and version 3.5 of the extension. In the past, Microsoft offered online source controlthrough Team Foundation Services, which was renamed to Visual Studio Online, whichis now renamed toAzureDevops (the on-premises Team Foundation Services is now rebranded asAzure Devops Server). Azure Devops not only provides version control, but alsoCI/CD pipelines, agile boards and test plans.
In this tip, we'll focus on using Azure Devops to manage an IntegrationServices (SSIS) project. Azure Devops is free for the first 5 users. You can findmore information about pricinghere. To use Azure Devops, you need a Microsoft account.
Azure Devops and SSIS
Creating an Organization and Repository
The first step in Azure Devops is to create an organization, which acts as acontainer for all your different projects. I already had an organization, but youcan easily create a new one:
You have to specify a name and the location for the organization:
Once the organization is created, you'll be asked to create a new project.
This will result in a project without any code repositories:
Let's switch to Visual Studio and see if we can connect to this new project.In the Team Explorer window, click on the green plug to manage your connections.There you can choose to connect to a project.
A new window will pop-up, where you can select the repositories linked to youraccount. At the top, you can switch between accounts. At the bottom, you can configurethe location on your hard drive where you want to sync the files to. Choose therepo we just created and click on Clone.
When clicking clone, you can choose between the following options:
Simply click Connect to finish the set-up. The repo is then copied to your localmachine:
It's possible you'll get the following message when cloning or syncingthe project:
Visual Studio uses the Git command line behind the scenes, which means of courseGit needs to be installed on your machine. Click on the Install link. Thiswill give you the following explanation:
Click on the Install button to proceed. This will take you tothe Git website where you can download the necessary components:
The installation is your typical 'next-next-finish' set-up. WhenGit is installed, restart Visual Studio. When trying to clone or sync, you mighthave to enter your credentials into the Git credential manager:
The value you enter in the Name box will be used when you commit changes.
Add a New SSIS Project to the Repository
Once the project is cloned into Visual Studio, we can start by adding a new IntegrationServices project to it. Create a new project and make sure the location is insidethe repository folder where you cloned the project to.
This means you need to change the default location into the following one:
Installing Ssis In Visual Studio 2019
When the project is created, you can see all the git commands at the bottom-rightof your screen, along with the different statuses. Creating the project resultedin 7 changes to the repository:
In the team explorer window, you can see those changes in the Changes submenu.You can also commit those changes along with a commit message. By clicking CommitAll, the 7 changes will be committed locally against the masterbranch, which is the default branch for a new project.
After the changes have been committed, you'll get a message you need tosync the commit to the server (or push the changesin git jargon).
In the bottom-right corner, you can see one commit is waiting to be pushed tothe server:
You can click on the arrow to go to the sync window and push the commit to theserver.
In the local folder, you can see Visual Studio added the folder for the SSISproject:
The same folder can now be found on the Azure Devops site:
You can now continue to work on the SSIS project, add packages and commit thoseto the remote server.
Add an Existing Project to Azure Devops
Not all projects are brand new. Sometimes you will need to add existing SSISprojects to your new Azure Devops infrastructure. The easiest option would be tojust copy the project/solution files to the folder (…sourcereposssis_test)in your local repository. However, it would be cleaner to create a new repositoryfor your existing project. Let's open an existing project in Visual Studio.Right-click on the solution and choose Add Solution to Source Control…
Go to the changes menu to sync (or click on the upwards arrow in the bottom-rightcorner). You will be prompted with the following options:
Choose Publish Git Repo. In the following menu, choose the organizationand specify a name for the repository:
After syncing, you can see a new project was added to Azure Devops:
There's also a new repo, along with the files of your SSIS project:
Visual Studio Ssis Tutorial
Next Steps
- To learn more about Azure Devops, check out these tips:
- To learn more about SSIS, check outthis tutorial. More SSIS tips can be found inthis overview.
- You can find all Azure-related tipshere.
Last Updated: 2020-07-02
About the author
View all my tips