I have a simple execute query that I would like to run using SSIS however when i try to run it its taking way too long to execute.
My query looks something like this:
declare @sd smalldatetime set @sd = (select CONVERT(date,getdate(),103)) EXEC Brandon.[dbo].[post_by_date] @sd
for security purposes the names have been changed but this is the general idea
after this is executed, the results should go to a flat file.
is there any reasons unforseen that may be causing it to run slow??