SSIS is not instance aware, it is server aware and is only used to query MSDB/FileSystem to list the packages stored within it when you connect to a SSIS server...

Can you provide sample data, ddl statements, expected outcome?

freecoder (6/12/2012)

---

I have an application where a user can upload the file to a directory. Coz the requirment of the user was only one upload first. I did the upload...

Whats the reason behind having the blank titles in the second rows for each AID?

CREATE TABLE [dbo].[abcd](

[Aid] [int] IDENTITY(1,1) NOT NULL,

[Title] [varchar](50) NULL

) ON [PRIMARY]

insert into abcd (Title) values ('test1')

insert...

create one in your project in BIDS or create on in the SSRS web page

I've just run the script and it executes and shows the foreign keys under the table ok.

What permissions do you have to the databases, SA? dbo? ddladmin?

Can you see the...

DBCC CHECKDB MSDN

Depends!!!!

DBCC CHECKDB creates an internal...

Point 4,

Out of the three jobs, you would only need to stop the backup job as the copy and restore wont do anything should the backup not be in...

DBCC CHECKDB doesnt require downtime, what it will do is put the databases into a consistant state by rolling forward or back any transactions so that it can check for...

Not a problem, hope you have fun with SSIS

+1 for DBMail, why re-invent the wheel when its already there for you.

Reading through the MOAC book, its very limited in what it details in the actual couseware, I would say if you have a very basic knowledge of SQL and you...

I would say you have missed a step, I have just followed the steps and opened the packages and I see what the book says I should see.

I would go...

Lookup UPDATE in BOL or a search engine.

But basically you want to do a self join

UPDATE t1

SET t1.ID = LEFT(........t2.FilePath......)

FROM table t1

INNER JOIN

table t2

ON

t1.FilePath = t2.FilePath

skimming over the book, it seems that that part is trying to open the package you saved when running through the import export data wizard, you have done this and...