I had a scenario where I had to extract a large XML document from a stored procedure. The business requirement was to extract the data from several tables as xml that conforms to a XSD document, write it to a file, then send it via FTP. 283 more words
Tags » SSIS
How to strip double quotes while importing data from CSV or TSV using SSMS Import Data wizard OR SSIS?
Long Title! Let me explain. This post will help you solve following problem if you run into it:
1) You are using SSMS Import data wizard to load data from a comma (or tab) separated value (CSV/TSV) file into SQL Server Table & you find that your source data values has double quotes and so you want to strip them before loading to destination table. 121 more words
As a Data Warehouse Consultant, I´m often asked the following by customers: “Is it possible to enrich our dimension data with some manually maintained data” and the answer is always “yeah, of course”. 651 more words