Basically trying to copy the bkp file from one server to another but both the servers are in two diff domains.

There is no space and I'm using double quotes.

EXECUTE xp_cmdshell...

I used the below script to drop subscription, but got the below error.

Any advise please?

-- Dropping the transactional subscriptions

use [db]

exec sp_dropsubscription @publication = N'abcd', @subscriber = N'servername', @destination_db...

No

I think both these insert statements are failing.

INSERT dbo.TimeZoneOffsetTest (mytime) CAST(SELECT '20161015 08:15 -4:25' as DATETIMEOFFSET)

INSERT dbo.TimeZoneOffsetTest (mytime) SELECT '20161015 08:15 2:00'

These are all SQL Build scripts...Not sure out of them which one is specifically for Reporting

Are you referring to this article?

http://web.archive.org/web/20120830141644/http://www.sqldbatips.com/showarticle.asp?ID=62

Thanks Sue..There are so many versions I can see by FineTune.

Now, do I need to install/use the one based on the SQL Edition? I found my sql insrance is sQL...

Thnkx.

Thanks,..

Sure Matt!!!

So need to use the same password whch are used for SSISDB ?

Hi Phil,

While deploying getting the below Warning. But able to deploy the packages successfully. No error.

Is there something to look into against this warning?

TITLE: SQL Server Integration Services

------------------------------

Warning: Failed...

Hi Phil,

It worked...:) I am able to import/deploy the .ispac packages. Thanks much.

If I need any further help from you on this will let you know.

Thanks much for your advise!!!

Hi Phil,

I created the same folder structure as available in Production but when I try to import packages to the respective folders, I get the below error. Any advise how...

Thanks Phil...I'll try tomorrow.