What are you trying to do?

I am guessing that you want to delete rows from the employee table and insert those rows into fired table.

If so, you are better off...

This is a known problem that...

'UPDATE sysdtspackages

SET owner_sid = SUSER_SID(@newloginname),

owner = @newloginname

WHERE id = @id'

...does not always fix becuase of the different versions of the package in the table.

Sure fire...

You can pass the Global Variables into a DTS package via an 'inner package global variable'.

Create an 'Execute package' task and look at then properites. You will see the two...

Look into the data driven query task:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_elemtsk1_9w2z.asp

I never came across any books that really helped.

Best way is to learn yourself by selecting each of the tasks in turn and seeing what they do. For help,...

You can call a package from within a package.

IE - Create a master package that calls the individual packages each in turn.

Have you been given a sql server database?

You will need one. If the data is in oracle, get an oracle person to import the data from oracle into sql server...

Thanks, govinn. Just what the doctor ordered.

Simplifies it for me a lot.

The best thing you can do is to keep the design simple.

Investigate a star schema. It's easy to create and maintain and the theory behind them are simple. Basically, you...

I have decided to create a job that:

Samples 100% for my dimension tables, all starting with a 'd'.

Samples 10% for my fact tables starting with 'f'.

Using the statment earlier in...

You may want to consider using the database dumps from the production database. By restoring your development database from the dumps, it should be quicker and more efficiently controlled than...

My assumption was that the auto stats merely updates the existing stats based on the sample it has already examined. Hence, becasue the sample was low, updating stats does not...

We actually have the auto stats truned on. It's just that the sample is too low. I presume this happened when the database was first set up.

Let me give you...

The trouble I have is that I want to sample dimension tables at 100%, but fact tables at a lot lower level.

If I ran the entire database at 100%,...

Read up on data driven task. This link will give a summary:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_elemtsk1_9w2z.asp

However....Can be very slow to perform, but should be quicker than deleting and reinserting data.