How to pass variable as a parameter in Execute SQL Task SSIS?

by

In your Execute SQL Task, make sure SQLSourceType is set to Direct Input, then your SQL Statement is the name of the stored proc, with questionmarks for each paramter of the proc, like so:

enter image description here

Click the parameter mapping in the left column and add each paramter from your stored proc and map it to your SSIS variable:

enter image description here

Now when this task runs it will pass the SSIS variables to the stored proc.

More Related Contents:

  1. How do I create a step in my SQL Server Agent Job which will run my SSIS package?
  2. convert Excel Date Serial Number to Regular Date
  3. How to import text files with the same name and schema but different directories into database?
  4. SSIS Package not wanting to fetch metadata of temporary table
  5. Automate Version number Retrieval from .Dtsx files
  6. Query a database based on result of query from another database
  7. SSIS Source Format Implicit Conversion for Datetime
  8. How to Map Input and Output Columns dynamically in SSIS?
  9. ssis best practice to load N tables from Source to Target Server
  10. Connecting to Oracle Database using Sql Server Integration Services
  11. Recommended SQL database design for tags or tagging [closed]
  12. Why does NULL = NULL evaluate to false in SQL server
  13. How to insert a line break in a SQL Server VARCHAR/NVARCHAR string
  14. MySQL number of items within “in clause”
  15. GROUP BY / aggregate function confusion in SQL
  16. Is there an alternative to TOP in MySQL?
  17. Support UNION function in BigQuery SQL
  18. MS SQL “ON DELETE CASCADE” multiple foreign keys pointing to the same table?
  19. How to anticipate and escape single quote ‘ in oracle
  20. What is a simple and efficient way to find rows with time-interval overlaps in SQL?
  21. Errors in SQL Server while importing CSV file despite varchar(MAX) being used for each column
  22. Should I use SQL_Variant data type?
  23. Log record changes in SQL server in an audit table
  24. How can I backup a remote SQL Server database to a local drive?
  25. Query json dictionary data in SQL
  26. Is there a severe performance hit for using Foreign Keys in SQL Server?
  27. PostgreSQL: fill NULL values in timeserie query with previous value
  28. Date serial in SQL?
  29. Get most common value for each value of another column in SQL
  30. Parameterise table name in .NET/SQL?

Leave a Comment