Courion Tip – SSIS Data feeds

The scenario –

“I” get a daily feed from SAP of who has accounts on that system…But, the file name is generated automatically by SAP. So, it varies from day to day – and is NOT based on the date time stamp. So, basically, let’s consider it to be random.

Using this reference:

http://www.rafael-salas.com/2007/03/ssis-file-system-task-move-and-rename.html

I now copy the file and rename it to a standard file name in one step – (I have a step prior to this that makes an archival copy of the file).

Problem solved. I intend to supply more details to this post.

Advertisements

Posted August 23, 2011 by mmdmurphy in Courion Tip, SQL

Tagged with ,

%d bloggers like this: