yes stored procedure run today but the data i need yesterday before 11pm and it works thank you

what filter can i add in the stored procedure?

I would like to get some like this
Country Number of people 
US              3
UK             2
ITALY   ...

Hi ,

Haven't used SSIS Package as I still had issues , selected TSQL in SQL Agent and wrote a Stored procedure instead.

Regards,
Sindhu

Many thanks for all information.

I still have problems doing this.

I have created stored procedure and run  job through SQL Agent.

Regards,
Sindhu

Hi John,

Thanks for your help.

When I tried to locate the file it is visible in the server location, but i am not sure how that location...

Hi John, I tried copying file on to server  using IMPORT PACKAGE , but i'm stuck about the settings and location to where the file should point to ?

Hi,

It is a drive on the computer on which I'm developing and storing the package. May i know how to give permission to sql agent user to access...

Hi John,
Yes, H is the physical drive . SQL Server Agent run as [sa] username. Please help, as i have to manually run this every time.

Thank you.

This worked! Thanks a lot for the help!

Sorry
I’m trying to get the last active year for the individual user and insert that year as a new column (Status) for that particular user.

Thanks very much!

Thank you all for your replies.

Thank you for help.

What should i do to get two columns with below expected output.

Client fields value ...

Thank you for help.

What should i do to get two columns with below expected output.

Client fields value ...