Post reply

Transfer the Flat file to Success and Failure folder based upon the status

  • November 17, 2011 at 5:21 am

    #148829

    I am importing a text file into SQL Server .

    1. First I want to capture the txt filename and filepath.

    2. If my package fails due to some problem in txt file then it should get export to txt file in FAILURE folder and in case of SUCCESS it should go to SUCCESS folder

    say at location C:\SSIS\SUCCESS and C:\SSIS\FAILURE

    3. Also there is a column in my destination sql server table that is not mapped with the source and in which I want to pass the getdate() value through ssis . the column doesnot have default constraint....

    Please tell me how I can achieve this

  • November 17, 2011 at 5:26 am

    #1409102

    1. You must know the file name and path in order to import it in the first place, mustn't you?

    2. You'll need to set the task so it doesn't cause the package to fail, and then use precedence constraints to do one thing on success, or another thing on failure.

    3. Use a Derived Column transformation.

    John

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

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