Please post the create table definition along with data for the table so what we can build up the string for you.

Well that converts perfectly.

Can you provide the DDL and sample data for table ETCOL along with your full query?

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...