Xml Feeds
Jun 28, 2007Hi,
Which topic in SSIS do I need to look into for being able to upload xml files from the network (every day at a particular time) and insert the values into the database?
Thanks
ADVERTISEMENT
Need To Add Line Feeds
May 2, 2007I am working on an "invoice" print, and it has to be on a pre-printed form, I need to print the totals at the bottom of the page and need help figuring out how to add specific amount of line feeds. I tried printing chr(13) , chr(10), conbination of both, also tried Environment.NewLine, no luck.
Using SQLRS2000, developing report with VS2003.
Anyone's suggestions would be greatly appreciated!.
Feeding Database With External News Feeds
Jan 16, 2008Hello all,
I have been reading these forums for a while but I am now a new member and relatively new to SQL (< 1 year exp).
In a project that I am currently working on I would like to include information related to current market news. An example would be news updates for certain companies that are generated from the Wall Street Journal or MarketWatch. The application would only be used internally and information would only be shared within the organization.
What I'd like to find out is:
Has anyone else worked with or developed something like this? If so, can you please share some insight.Would I need to purchase a Corproate License to use this information or would a personal account that can access the information be enough?What would be the best way to feed the database with this information? E-mails to the server, SSIS, etc.
Thank you for your help and I look forward to learning from you insight and experience.
Integration Services :: Remove Certain Line Feeds In CSV File
Jun 23, 2015I have a CSV file that I am importing via SSIS into a SQL table.On the Flat File connector, I have specified Line Feed as the row delimiter.The data flow is failing due to some of the rows having line feeds before the end of the row.Is there a way to get rid of some line feeds but not others, so that I can run the data flow successfully.
View 6 Replies View RelatedAdding Carriage Return And Line Feeds To A Text Box
May 7, 2007Hi All,
I am trying to print 10 values in a single cell in a text box.....
To make it readable I put carriage returns and line feeds into the boxes.
These rendered ok in visual studio but did not render ok in explorer....no carriage return or line feed.
This is what I added...
=Fields!segment_sdesc_00.Value & chr(10) & chr(13)
Can anyone advise me as to what is wrong with this? There must be a way to put a cr/lf or newline into a report in a text box.....
Thanks in Advance
Peter
www.peternolan.com
SQL Server 2008 :: Carriage Return Line Feeds In Flat File Imports
May 28, 2015I'm in the process of importing a series of flat files into SQL Server. I'm using a ~ to separate the columns and the row delimiter is {CR}{LF}. One of the files has a field that contains the CRLF combination in a few places so that field is split over several rows. This is readily visible when I look at the flat file. However, when I'm importing the file, the Import and Export wizard seems to ignore them and import the files as they should with one row per record.
View 0 Replies View Related