|
I know of two ways to load CSV with SSIS.
The first way is with an OleDB connection (and the ACE engine), but it doesn't work very well.
The second way is with a Flat File Connection, which works much better and allows you to specify quotes.
|
|
|
|
|
Thank you - I did try the Flat File connection, specifying the delimiter.
The file has comments field, which is freeform. The is data like below, which is causing the Flat file load to fail --
,"This is a test with more "testing" and tests"
|
|
|
|
|
Using columns separator that can apear in column data is a bad idea because it complicate reading and it is possible to do otherwise. It become very tricky when a column can contain both column separator and string delimiter, in this case you almost need to write a program dedicated to reading this particular file.
When I generate a CSV file, I use a Tab (chr 9) as a column separator and no " around strings. Since the Tab is only used as column separator, reading is really easy because of the unique usage of the tab.
Patrice
“Everything should be made as simple as possible, but no simpler.” Albert Einstein
|
|
|
|
|
ppolymorphe wrote: When I generate a CSV file, I use a Tab (chr 9) as a column separator
Technically, it's not a "CSV" file then.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Richard Deeming wrote: Technically, it's not a "CSV" file then. Agreed, but this variant is way practical
I am used to languages that have sophisticated packages to support this kind of things, and the Tab trick really simplify things.
Patrice
“Everything should be made as simple as possible, but no simpler.” Albert Einstein
|
|
|
|
|
Use the TextFieldParser class from the Microsoft.VisualBasic.FileIO namespace; e.g.
using ( TextFieldParser parser = new TextFieldParser( fileName ) ) {
parser.HasFieldsEnclosedInQuotes = true;
parser.SetDelimiters( "," );
while ( !parser.EndOfData ) {
string[] fields = parser.ReadFields();
}
}
|
|
|
|
|
Hi Friends,
What is the best approach to fill the employee details to predefined templates and suggest the template fornat for printing the id cards for web application.
Thanks in advance ..
Regards
Girish
|
|
|
|
|
This is not a programming issue. The design and content of such a card will depend on what you wish to use them for.
|
|
|
|
|
Thanks for replying Richard.
The design will be like employee Identity card for organization.
and contents like Employee image, company logo and other employee details like name, address etc.
|
|
|
|
|
The best way is by defining what information you have on the card, and then to implement a strategy to fetch those details.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Univote countered.
This space for rent
|
|
|
|
|
Downvote countered.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
|
Hello,
I have a requirement of odbc connection method in Microsoft.Practices.EnterpriseLibrary.Data assembly(version 5). Whether it is available in Microsoft.Practices.EnterpriseLibrary ?
Or it there any suitable alternatives for ODBC in Microsoft.Practices.EnterpriseLibrary ?
Please help me.
|
|
|
|
|
|
I want to connect Microsoft Access using Microsoft.Practices.EnterpriseLibrary, for that I need ODBC method.
|
|
|
|
|
Using the Data Access Application Block with Access is a bit like using one of those automated skyscraper construction platforms (image[^]) to build a hut
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|
|
srikrishnathanthri wrote: for that I need ODBC method No you don't. You can use an OleDb connection to connect to Microsoft Access and that's supported by the DAAB.
This space for rent
|
|
|
|
|
Pete O'Hanlon wrote: No you don't. You can use an OleDb connection
but we have migrated from OleDb to ODBC, so we cant go back to OleDb.
Is there any other ways for me.?
|
|
|
|
|
ODBC can be achieved by GenericDatabase Class of Microsoft.Practices.EnterpriseLibrary.Data
Thank you all for your replies.
|
|
|
|
|
Hello,
I develop an Skype Tool, who will be very usefull for many people.
But now, I check the option to send an message for all the
Conversation in the skype account, but I haven't found any result!
So, I went over to this Forum to get some help, and to ask
if is it possible to send an message for all your conversation?
Thanks for all!
|
|
|
|
|
I'm sorry but I have had serious problems trying to decode the question you are asking here. Are you wanting to provide a mechanism to send a message to all the people a user is connected to via Skype?
This space for rent
|
|
|
|
|
No, I want to send an message for all my conversations.
|
|
|
|
|
Sorry, that's still no clearer. Try to explain, in a lot more detail, what it is that you are trying to achieve. What do you want to happen when the application is running. Remember that we don't have access to any requirements you may have, so it's up to you to make things clear to us what you want.
This space for rent
|
|
|
|
|
i want to create folders with c# on console by clicking on application
|
|
|
|