Browse by Tags

Splitting delimited data to columns - Set based approach

In this post splitting-csv-to-columns I showed how to split delimited data into multiple columns Simon in his post Set-based-splitting-of-delimited-strings-to-columns showed how to use that in a set based approach which would work on a set of data.In his approach he has limited it to maximum of four...

Posted to Madhivanan (Weblog) by Madhivanan on 09-11-2008
HTTP Authenticatoin Download of File in SSIS to CSV file

I recently needed to perform a download of a CSV file with HTTP Authentication in SSIS to a CSV file. Its possible, but I needed a script to do it. I couldn't use an HTTP connection because nothing in SSIS would consume it. Nothing, including the File System, WMI and execute process tasks would work...

Posted to greenmtnsun (Weblog) by greenmtnsun on 09-06-2007
CSV to Multiple Columns

If the table is denormalised and has Comma Seperate Values in a column, this code will copy it to Multiple columns of a Normalised table declare @DeNormalisedTable table ( data varchar ( 8000 )) insert into @DeNormalisedTable select '1,Davolio,Nancy' union all select '2,Fuller,Andrew'...

Posted to Madhivanan (Weblog) by Madhivanan on 08-27-2007

Page 1 of 1 (3 items)

SQL Server Community Blogs