going to play around with this on the weekend

i tried the derived column transform and concated the two columns into a third. Package ran, but i only got the phone...

he is just using MS Access and I was going to link a table to the SQL database. He has Access 97 and said he couldn't import the data. The...

your best bet is to set up some triggers and audit tables to capture some operations for future auditing

SSIS get the Wrox book

Solid Quality Learning has good books as well

this is my script that i combined from scripts here and BOL. this is for all the tables in a database. you can create a separate db to store the...

do another sync and split

our job we have 27 steps involving 5 different servers. the entire thing is run off 2 servers.

first we kill connections on the destination, detach, do...

just copy and past from the script archive here

clustering and online indexing are only available in the enterprise version

i don't know about the easier to manage permissions part

where i work we have a few sql logins with the same permissions across all servers. R/O servers only have the...

still doesn't work

i'm staring to think it's a weird cluster issue we have seen with a few things in production where if an instance is on one of the nodes...

i was getting an error where i couldn't transfer the job from one server to another.

We have 8 main production SQL 2000 servers and a few test SQL 2005 servers....

sounds like you have to have software assurance where you pay every year

SP4 is a good idea just because there is no more support for SP3. No QA is dangerous though.

where i work they did a SP2 to SP3 upgrade a few...

i think you did

i did something similar on one of our QA servers a few months back. they had a db and needed the same db restored under a different...

go to the store and buy the Wrox SSIS book. It is the red book with the pictures of all the geeks on it.

there is a walk through and at...