Yes!  That worked.  Thanks for the assistance.

Let me be a little more specific about the issues we're facing:

The application will be...

"I think there are definitely some great leaders and those that build companies. But lots of business is luck, it's timing, it's taking advantage or being able to take...

"So stop paying the CEO's so much money. They're not the reason for the company succeeding."

I agree in part and disagree in part.  Yes, there are a number of business...

That appears to be the issue.  I found this article on Microsoft Support:

http://support.microsoft.com/default.aspx?scid=kb;en-us;247527

Unfortunately, this solution only applies to delimited text files, not Excel spreadsheets.  Maybe I could export to...

What Transaction Isolation Level are you using?

I found this on Microsoft Support:

http://support.microsoft.com/default.aspx/kb/815008

Also what service pack is installed on your instance?

I found this article about a situation similar to yours, which...

It all makes sense now.  Thanks noeld.

The developer reported that only one column, Zone3Price, was converting incorrectly.  This didn't make sense to me, because the conversion was supposed to be...

The code is part of a DTS package.  As you can see, I'm taking the value from the text file and dividing it by 100:

'**********************************************************************

'  Visual Basic Transformation Script

'************************************************************************

'  Copy...

Okay, that was easy enough.  Thanks!

Yes, I successfully inserted the exact same data with a standard INSERT statement.  I decided to abandon the Bulk Insert approach for this load.  I need to do other transformations to...

Moderator:

Please move this post to the SQL Server General forum.  I clicked the wrong link when I created this post.

Thanks Frank, I got another variation from someone in my office:

Select @SQLCmd3 = 'where name = ''' + @DatabaseName + ''''

Glad you like my signature, Thomas Sowell is one of...

Okay, I'm trying Frank's approach again.  Now I'm having trouble writing a dynamic sql statement.

Here is the code:

 Declare @DatabaseName varchar(50)

 Declare @ServerName varchar(50)

 Declare @SQLCmd char(29)

 Declare @SQLCmd2 varchar(125)

 Declare @SQLCmd3 varchar(61)

 Declare @SQLCommand varchar(215)

 Select...

Frank:

I was originally thinking of doing a direct query from sysdatabases as you do here, but it was difficult getting the values for all possible combinations of options.  I may...

Here's the complete table design:

CREATE TABLE dbo.Databases (

 ServerName varchar(50) not null,

 DatabaseName varchar(50) null,

 DatabaseCreationDate datetime null,

 SQLVersion varchar(4) null,

 DatabaseSize int null,

 ANSINulls bit null,

 ANSINullDefault bit null,

 ANSIWarnings bit null,

 ArithabortEnabled bit null,

 AutoClose bit null,

 AutoCreateStatistics bit...