In this blog post I want to show how to reference custom .net Assembly in SSIS Script Task. Assume you want to use some JSON dll in your Script Task instead of this json connector. Here are the steps. Add…
In this blog post I want to show how to reference custom .net Assembly in SSIS Script Task. Assume you want to use some JSON dll in your Script Task instead of this json connector. Here are the steps. Add…
Have you ever got this error “File is being used by another process” Just try this create simple textfile on disk (e.g. mydata.txt) and open it with Excel… This way its locked (This is my trick to mimic locking of file) Now try…
This code snippet will make your life super easy if you have similar need what I had. Here is simple problem… If you have DataTable(s) or You have DataSet with Multiple DataTables and You want to Insert all records to…