IF I do not specify the Part ID, this means that all Parts from the specified carID must be taken.

If I do specify the partId(s) then only those parts need...

Yes this is perfect. Many tks. I had the syntax up to the second only!

For the float format, as I have to compute on them I still believe this is...

All right.

Let me check this on monday !

Have a nice we,

Grazie !

humm,

please note also that the column is date type noy datetime type...

sorry not working at all ....

as date is a float ... not possible to explicitly do a cast...

so date is stored as a float but retrieved as a date which...

hum .... it's a daily activity ...

However, I have found a way to create linkedserver with sp so I'm currently trying to test this in a loop....

Hope this will solve...

Tks for this.

However problem with linked server is that I do not know how many files I have to import... This depends from day to day.... As far as I...

I agree with you but

1. Excel format is available (there is no use of Office automation on the server side)....

2. XML also but SSIS refuse to handle it since it...

sorry first was mis placed...

I have tried with proxies but without success....

And SQLCLR will probably the next step after pilot... But right now I have no time to do it (and I'm not sure...

tks. this at least ill enable me to start....

Yes I agree with you. Issue was not really to map drive (which is by the way not the purpose) but rather to connect to a shared resources with user...

tks.

1. So what would be the code to map a network share?

2. What would be the code to retrieve folder contents?

Tks again.

OK. Good idea

Tks for your answer.

I do not use vb.net or csharp....

Usage of vbs inside stored proc ?