THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |


You searched for the word(s):
Showing page 1 of 4 (40 total posts) < 1 second(s)
  • re: Calling Child Packages in SSIS

    Joao: The problem is likely caused by the schema of the tables being different. Your OLE DB data source has its schema defined at design time and when you dynamically change tables at run time, you will get a schema mismatch. Without knowing your specific details, it is hard to make a recommendation, but you might have to do some processing in ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on November 3, 2010
  • Calling Child Packages in SSIS

    Calling an SSIS package from another SSIS package is, on the surface, a simple task. You just use the Execute Package Task and point it to a package on a SQL Server or somewhere in the file system, as shown below. It is pretty simply right? But what if you need the parent package to pass information to the child package? That is accomplished ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on October 28, 2010
  • Virtual Classes

    I have two online classes starting on November 1st that I recorded on the vClass platform. The first is Introduction to SQL Server Replication and is a 12 session class on all things replication. Cost is $199for more information or to register, click here: The second class is ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on October 26, 2010
  • The SSIS Pivot Transformation

    The Pivot transformation is one of the most useful transformations in SSIS, and also the biggest pain to configure. It comes with one editor, the Advanced Editor, so no pretty GUI here. Lets walk though an example and hopefully it will help you learn how to use pivot. First off, lets define the source data and the destination of our pivoted ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on October 20, 2010

    Transact-SQL is a great language for data manipulation, but it has its weaknesses. Unlike real programming languages T-SQL is confined to procedural code. Sure, you can build modules by using stored procedures and functions, but for the most part, all of the work will be procedural. It has in the past also lacked error handling syntax leaving ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on October 12, 2010
  • Working with Text Data Sources

    A common source for SSIS packages is the flat file. These are just plain text files that are delimited by some character such as a comma, pipe, or tab. The problem is when you connect SSIS to a flat file it assumes a few things about the file, specifically the data types of all the columns. Flat files do not contain metadata so SSIS has no good ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on October 5, 2010
  • Data Conversion in SSIS

    When it comes to converting data from one type to another in SSIS, you have a few choices of methods. We are going to look at a few options and discuss the differences. With all of these, we are assuming that the input data type is compatible with the new output data type. In other words, we are not converting the word one to the number 1, this ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on October 1, 2010
  • SSIS Virtual Class

    I recorded a Virtual SSIS Class with the good folks over at SSWUG and the first airing of the class will by May 15th. This is 100% online so you can do it on your own time and from anywhere. The class will run monthly and I will be available for questions through out. You get the following 12 sessions on SSIS, each about an hour. Session 1: The ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on May 13, 2010
  • Getting Dynamic in SSIS Queries

    When you start working with SQL Server and SSIS, it isnt long before you find yourself wishing you could change bits of SQL queries dynamically. Most commonly, I see people that want to change the date portion of a query so that you can limit your query to the last 30 days, for example. This can be done using a combination of expressions and ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on March 22, 2010
  • New T-SQL Functionality in SQL Server 2008

    In my most recent posts I have looked at a few of the new features offered in T-SQL in SQL Server 2008. In this post, I want to take a closer look at some of the smaller additions, but additions that are likely to pack a big punch in terms of efficiency. First lets talk a little about compound operators. This is a concept that has been around in ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on March 15, 2010
1 2 3 4 Next >
Privacy Statement