Take a look at the following code. Hopefully it will help you determine what you need to do accomplish.

/*

Create temporary tables for testing

*/

create table #MyImportTable...

What is the result of running the following from an earlier post?

RESTORE HEADERONLY FROM backupDevice -- replace backupDevice with the filename of the backup diskfile.

Helps, but I have one more question. What is the DDL for the final destination table?

😎

First piece of advice, don't shrink the database. If you do it before the index rebuild/defrag, you'll most likely fragment the physical data file as it will grow as...

Two things. One, have you looked up master database in BOL? It talks about restoring the master database. Two, when you started SQL Server to restore the...

Thanks, but that doesn't answer my question. Is there anything in the data files that will uniquely identify each row in the import file?

😎

You want to use a Flat File destination in the data Flow to create a csv file.

😎

"Only Capitalists can kill Capitalism; by exploiting it's core principals at the expense of and to the detrement of the general public instead of working with the principals of the...

Does the data have any data elements that uniquely identifies each row?

Andrew Gothard (10/15/2008)

It does say that, doesn't it. Wonder if :I've never tripped over that one before over the past almost 2 decades or what.

Not very intuitive though -...

Actually, since you posted this in a SQL Server 2005 forum, this looks like a good place to use Service Broker. Creating the csv file directly in a trigger...

It might help if we could see the actual code you are working with else wise all we can do is guess at what may help you.

😎

Have you tried this:

ALTER DATABASE [SharePoint_AdminContent_1f7d4d63-662f-4180-a6b9-7d4b35b27435]

MODIFY FILE ( NAME = SharePoint_AdminContent_1f7d4d63-662f-4180-a6b9-7d4b35b27435_Log,

...

Have to agree with the others. I can't even get SQL Server to show a time different than the server installed on.

I think something is missing from your description...

Give this a try in a test environment first:

update dbo.table1 set

LogonStaffNo = t3.LogonStaffNo

from

dbo.table1 t1

inner join dbo.table2 t2

...