what does it return? is it MB? The one with 200GB returns 23866968 and the other one is returning 19995352

Can partitioning based on only one column? I am not concerned about query performance in this case. Moreover, archiving the data.

Doesn't have to be real time data. Would cube work if there is no facts? I mean just the dimensions. Doesn't sound like they need any facts on this attribute...

Thanks guys. It worked perfect.

Yes. It worked. I think I was typing as UniCode, which seems to be case sensitive.

Thanks!

I am using C# like this.

ConnectionManager myCM = Dts.Connections["FlatFileConnection"];

myCM.Properties["UniCode"].SetValue(myCM, true);

Getting the follwoing error now:

Error: The connection type "FlatFileConnection"

specified for connection manager...

Sorry. I meant I can't use ConnectionManagerFlatFile in script task directly. Can I use ConnectionManagerFlatFile in script task? or Do i have to use ConnectionManager class? Can you pleae show...

Thanks. How to create an object for a flat file connection manager class?

Any idea? How to set property of connection manager flat file in script task?

That worked. Thanks for all of your help.

I am using the following swtich in BCP.

-w -T -t"|" -r"" -c -q

Seems like one switch is overiding the other. File looks different but...

David, I downloaded ultraedit. Is unicode file always shows in hexadecimal? I did what you suggested and when I click on 1 character, two bytes are highlighted. But when I...

Also opened in notepad++, it says ANSI.

I generated the file with w option and it does look different than the file without w option. But I need to make sure if it is in Unicode format....

ok Thanks...So, do I use both -w and -n ?