..Awaiting for responses.. Pls help.

Thanks.

No responses at all...

Can anyone help pls...

Thanks.

Jacob Luebbers (5/31/2009)

---

@blaforge:

Sorry for the late response - if you still need assistance with this:

Your issue is a "quirk" in SSIS when dealing with LOB character fields > 4000 chars...

Hi All,

Nothing worked fo rme. I tried all the options.

Hence am I asking the question once again.

Suppose I have a table with a single varchar column (eg. name varchar(10)).

and table...

Koen Verbeeck (11/10/2011)

---

You can easily check encoding with the free tool Notepad++.

If you cannot use this tool, open the CSV file in regular Notepad and click File > Save as.

In...

Thanks Gila.

It was just an idea came to my mind.

Thanks for the clarification.

Just one more thing.. is there any way to verify the format of our newly created CSV file. ?

Thanks.

Thanks for quick reply.

We need it exactly in UTF-8 format. So will uncheck "unicode" and select code page as "UTF-8". Hope it will work teh way we want.

Thanks,

Smith.

Thank you. I will try but just selecting UTF-8 and not changing the data type of any field.

Wel, regarding Unicode. I am aware about unicode datatype. Think my question was...

Thanks a lot for the response. Was trying with it.

2 more doubts.

1. What's that...

Thank you very much Gila....

So if we don't set Max memory, SQL will try to take as much memory as possible and wont release it unless there's a request for it from OS.

SQL start...

. Thanks.

It's not there in my PC. reason may be bcose we r in client's network.

With limited rights.

Thanks again.

I am confused on this.

What if some application ask for more memroy and SQL doesn't need any memory at that time ? It wont still release.?

Secondly for testing purpose, I...

Windows task manager you mean. ? I am not able to find "services tab"...