Load data to the parallel datawarehouse (PDW) using the PDW adapter from Microsoft. in this post I have mentioned the steps involved and the common issue that is faced by developers using PDW destination.
Category: SSIS
The problems an _ (underscore) created in a SSIS Script component
it is common to create variable / field name with an _ (underscore) like my_first_name. I had neverseen this causing Programmatic errors till I used it in Script component within SSIS package. watch out for the pitfall, if you ever create an output column with an underscore using script component in SSIS. you can fix this code by
Working with XML files without a defined Schema or Multiple namespace using SSIS
The XSDs generated was unable to read the data correctly, as the XML had multiple namespaces ( with same name to make it worse). However, as usual, C# came to the rescue. used Script component (as source) to read the data from XML.
SHA 256 cryptography Algorithm to encrypt the data using C# and SQL server
SHA 256 cryptography Algorithm to encrypt the data using C# and SQL server. Hashbytes in SQL server and ComputeHash in C#.
SSIS : Using and Configuring For Loop Container
What is For Loop Container? For loop defines a repeating control flow. It has similar behavior as the “FOR” loop … More
SSIS : Sequence Container
Sequence containers is used to group the package into multiple separate control flows, each containing one or more tasks and … More
Creating Excel Files (.xls) dynamically from SSIS
In this blog, I will walk you through the creation of excel files ( xls / Excel 2003) dynamically through … More
SSIS Error : Resolve transformation errors in 64-bit version of SSIS in debug mode
In 64 bit operating systems, SSIS transformations ( especially excel) and tasks throws errors that could be annoying. You will … More
SSIS – Skipping rows and columns in Excel
Today, I came across a requirement, where the source excel sheet had data starting from row number 6 and column B. … More
So what do we call SQL Server 2011 ?
We had been sticking onto the mountains names from a very long time for SQL server. The proposed release of … More
Excel and SSIS 64-bit Connections
I stumbled upon a new error yesterday. I developed a simple and straight forward SSIS package in my machine. It … More
FAQ: what is the purpose of turning on the service”SQL Server Integration Services”?
This is a very common question asked to me by many developers. As a fresh developer few years ago, even I … More
Copy all objects from one database to another in SSIS using “Transfer SQL Server Objects Task”
sometimes, you may need to copy some/ all objects from one database to another. well this can easily done in … More
Adding Audit information to you dataset using SSIS.
Adding audit information to your dataset such as user/ machine that modified the data, package that inserted data into your … More
Logging using SQL provider in SSIS 2008 and SSIS 2005
I am starting this post with an assumption that you know to configure logging in SSIS 2005/2008 for SQL Server … More
Case insensitive comparison in SSIS 2008 LookUp transformation
Developers using SSIS 2005, were never satisfied with the lookup component . The lookup component in ssis 2005 didn’t support … More
Configure DTC on Windows Server 2003/ Windows XP
For the transactions to run successfully across servers , we need to enable DTC ( distributed transaction coordinator). For example, … More
Executing SSIS Packages from command prompt / SSMS
“Dtexec” utility can be used to run the SSIS packages from the command prompt. Using dtexec utility you can load … More
Awesome SQL 