RamSteve (8/22/2011)

I still Getting the error in expression for destination database files ... can some one shade some light on expression as i need to make the path for...

You could use the following,

SELECT name FROM master..sysdatabases

The only way that I know how is to uninstall PowerShell from each client PC.

Just because it is undocumented does not mean that you should not use it.

If you feel...

Are you using plain T-SQL or Stored Procedures?

Do you have performance issues executing the SQL Code from SSMS? If not it is a SSRS issue.

You can perform a cursor or a loop or you can do the following:

exec sp_MSforeachDB 'DBCC CHECKDB (?) WITH ALL_ERRORMSGS, EXTENDED_LOGICAL_CHECKS, DATA_PURITY'

You will have to create the XML Configuration File before you can edit it.

It will not run properly because you can't have a snapshot of tempdb.

It is not necessary for it is temporary and it gets recreated each time you restart the server.

I thought that you might take the backup and apply to the destination backup.

If your using the Database Transfer Task you will need a variable for the Source and the...

Before you dynamically set the flat file you need a script task to identify the correct Data and Log File using VB.NET or C#, etc and set the variable to...

There error with the upgrade is interesting.

Can you provide more information?

RamSteve (8/18/2011)

I am planning to move a database from one instance to multiple instances using the SSIS ,So i would like to take care of the Security(Extract the security...

The Data File and Log File should be separate variables.

What error do you get? What statement bombs out?

If it works from SQL Server then it is an issue with the code within your GUI, .NET, etc.

Please start with the following article and go from there.

http://support.microsoft.com/kb/955396