Map DataReader & OLEDB Source SQL query parameter to SSIS variable

  Following are the steps I used to get parameters mapped to my SQL query using DataReader Source  and ADO.Net connection manager. 1. Create Ado.Net Connection manager using .Net Providers. 2. Add DataReader source and map it to ADO.Net connection manager by right Click -> Edit. 3. Under component properties, Write SQL Command without where…

3

SSIS Job using Oracle client goes into perpetual execution.

At more than one instances while working with my customers I found that there is a SSIS package which runs fine from BIDS as well as from command prompt using DTEXEC command but as soon as you try to execute this package as SQL Agent job, The JOB goes in a perpetual execution. These are…

3