SSIS: FileName into Variables and Foreach Loop Container
Very often while exchanging data files with the clients, a useful information is stored in the file name. This can be a client name prefix, date, time, the period in the file and so on. While loading the data into the database, we need to extract the portions of the […]