I'm using SFTP to receive various types of files and a FILE send port with Pass Through Pipeline to save the file.
BAM does not appear to work with Pass Through Pipelines and the SFTP.bts_sftp_properties context.
I want to capture the ReceivedFileName.
I can create an assembly in SQL Server and get to the ReceivedFileName in the tracking database, but I'd prefer to use BAM.
Any ideas? Thanks, Paul