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...
LOKESH MSBI
Sunday, April 8, 2018
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");
...
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...
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...
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=...
Subscribe to:
Posts (Atom)