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 »