Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OLE DB Command Input has lineage ID 3293 that was not previously used in the Data Flow task.

Status
Not open for further replies.

rohitkochar123

Technical User
Mar 1, 2016
1
US
Hi Everyone,



I have a really weird issue and I am kinda stuck now. So my SSIS package does some insert in sql server and it works completely fine when I do it from BIDS. But I get error when I deploy the package to sql and run the package from the sql server. I get error:

OLE DB Destination Input has lineage ID 2006 that was not previously used in the Data Flow task.

OLE DB Command Input has lineage ID 3293 that was not previously used in the Data Flow task.

The buffer type is not valid. Make sure the Pipeline layout and all components pass validation.


Again package runs completely fine from SSIS BIDS. All mappings are perfect. Also my package use a user component that are also deployed through GAC on sql server machine. I am pulling all my hairs out at this time. I added few new columns to the table so I had to remap those in sql and then deploy the package back to SQL. Does anyone has any idea about this issue?





Thanks,

Rohit
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top