Are you trying to restore the db backup on Azure or want to restore it on your local machine?

try the following:

1. On your Data Source Designer, Click 'Impersonation Information' Tab, select the 'Use the service account' Option.
2. On 'General' tab, Click "Edit" button, Try to...

nice and easy. Thanks Steve.
Just curious, why 42 🙂?

nice and easy. Thanks for sharing Steve.

it would more sense to focus on the...

+1

Both CONVERT and TRY_CONVERT function converts the expression to the requested type. But if the CONVERT function fails to convert the value to the requested type then raises an exception,...

Invisible Parentheses 😛

Its always nice to have a proper table structure for a sample data. something like this:

declare @Sample Table (GroupCode char(1), BinNumber int, ValueCode varchar(20), DetailCode varchar(20))

Insert into @Sample

Select 'A',1,'ValueA','Details1' union...

Nice and easy question. Had a scratch due to the typo.

Thanks for sharing Steve.

JustMarie (9/28/2016)

---

Using the SSISDB catalog requires project level deployment. That's something to consider when researching this. For companies that have been doing package level deployment for years this is going...

+1 Phil, nice reflexes

was about to share the same thing 🙂