SSIS - <Missing LineageID> in Data Viewer

Posted on 2011-10-02
Last Modified: 2012-06-21
I am building an SSIS package in SQL 2008.
In my DataFlow i have a few lookup components before i get to my destination component.
I am using OLE DB connection type from my source SQL db in Sql 2008. when i attach a data viewer to the process to try and see what the data is looking like, i am getting the following in the columns
<Missing LineageID>

Question by:CraigLazar
    LVL 11

    Expert Comment

    LVL 21

    Accepted Solution

    Are you running a single package or a series of packages?

    Try deleting the Data Viewer and create it again...
    LVL 4

    Author Closing Comment


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now