Post reply

pb in archived file

  • May 13, 2018 at 4:32 pm

    #334697

    Hello everyone
    I will need to do a simple ETL SSIS
    that takes care of doing imported lists of txt files to SQL server and then have its files archived to a second folder
    the import operation to SQL server it passes correctly while the system operation of the transfer of the file returns to me of error enclosed with some additional information
    I created 5 Variables
    1-destination String C: \ destinationfile string
    2-filedestination string C: \ destination @ [User :: destination] + "\\" + @ [User :: file]
    3-filessource string c: \ source \ @ [User :: source] + @ [User :: file]
    4-source string c: \ source \
    here are some printed screens for more details
    thank you for your help




  • May 15, 2018 at 4:46 pm

    #1990612

    samirca007 - Sunday, May 13, 2018 4:32 PM

    Hello everyone
    I will need to do a simple ETL SSIS
    that takes care of doing imported lists of txt files to SQL server and then have its files archived to a second folder
    the import operation to SQL server it passes correctly while the system operation of the transfer of the file returns to me of error enclosed with some additional information
    I created 5 Variables
    1-destination String C: \ destinationfile string
    2-filedestination string C: \ destination @ [User :: destination] + "\\" + @ [User :: file]
    3-filessource string c: \ source \ @ [User :: source] + @ [User :: file]
    4-source string c: \ source \
    here are some printed screens for more details
    thank you for your help

    I don't know French  (other than swear words) but for a few of the pieces I can figure out it seems like you have an error with the format of the file destination string.
    Possibly check these links and see if that helps in configuring the file destination:
    Common Examples of SSIS Expressions and Variables
    How to use a variable as a filename in an SSIS script task?

    Sue

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

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