Your question, your audience. Choose who sees your identity—and your question—with question security.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
But my fact table must be updated from a stored procedure.>>
Do you have the SP that should update your fact table? You can call that in a SSIS sql step like EXEC dbname.schemaname.spname
On another hand if you have the stored proc created and it returns record set that needs to be inserted into the fact table you could also do that in a SSIS sql step.