[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2469
  • Last Modified:

SSIS - <Missing LineageID> in Data Viewer

Hi,
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>

thanks
0
CraigLazar
Asked:
CraigLazar
1 Solution
 
Jason Yousef, MSSr. BI DeveloperCommented:
HI,
Are you running a single package or a series of packages?

http://www.networksteve.com/enterprise/topic.php/Data_Viewer_Shows_Most_Values_as_%22Missing_LineageID%22/?TopicId=28921&Posts=1

Try deleting the Data Viewer and create it again...
0
 
CraigLazarAuthor Commented:
Thanks
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now