Search code examples
sqlsql-servert-sqlssisscript-component

Updating table in SSIS script component

I have table in database with these columns

ID  |  Fact  | Date

And in column Fact I have only NULLs. I want to use Script Component to update data in this table. Is there any way to do that?

Note: I can't use SQL statement because of query performance.

Solution

  • A script component will allow you to use C# or VB to do things. You can send database commands with C# or VB, but it's still going to end up being a SQL statement in the end.

    If you can't update data in your table due to performance, you need to investigate why the performance is bad and rectify that.