Thanks Sue

Thanks much..

How to use newline character so that after each statement I can get the "go" and the new statement will appear followed by a new line. Can you suggest?

...

Thanks guys. Was thinking if any way to export using T sql script as I do that for triggers by writing my script.

In my case, I dont have the agents,,as the SQL Servers are in express edition. Those do not have agents.

So I wrote my own custom backup code and want to...

The SQL Server is Express Edition...so I need a simple solution as I cant schedule the jobs to run through Agent.

Is this the correct one? I just gathered the data from the tables.

SELECT @@servername, p.project_id, p.name,f.name, ev.value

FROM catalog.packages p

inner join [SSISDB].[internal].[projects] pp

on p.project_id = pp.project_id

inner join [SSISDB].[internal].[folders] F

on...

Yes, please..

I made a join with another few tables and found the the folder reference, along with this if could get the env details, would be easier for me to...

This gives me the list of packages, thanks for that. But each package has few configuration associated to it.

If I could get the config details, would have been excellent for...

Only the bar here for me is that, I need to copy the backup from the remote NAS share server which is in PROD domain to the NON PRod server...

Hi Ken

Thanks for sharing the script.

The prod backup goes to a NAS shared location which is in Prod domain. The Non Prod servers are in TEST domain. Both the servers...

I had a quick view on the posts. Very nice. But those are not inline to setup the SQL Jobs. Do you have any other useful articles to get more...

Do you have any supporting articles to refresh the skill on it? I will post this to SQL 2012 forum - thanks for the advise.

Any advise guys?

Thnkx Sue

I already have a Proxy account set. I am calling the xp_cmdshell using the SQL SSMS so I hope it should use sysadmin rights. No?

In order to use the proxy...