Parameterized OLEDB source query

by

Simple. Choose SQL command as the Data Access Mode. Enter your query with a question mark as a parameter placeholder. Then click the Parameters button and map your variable to Parameter0 in the Set Query Parameters dialog:

enter image description here

More information is available on MSDN.

More Related Contents:

  1. Import most recent csv file to sql server in ssis
  2. Using SSIS BIDS with Visual Studio 2012 / 2013
  3. How to create a temporary table in SSIS control flow task and then use it in data flow task?
  4. SSIS – How to loop through files in folder and get path+file names and finally execute stored Procedure with parameter as Path + Filename
  5. How to access ssis package variables inside script component
  6. Microsoft.ACE.OLEDB.12.0 is not registered
  7. SSIS how to set connection string dynamically from a config file
  8. How to load a flat file with header and detail data into a database using SSIS package?
  9. Insert a single row and return its primary key
  10. How to read a flatfile with lowercase thorn as the delimiter
  11. Export Varbinary(max) column with ssis
  12. How to send the records from a table in an e-mail body using SSIS package?
  13. SSIS Package Not Running as 32bit in SQL Server 2012
  14. 2 Data Flow Tasks Linking to one Execute SQL Task
  15. The value violated the integrity constraints for the column
  16. How to convert string in format yyyyMMdd to date using SSIS expression?
  17. How to import a fixed width flat file into database using SSIS?
  18. How to replace double quotes in derived column transformation?
  19. SSIS 2012 – Insert new rows, ignore existing rows
  20. SSIS: script task (vs15) not work when deploy on sql server 2014
  21. Executing SSIS 2012 package that has script components from external application
  22. How do I create a step in my SQL Server Agent Job which will run my SSIS package?
  23. convert Excel Date Serial Number to Regular Date
  24. How can I load a large flat file into a database table using SSIS?
  25. How do I pass value to a stored procedure parameter in OLE DB Source component?
  26. Dynamically assign filename to excel connection string
  27. Temporarily disable all foreign key constraints
  28. Convert from DateTime to INT
  29. Skipping rows when importing Excel into SQL using SSIS 2008
  30. SSIS LookUp is not dealing with NULLs like the docs say it should

Leave a Comment