This was a while ago but pretty sure I changed it from setting the full connection string to just set the servername property. I don't work at the place anymore...

If you are only running the etl's once per day I would run Snapshot Replication synching the database just before you start the ETL's. Shouldn't take too long.

How often do you run the ETL's? Replication has a few different modes so if transactional replication isn't suitable there is snapshot replication which may fit the bill.

Thanks for that. It was what i was expecting but haven't found anything in the documentation.

Cheers.

I agree strongly with the above but if you still want to go ahead with it I wouldn't run it on startup but rather put the database in SINGLE_USER mode...

I manage permissions using ad groups to specific folders and none of them are system users and have had no complaints. Would be interested to see if I am doing...

I use SQL Monitor for 5 of my main instances and use Custom Metrics a lot do do what you mention, works great and very customisable. I would recommend it...

I'm not sure if I agree with the automate 'everything' fanaticism. Some things just add to your technical debt as you are creating code that needs to be managed and...

Ok found the mechanism that the connection is being defined.

1. There is a variable called @[User:RSServer] which is a Object.

2. A SQL Task performs a select from a table...

Thanks for the reply 🙂

I saw that page too and figured it must be internally escaping the character but when it is used directly it is not reading it as...