Hello I need a little more help with the SQL task to Variable.

I have made a SQL Task and set the result to Single Row and put in my Query...

Thank You I will have to try this using a variable ( I am a little lost on how to do that so I will have to do some investigation)...

I found some information. I believe I need to add a lookup and use that lookup to run the following Query:

SELECT PayPeriod

FROM dbo.LS_PAY_PERIOD

WHERE PayDate IN (

SELECT MAX(PayDate)

FROM dbo.LS_PAY_PERIOD

)

Where...

Thank You very much. Both of these should do the job. I will post once I have tried them.

Thank you, I will try this.

I was able to Highlight all and copy to single file. Thanks

I am still hoping to find a way to automate this more. All help is appreciated.

We are getting ready to Sunset several Servers here and we are under several regulations so I believe it is for documentation purposes.

I am new enough to this company and...