rohitkochar123
Technical User
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
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