asked on

HOW SSIS package works when we try calling it from C# code ?

Hi,

I want to know whether I need to place the SSIS package in any sql server so that I can call it from C# CODE?
Can any one explain the process to call the ssis package code from C#

Thanks

ASKER CERTIFIED SOLUTION

Anil Golamari

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

EugeneZ

Note
"You cannot run packages outside BI Development Studio(sql2012+ SQL Server Data Tools ) on a client computer that does not have Integration Services installed, and the terms of your SQL Server licensing might not let you install Integration Services on additional computers. Integration Services is a server component and is not redistributable to client computers."

More:
Loading and Running a Remote Package Programmatically
https://msdn.microsoft.com/en-us/library/ms136090(v=sql.105).aspx

Running an SSIS Package Programmatically on a Remote Computer
https://msdn.microsoft.com/en-us/library/ms403355(v=sql.105).aspx

Gowtham Ramamoorthy

ASKER

Hi EugeneZ/lucky85,

Thanks for your comments. I will try with the above suggestions and code.

Can you please help me with the below questions

Many thanks in advance.
----------------------------------------------------------------------------------------------------------
I need to transform one single column values(columnA) from TABLE A in one database to another column B in TABLE B in some other database.

When i transfer columnA for example has (Employee names) but in the destination TABLE B it should be the (Employee ID). I have a lookup table which has the employeeID for the matching employee name.

Conditions:
I need only one single column gets updated in the destination TABLE B. without affecting any other columns.

I know this can be done in SSIS and i have created
* source oledb
*Lookup Transform
*Destination OLEDB

But the problem is at the destination output TABLE B the lookup transform is inserting NULL values to the unmatched column.

Can someone please guide me which is the best way to do this ?
Similarly i need to include various flows for the destination table from various databases.