Getting Started with Adobe After Effects - Part 6: Motion Blur
Ask
Ask questions, discuss or help others by answering
Related Posts · View All
SQL Server 142
TSQL 76
SSRS 70
SSIS 66
XML 54

Top Categories · View All
SQL Server 142
TSQL 76
SSRS 70
SSIS 66
XML 54

Get FileName in an SSIS Task

Apr 20 2011 12:00AM by Sharath   

Hi,

I have a requirement in which I need to get the FileName of the flatfiles which I have processed in the SSIS package. We have a folder which has flatfiles named in this manner: sales_ddmmyy.txt and we need to move the contents of these into a staging table including the filename. After this I need to move these files to a processed folder and the bad files to a rejected folder. Please help me tackle this situation as I am very new to SSIS

Thanks

Sharath

Submitted under: Microsoft SQL Server · SSIS - SQL Server Integration Services ·  ·  · 


Sharath
704 · 0% · 46

3 Replies

  • What are the components that you are using in your package? Are you using For Each loop? if yes you can get the filename by configuring it to get the filename instead of default file path. Now use this file name to write to the destination folder.

    commented on Apr 20 2011 9:31AM
    Sudeep Raj
    12 · 13% · 4297
  • Yes, I am using for each loop in the package. I would greatly appreciate if you could tell me how to configure it to get the file name. Many thanks

    Sharath

    commented on Apr 20 2011 10:52PM
    Sharath
    704 · 0% · 46
  • Sharath,

    Have a look at my blog where it talks about a different scenario but what you need is provided there. Check the 5th imge. You could use the variable where ever you want. Let me know if you have questions.

    commented on Apr 25 2011 10:54AM
    Sudeep Raj
    12 · 13% · 4297

Your Reply


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]