September 15, 2014 at 6:36 am
I need to check every 15 minutes for the existence of a record in a table for the current date.
So I would need to have a Stored Procedure that outputs the record count to a variable.
Once the record is found the package completes as successful.
I have been searching the internet for a similar solution.
Has anyone done something like this?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 15, 2014 at 6:45 am
Welsh Corgi (9/15/2014)
I need to check every 15 minutes for the existence of a record in a table for the current date.So I would need to have a Stored Procedure that outputs the record count to a variable.
Once the record is found the package completes as successful.
I have been searching the internet for a similar solution.
Has anyone done something like this?
Which part of this is giving you trouble?
Why bother with a stored proc for this? Sounds like a one-line ExecSQL-task-to-SSIS-variable followed by appropriate precedence constraints.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
September 15, 2014 at 9:21 am
I got it to work.
A SSIS Script task worked.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply