There are many ways you could implement conditional (IF THEN ELSE) logic based on a SQL Server Store Procedure result in SSIS, here is just one way: Note For demo purpose I will be…
Lets say you get a Microsoft Excel file containing the following information: If you want to import these record in a SQL table, just save the excel file as CSV. Then upload it to…
In my case the error "Unable to open Transact-SQL file in custom editor", was caused by the fact, that I installed BIDS voor Microsoft Visual Studio 2012, but not the SSDT tools. After installing the…
Microsoft SQL Server up until version 2012, is build on the presumption that the data will be stored on hard disks and the price of this storage is high not even considering the price of…
Below you will find the t-sql code needed to generate de SQL Server SimpleMembershipProvider tables. set ansi_nulls on go set quoted_identifier on go if object_id('dbo.webpages_Membership') is null begin create table dbo.webpages_Membership (…
As of 5-mrt-2013, Microsoft Visual Studio 2012 supports SSIS projects by installing Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012 You can download Microsoft SQL Server Data Tools - Business…
if you want to drop all stored procedures not belonging to the dbo schema from a SQL Server database, you van use the following select statement to generate a list that can be executed to…
I was getting the error: "Arithmetic overflow error converting IDENTITY to data type int", when inserting a record in a table with a identity column. The max id of this table was 45448, this is…
When you want to start using SqlDependency for QueryNotification in Microsoft SQL Server 2012, there are some steps you need to take, to make this work. In development In development you should take the…
Registering a query for Query Notification requires the database connection on which the subscription is made to have the correct SET OPTIONS enabled: ANSI_NULLS ON ANSI_PADDING ON ANSI_WARNINGS ON CONCAT_NULL_YIELDS_NULL ON QUOTED_IDENTIFIER ON NUMERIC_ROUNDABORT OFF…