Maybe your system Databases are hidden...

ChecK--> right click SERVERNAME--> Edit SQL Server Registration Properties. anc check to see if the "Show system Databases and system Object" is checked. if...

did you check the path to the Access Database and the Autoexec File.

use a UNC insted of mapped Drive. something like\\Server\path\file.bat

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2381439&SiteID=1

http://blogs.msdn.com/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx

see if this is helpful:

http://groups.google.com/group/microsoft.public.sqlserver.odbc/browse_thread/thread/9c79f6f4e8adce7b/f99b340d2fd76aef

You need to connect to "INTEGRATION SERVICES" and then you will be able to see the packages either under MSDB or File System.

Object Explorer->Connect-> "Integration Services"

Checkout some samples on http://www.sqldts.com or http://www.sqlis.com

Rather check this: http://www.sqldts.com/215.aspx

in the default instance text box try \\ or \ in the start (first characters) Or try MSSQLSERVER\\NAME

kill is not ending it. How to fix this?

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

When you kill the SPID, DOes it go into a ROLLBACK Situation and stay there right?

It gets converted into a...

Check this: http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

Also Try using the IP Address instead.

It Creates this location, because the locaiton you specified in your RS Solution Properties is the same. Check the Report Solution Properties and the Location. Remove "\"

You need to check for the Folder here:

USE MSDB

exec sp_executesql N'exec [msdb].[dbo].[sp_dts_getfolder] @P1, @P2',N'@P1 nvarchar(17),@P2 uniqueidentifier',N'Maintenance Plans','00000000-0000-0000-0000-000000000000'

and then add the Folder like this:

Add the folder if missing:

exec sp_dts_addfolder '00000000-0000-0000-0000-000000000000','Maintenance Plans','08AA12D5-8F98-4DAB-A4FC-980B150A5DC8'

Or...

Well, you can check your Cube(s) (Analysis Services Database) Complexity against Performance.

If you have Many Dimensions and Fact Tables and Millions of Rows and it is a performance hit on...

well you will have to loop through the folder where these files will exists.

you cna use the for loop component task in SSIS to take care of this, or VBScript.

check...

TRY THIS:::

RESTORE DATABASE DATABASENAME

WITH REPLACE,

MOVE 'LOGICAL DATA FILENAME' TO 'PATH TO MDF FILE',

MOVE 'LOGICAL LOG FILENAME' TO 'OATH TO LDF FILE'

Well, you can do a ServerSide trace using the same patterns.