Import both text files into staging tables then use an SQL query in the Transform Data task to join the two staging tables.  The query would look like something like this:

select t1.col1,

        ...

Depending on your environment (amount of memory, size of data row), you may be overflowing the buffer by setting Fetch Buffer Size to 3000.  I know that any setting greater...

You'll need a login that's a member of sysadmin or securityadmin whether it's a Windows or  SQL Server login.  Do you know the SA password?  If Builtin\administrators hasn't been removed,...

I've had this happen when I've opened a package on my workstation without being logged on to the server.  It works when I log on to the server either remotely...

You're right, Eddie.  I should have advised him to us STOPAT to restore to a time before the delete.  Thanks for catching that.  Good thing I'm not the only one...

Only a member of sysadmin can add a member to sysadmin.

Greg

See "Upgrading to SQL Server 2000" in BOL or this white paper: http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx

Both list the steps to take in going from SQL 7.0 to SQL 2000.

Greg

You could try using the New SQL Server Registration wizard in Enterprise Manager.  Start it and click on the elipse (...) next the the server name box.  It will list...

Assuming the database is useing Full Recovery model, back up the t-log right now.  Restore last night's full backup with a new database name, restore all log backups taken during...

Once you've created a login in SQL Server you need to create a user in each database that the login needs to access.  You can do that in Enterprise Manager...

I suppose there's some value because the names of both the computer and the instance are required to connect.

Greg

Sorry, I don't know any way to configure the log to give more information.  I can usually figure out what's going on by looking at both the SQL Server log...

Are you talking about database transaction log?  If so, there isn't a good built-in way of reading and interpreting them.  There are several 3rd party tools, such as Lumigent Log Explorer...

ALTER FUNCTION is not a transferrable permission.  See the 'Permissions' section of ALTER FUNCTION in BOL.

Greg

Betty,

You can use DTS to move the data.  If the tables have the same schema and you're only moving new data, I recommend using the Import/Export Wizard and choosing...