VB.Net: Download file from FTP and UnZip

Welcome to CodeSpread! Experience: Many application requires data migration tasks to execute on daily basis. To achieve this we generally seek help of SSIS package, if at all we are making use of SQL sever. So, consider a case where you need to download a file from FTP location. Besides this, what if the file present on the FTP is in Zip format. How will you unzip and download. . . ? Don’t worry!! Here is the solution: You...

Read More

SQL:My first SSIS Package

I would like to share my experience about a situation, where I was given a task to export a file(say XML) from FTP location and get the data from this file populated into our database tables. Moreover, this task was required to execute everyday periodically. I asked my mentor and he introduced me to the concept of SSIS. Lets explore the experience here. Why SSIS? SSIS makes things easier. SSIS (SQL Server Integration Services) is MS...

Read More