Post reply

SSIS - Process and Error logging

  • October 15, 2015 at 3:25 pm

    #312331

    I have just created a SSIS process that will allow us to pull FTP files from multiple FTP sites. For my next step, I would like to create logs for the process.

    The steps I would like to take are:

    1. When file(s) come to our FTP site, I would like to insert the filename into a database table

    2. Be able to insert records to say No files found

    3. If possible be able to read a header row as files come in.

    4. If errors do occur I want to log the record and keep on moving to the next record.

    Are all these things possible with SSIS?

    Ray

  • October 16, 2015 at 8:13 am

    #1833831

    I am currently using a For Each loop to pull down files from an FTP site. Is it possible to also have the same For Each loop to insert the file name to a database file during the process?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply