What is the relationship? Can a customer have multiple accounts or can an account have multiple customers.

>> I am also assuming that it is trying to insert ALL of the...

>>Are there any potential problems I might face when upgrading the OS of an existing SQL Server install?

Quick update in case anyone comes across this in the future.

The integration services...

I would use the HTTP Connection Manager to import the file into a staging table.

http://technet.microsoft.com/en-us/library/ms137602.aspx

After this I would write a TSQL statement using the MERGE statement and either...

The advantages would be quasi-instantaneous notification and you would eliminate the possibility that the error would prevent some...

You would have to put the TRY/CATCH after each...

CREATE TABLE [dbo].[#Logs](

[Message] [varchar](300) NOT NULL,

[MessageType] [varchar](14) NOT NULL,

[Action] [varchar](120) NOT NULL,

[CallingProcedure] [varchar](50) NOT NULL,

[SuccessFlag] [char](1) NOT NULL,

[ErrorNumber] [int] NULL,

[ErrorSeverity] [int] NULL,

[ErrorState] [int] NULL,

[ErrorProcedure] [varchar](126) NULL,

[ErrorLine] [int] NULL,

[ErrorMessage] [varchar](4000) NULL,

[DateTimeStamp]...

And as I stated earlied how do you look at a log for a stored procedure? If I have a 1000 line SQL with 50 different SQL statements and...

Thanks. I see now, the CONVERT does it all.

I haven't thought about or looked at this code in many years....but maybe it will help you. The parameters are in cells B2 and D2.

Private Sub CommandButton1_Click()

...

You can also use Table-Valued Parameters

http://www.sommarskog.se/arrays-in-sql-2008.html

Also if you know your dataset in Excel has a certain number of rows and columns select and paste just the data into a new sheet and then save you...

Are their commas in your data? If so try a tab or pipe delimited file.

I would find an existing rtf to txt batch convertor. You'll see several if you search for that phrase.

So your process could possibly look lik.

1) Export you field to a...

Is this a one time import or are you trying to setup a repeatable process?

If one time I would save the Excel as a delimited file and do the import....

A trigger would be the most 'immediate' way to do this, there will always be some mail server latency.

I am not a fan of triggers so generally I will create...