Yes Lempster. Some times customer does not want to understand at all :-D.

Thanks Koen for giving your input on my opinion for processing the Files. Is there any other way around?

Yes, I agree the major thing is for bifurcating the Large no....

1.Which edition do you have of SQL Server?

2.Regarding the XML files: how complex are they? What kind of processing do you do?

Answer of your Question:

1.We are using SQL Server 2012...

Thanks Koen for your response.

But could please suggest me what size of Memory should we propose to client for smooth and better performance?

And could you also give me some...

Hi,

It is always better option to go with SSIS because you can add many functionalities in near future instead of BCP.

But it also depends on your plan of action.

Thanks,

Hi,

Kindly check your lookup mapping and if its fine then check in the data level.

Sometimes it creates problem due to Trimming issue. So, you can check by Trimming(LEFT and RIGHT...

Hi,

Can any GURU help me on this ?

Thanks

------------------------------------------------------

There's two ODBC Administrators: 32 bit and 64 bit

32 bit: %windir%\syswow64\odbcad32.exe

64 bit: %windir%\system32\odbcad32.exe

------------------------------------------------------

While I tried to configure 64bit ODBC data source in SYSTEM DSN I dint get any option...

Hi,

I am agree with you but in SQL Server Agent if we make 32bit in Execution Option then it should take 32bit ODBC driver. I am not clear on this...

Hi SSC Veteran,

Can u pls expalin more?

I have tried to Setup the DSN in 64 bit ODBC data Source but i could not do the same.

So, pls help me if...

Hi,

Thanks SSChaging, for your valuable inputs and suggestions.

You are right. There were some permission issue with Sql Server User Login.

So, with the help of admin team I have resolve the...

Hi,

Thank U Daniel and Elliott for your valuable input and suggestions.

This issue got reseloved. There were some permission issue with the Sql Server User Login.

So, after gievn permission by admin...