Indeed I run the query a few times. I will do the tests after I will clean-up the buffers. On the machine it was only me, no other activity could...

You are right, the index is not covered and it does a nested loop join with a key lookup.

With forceseek I got this:

Scan count 1, logical reads 6046852, physical reads...

Ok, thank you for your reply. In my case is something like:

select (1487899.00 / 390500384.00) * (2081025.00 / 390500384.00) * 390500384.00

which is 7929.19839...~7929.2

Thank you for you answer, i will try to understand the BOM stuff. I've tested also the import without format file and I saw that it works.

Best regards

Actually if data file is unicode and I use -F option let say -F2 everything is ok, no error:

exec xp_cmdshell 'bcp AdventureWorks2012.dbo.myTable in D:\Test\MyTableData.dat -S instance\SERVER -T -F2 -f D:\Test\MyTableFormatFile.fmt'

?!?

Sorry again, my mistake. Is working. Strage is that I did the same steps 2 days ago and it did not worked. Anyway here is the steps:

-copy the files in...

Sorry, no good! It does exactly what i said in my post.

or something like:

declare @loginname varchar(35), @xml xml

set @loginname = '<rxno>001c</rxno>\test1'

set @xml = convert(xml, @loginname)

select @xml.value('(/rxno)[1]', 'varchar(4)')

the value method is used to perform an Xquery againts a XML instance to fetch...

For me Topic closed.

Thanks! This worked. For anyone who will read this post, steps to follow if you want to use SQL configuration SSIS Package with SQL Authentication:

- after you generate [SSIS Configurations]...

This was a very bad example indeed!!

I create a table

create table audit(id int identity(1, 1),

col1 varchar(20),

col2 varchar(20)

constraint pk_id primary key(id))

then i insert data into table audit

insert into audit select...