Hi iam having an SSIS package with simple SELECT statement in OLEDB source of an SSIS package, previously it runs fast but now a days it is increasing time day by day even there is no DATA to pull.
We have increase the RAM size and 4 processors to 6 processors, changed maxdop settings even though there is no change in it.
Is there any way to optimize this , please let me know if having any resolution
Thanks in advance