Plexus SQL

CHRONOLOGICAL ORDER (LIST FILES BY OLDEST FIRST) Extracting (listing) the files in a chronological order by, (this example “Modified Date”). CRITERIA -- OVER ALL VIEW DEFINING SOME VARIAB...

http://plexussql.blogspot.com/2010/06/chronological-order-list-files-by.html

2018-04-01 HI  I HAVE AN UPDATED VERSION OF THIS BLOG (SSIS 2016) AT MY NEW BLOG  CLICK HERE LOOPING THROUGH CSV FILES This program will loop through a folder and its sub folders, find ...

http://plexussql.blogspot.com/2010/06/looping-through-csv-files-using-ssis.html

Emailing work log notification to individual users by using SSIS Another project that I had worked on was to send emails with attached excel work log files to individual users; I used the same p...

http://plexussql.blogspot.com/2010/04/emailing-work-log-notification-to.html

Delete the oldest file in a folder with SSIS Some cases the developer wants to delete the oldest or the latest file, or maybe just save the name in a variable. In this case I am deleting the olde...

http://plexussql.blogspot.com/2010/04/delete-oldest-file-in-folder-with-ssis.html

Looping through list of users in SSIS by using SSIS “Object Variables” and “Recordset Destination” One of the question that came up for me was how to get a list of users & emails and emai...

http://plexussql.blogspot.com/2010/04/looping-through-list-of-users-in-ssis.html

2018-04-08 HI  I HAVE AN UPDATED VERSION OF THIS BLOG (SSIS 2016) AT MY NEW BLOG WITH ALL THE CODES CLICK HERE Looping Through Excel Files and Sheets I decided to write a small part of m...

http://plexussql.blogspot.com/2010/04/looping-through-excel-files-and-sheets.html

Some developers may want to get the list of table names and their field names, without scripting the database and at the same time they would like to copy the data to a new database with maybe ne...

http://plexussql.blogspot.com/2010/03/list-of-sql-table-names-and-their-field.html

To email Error log files as an attachment please check the post “Making Dynamic Backup Folders” first OVER ALL VIEW I am sure that you can find other ways to do this; the concept is to g...

http://plexussql.blogspot.com/2010/01/emailing-error-log-file-as-attachments.html

To make dynamic backup folders from SSIS you need to do is to follow the steps. Over all View I am sure that you can find other ways to do this and maybe much simpler, but the concept of the b...

http://plexussql.blogspot.com/2010/01/making-dynamic-backup-folders-in-ssis.html

How to Copy Files in SSIS To copy files in SSIS all you need to do is follow these simple steps. Overall View: The first step is to define few variables in the system: 1.“uVar_BackupFo...

http://plexussql.blogspot.com/2009/11/coping-files-in-ssis.html

Most of the SSIS developers want to get the list of the files from a folder (and maybe subfolders) and save them in to an object variable or loop though them one by one so that they can use it in...

http://plexussql.blogspot.com/2009/10/how-to-loop-through-files-in-ssis.html