I think the important thing isn't what naming convention you use, but that you choose one and stick to it. There's been a lot of discussion here and elsewhere...

DBCC CHECKDB and REBUILD INDEX. For the latter, you may prefer to use scripts instead of a maintenance...

How often does the job run? What happens if you create a job to execute a trivial T-SQL statement and run that - can you see the history for...

How do you run your maintenance plan? You will only see anything in the job history if you run the job that was created with the maintenance plan, not...

Athar

You can use an expression to set the connection string for the file connection manager.

John

No. Both outputs look exactly the same to me. Most people don't have the time or patience...

So that we don't have to guess, please explain exactly what you are trying to do. Phil has already asked one question. What are your source and destination,...

We don't have all the information we need. If the source and destination were both tables in databases on the same server, then that's exactly how I'd do it....

If you only ever will have the three account types, then you can do this in the code:

INSERT INTO MTable (Account_Code, Account-type)

SELECT Account_Code,

CASE LEFT(Account_Code,1)

WHEN '1' THEN 'Asset'

...

I'm not sure I understand. What difference does it make to the app owner how you get the database to the new server?

John

You should consider using the MERGE statement. The syntax is complicated, but it removes the danger of cardinality errors that can occur (unreported) with the UPDATE...FROM construction. These...

I don't know of a way to do it in T-SQL without modifying the definition of the procedure, but I think you can do it in SSIS with an ADO...

In the editor for the OLE DB Source, choose SQL command for your access mode, and simply type in the query that will filter out the rows you don't want.

John

Damn! I always try to remember to read through before posting, but usually fail.

John

Mahesh

This will provide a starting point for getting the definition of your table:

SELECT * FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'MyTable'

ORDER BY ORDINAL_POSITION ASC

You should be table to build a CREATE TABLE...