Sunday, April 8, 2018

How to Zip the files in SSIS 2012

How to Zip the files in SSIS 2012 We are going to use the desktop as location to doing these operation. First step is to create one folder in the desktop as “SampleFolder” Create 2 sample text files in the folder (Give whatever name as your wish) Now in the SSIS package drag and drop the Execute Process Task In the Execute process Task properties give three properties as like below Executable...
Read More »

Save CSV file to SQL server and Retrieve back to folder

public void Main()               {                      // TODO: Add your code here             //databaseFilePut("C:\\Users\\LOKESH\\Desktop\\Code Sample\\sample.csv");             databaseFileRead("1", "C:\\Users\\LOKESH\\Desktop\\Code Sample\\sample1.txt");                     ...
Read More »

Friday, July 14, 2017

TERADATA -- How to Import and Export data to text file in TERADATA

How to Import and Export data to text file in TERADATA à To do this process first has to set some properties of TERADATA environment. Go to Tools in menu bar – go to Options – go to Export/Import tab --- change the property ------ Use this delimiter between columns (|), here I used PIPE Instead of PIPE based on the requirement use what you want. Note: - If your column data having existing delimiter mean, need to do some update in the columns. Because if you are using the...
Read More »

Tuesday, June 13, 2017

Removing the NULL, Space, Tab Space, Start of heading, Horizontal Tab, New Line, Carriage Return, File Separator etc.,. In the SQL Server.

Removing the NULL, Space, Tab Space, Start of heading, Horizontal Tab, New Line, Carriage Return, File Separator etc.,. In the SQL Server. Actually in the SQL server data base the spaces are looking like empty string only. For the first time all peoples will think of its space kind and will use LTRIM () & RTRIM () functions. It will not clear the tabs space and all. So this type of issue...
Read More »

Friday, February 17, 2017

Teradata Fast Load Script to load data from text file to Table

Teradata Fast Load Script to load data from text file to Table Step1:- Create one sample text file  Lokesh.txt Type: vi Lokesh.txt = i à write the text file with below sample data 101,Mike,James,1980-01-05,2010-03-01,1 102,Robert,Williams,1983-03-05,2010-09-01,1 103,Peter,Paul,1983-04-01,2009-02-12,2 104,Alex,Stuart,1984-11-06,2014-01-01,2 105,Robert,James,1984-12-01,2015-03-09,3 = :wq (will save the file data and close) Step2:- Create one shell script Lokesh.sh type=...
Read More »