I recently setup the replication with 1 publication ---> 1 subscriber, Initialized snapshot from backup and didnot add or remove any new articles from the publication.... but the replication broke...

Hi All,

I got similar issue where I need to run a Batch file which is pinned to a SSIS package - Execute task and I pass some parameters to...

Hello Friends, thanks for sharing the info on this. This is very helpfull. I got the same issue today and did multiple things......

1. the database is msdb, which caused the...

How to provide Explicit permissions? I never did this. Can explain me in detail..

Nope, Its a generic error message saying connection could not be established. But when I give sysadmin access, it works like charm.

I am thinking, it might be something with...

Yes the acccount has access to the all the databases with datareader and backupoperator roles.

Hello Anthony, thanks for that suggestion. I added my service account to admin group and it worked like a charm. your replies were very helpfull.

the .mdf and .ldf are still in same old location, but still the server is not startingup.....

I want to know the process to move the system databases to a...

Great, thanks you guys for the prompt response.

Thanks Craig.

I succesfully did that and its working gr8.

Thanks for the help.

Thanks for the reply.

but, Can u explain me in detail on where to set these options.

I am a newbiee to SSIS......

The path I chose is .......................

I am able to connect to FTP and

I am able to give a local path to store copied files.

But for the IsRemotepathvariable------------> I selected...

The owner has same permissions in both the servers. and he is sysadmin.

but still I get the same error.

Hi all,

I have a similar issue .

We recently migrated our sql 2005 to sql 2005 due to hardware upgradation.

after migration, I am receiving the following errors for some jobs...

If oracle driver is not supported, how do you create a linked server from a sql 64 bit versions.