Posted by: jwalin on: May 25, 2009
I have one task to convert the Store procedure into SSIS package. In store procedure it is using Cursor. By googling I tried to find an example but could not find good example. Here is my store procedure
DECLARE Agent_SkillGroup CURSOR FAST_FORWARD READ_ONLY FOR
SELECT DateTime,SkillTargetID,PeripheralID,sum(HandledCallsTalkTimeToHalf),count(*)
FROM WCI_IP_ST_AGENT_SKILL_GROUP_HH
WHERE SkillGroupSkillTargetID NOT IN (7820,10023,10793,13948,16368)
AND DateTime>= CAST(Convert(varchar(10), getdate()-1, 101) [...]
