SSIS With Script Component and Service References

The configuration file that .NET looks for when it loads configuration data is the one for the executable that's actually running; adding an app.config to your SSIS Script Component's project isn't going to produce a configuration file that SSIS knows to look for. Depending on how you opt to run your packages, it's going to be looking for the configuration file for BIDS, or SQL Server, or dtexec.

You will be much better off constructing your endpoints in code and bypassing the configuration file entirely. If most of your configuration options are defaults it's not even that complex, as you only need to set the properties that changed.

This Stack Overflow Question should show you how to do it:

WCF Configuration without a config file


For those using SSDT 2015, the file location for .config files has shifted when using the debugger; they can now be found under the following path: C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\SSIS\140\Binn


Comments

  1. Thompson

    • 2017/2/14

    The configuration file that .NET looks for when it loads configuration data is the one for the executable that's actually running; 

  2. Ridge

    • 2018/10/17

    2 Answers2. The configuration file that .NET looks for when it loads configuration data is the one for the executable that's actually running; adding an app.config to your SSIS Script Component's project isn't going to produce a configuration file that SSIS knows to look for. Depending on how you opt to run your packages, it's going to be

  3. Julio

    • 2015/5/4

    I am updating someone else's code in a SSIS package that downloads data from a webservice using a C# script task.

  4. Benicio

    • 2020/12/29

    3) Now open the Script component to edit the Script, look for Add Service Reference on the Reference section if you don't see it change the project to target Framework 3.5, once done you would be able to see the AddSerivceRefrence. 4. Adding the Service Reference would lead to adding a file a App.config on the project, which would have the

  5. Jaiden

    • 2016/3/27

    The Script task and the Script component can also use custom of Integration Services, you could only add a reference to a managed 

  6. Cairo

    • 2016/10/1

    For more information, see Integration Services (SSIS) Connections. You can make existing connection managers available for access by the custom script in the source or destination component by clicking the Add and Remove buttons on the Connection Managers page of the Script Transformation Editor. However, you must write your own custom code to

  7. Petit

    • 2016/4/22

    Double click on "Script Task". · Click on "Edit Script". · It will open the VstaProjects where you can write the C# custom code. · Go to the 

  8. Banks

    • 2020/2/7

    How to add references in SSIS? I need to add some office dll's to my SSIS package. In my SSIS script component, basically if i say Add Reference (in .NET tab) it is not showing office or other dll's.

  9. Jordan

    • 2019/3/5

    SSIS (SQL Server Integration Service) is a data migration software which is just add the WCF service reference to your SSIS script task, 

  10. Jerome

    • 2016/5/26

    I want to use some nuget packages to bundle the dll, but it seems that script component creates the project dynamically and there doesnt seems to be way to either: 1) get nuget to copy the dll (I think cause the .csproj file does no have import for nuget) 2) or to tell SSIS to look at a specific folder for dll location.

  11. Jackson

    • 2019/12/25

    If you need to reference a custom assembly from an SSIS Script Task, the recommended and easiest way is to install the custom assembly in the 

  12. Philip

    • 2019/11/27

    Adding a web reference (web service) to an SSIS script task? SQL Server Integration Services. Index ‹ SQL Server. Previous.

  13. Lance

    • 2021/2/19

    3) Now open the Script component to edit the Script, look for Add Service Reference on the Reference section if you don't see it change the project to target 

  14. Marc

    • 2021/7/13

    In SQL Server Integration services (SSIS), both the Script Task and the Script component have the provision to extend the default 

  15. Kairo

    • 2015/6/16

    This tutorial will explain my steps to call the WCF function from SSIS using a script task. 1. Verify the WCF service is running.

Comments are closed.

Recent Posts