Tags » SSIS

Speaking on ETL Security

I will be giving a presentation on ETL (Extract, Transform, Load) security at two user groups in the coming weeks.

Securing the ETL Pipeline

We’re going to look at typical ETL (Extract, Transform, Load) pipelines and consider the weak points an attacker might go after. 109 more words

Syndicated

Change Scope of Variable in SSIS

Today, i was asked by one of my colleague about how to change the scope of a variable declared in SSIS package. The problem was: there is a user defined variable already being used in the package and it was defined with package scope i.e. 271 more words

Microsoft SQL Server

SSIS Package deployment using DTUTIL command

SSIS packages can be deployed on server in various ways. One of the less known but useful approach is to deploy package using DTUTIL command. DTUTIL command can be used to deploy package to File System or Sql Server. 230 more words

SSIS

SQL SERVER - Andy Defines Basic RDBMS: Isolation in Processes - Notes from the Field #038

: This is a new episode of Notes from the Field series. Every time I give an introductory note, however, this time there is no need of intro note. 577 more words

SQL Authority

“MSBI (SSAS) Developer” for 06 months Contract position in Redmond, WA.

Job Title: “MSBI (SSAS) Developer”

Job Location: Redmond, WA.

Job Duration: 06 months

Job Nature: Contract, Contract-to-Hire (CTH)

Required Years of Experience: 07+

Number of Positions: … 78 more words

Jobs

SQL Server Query Fundamentals: A Simple example of a Query that uses PIVOT:

Problem:

Convert the following source data into a schema shown below:

Solution:

Here’s the code that uses PIVOT function to get to the solution, please use this as a starting point. 69 more words

Microsoft Business Intelligence

Make an SSIS package Delay or Wait for Data

Packages can be scheduled to run at a time when you expect data to be in a database. Instead of guessing the time when the data will be in the database we can have the package look for data in a SQL table. 233 more words

Syndication