Here is the link of video in which i have created a mapping , workflow for how to take data from one csv and transform and create another csv.
http://www.youtube.com/watch?v=kbwbafnlvoc
informatica_tutorial_textfiles
Showing posts with label csv. Show all posts
Showing posts with label csv. Show all posts
Monday, July 11, 2011
Wednesday, October 13, 2010
[T-SQL] How to generate CSV from Table Data
Here is a very simple code:
DECLARE @Str VARCHAR(MAX)
SELECT @Str = COALESCE(@Str+',' , '') + FieldName
FROM TableName
SELECT @Str
*Field Name should be replaced with Field Name
*Table Name should be replaced with Table Name
DECLARE @Str VARCHAR(MAX)
SELECT @Str = COALESCE(@Str+',' , '') + FieldName
FROM TableName
SELECT @Str
*Field Name should be replaced with Field Name
*Table Name should be replaced with Table Name
Subscribe to:
Posts (Atom)