thanks...that was it

thanks

thanks that helps alot.

Thats helps alot, but what about disk size.

Ig you expect to have for example 3 fact tables each having 10 000 000 rows. What size of hard drive would you...

Best way create the table before hand. Create all your keys and use the wizard to copy.

If the tables in both databases are the same. Script the one table then...

I am the administrator on the machine but the funny thing is I cant even create a new one from scratch let alone open a saved one.

I first instinct...

Thamks for the reply but thats not it.

I know the way to save the file from server to the next.

My issue is that because when I go into...

once you change the package and save it. The job will run the "new package" with the changes made. As long as the package has the same name.