Can you provide some sample data of the format that the DOB is and how it should be formatted

If you run the package manually yes.

If you run the package by a Agent Job no.

If you only want to design and to execute SSIS packages, you do not have...

The SSIS service is not needed to run packages which are scheduled via SQL Agent, SQL will execute it via the DTExec command line tool.

If your running the package manually...

CREATE TABLE [dbo].[J]([JID] [int],[JTypeID] [int],[DID] [int])

CREATE TABLE [dbo].[JType]([JTypeID] [int],[CID] [int],[IsDefaultDeviceJState] [bit])

CREATE TABLE [dbo].[D]([CID] [int],[DID] [int])

INSERT INTO J VALUES (1,NULL,1),(2,NULL,2),(3,NULL,1)

INSERT INTO JType VALUES (1,1,1),(2,1,0),(3,1,0),(4,2,0),(5,2,0),(6,2,1)

INSERT INTO D VALUES (1,1),(2,2)

UPDATE J

SET JTypeID =...

Index maintenance should be a regular thing, indexes get fragmented for many different reasons, I recommend reading up on indexes and fragmentation, some good links below.

http://www.sqlservercentral.com/stairway/72399/

http://sqlinthewild.co.za/index.php/2008/10/20/what-is-fragmentation/

Same as this topic

http://www.sqlservercentral.com/Forums/Topic1392869-391-1.aspx

Look at the COLUMNS_UPDATED() clause

http://msdn.microsoft.com/en-us/library/765fde44-1f95-4015-80a4-45388f18a42c

Look at building a calendar table, my personal favourite is this one

http://www.sqlservercentral.com/scripts/Date/68389/

Then you just need to query that table where the day is a Monday between your two dates.

Use policy based management on the Server Configuration facet, give it the values it should be, then if the values change it alerts you

No, SQL must restore the database as it was at the time it was backed up, meaning it must create it with a size of 150GB.

The only thing would be...

Most excellent, glad it is working for you.

There is no connection specified at the top.

Because you are comparing a string value against a string value and the first is not less than the second, you need to ensure you use the right data types.

declare...

GO is a batch sperator.

So you could say

Do Something

Do Something Else

Do Something More

GO

Do Something Even More

Do Something Better Than Before

GO

And it would execute the first three things in one batch,...

If the certificate is a machine based certificate yes it would affect everyone, but it is more than likely going to be a user based certificate which is why it...