Post reply

SSIS PROBLEM

  • May 31, 2014 at 10:22 am

    #308578

    Hi All,

    Please help on the SSIS issue.

    i have a package.It contains Foreach loop container,Inside foreach loop container,I have one Dataflow task(Inside dataflow task,i am using Oledb source(table),I am populating

    Data into Flat file)with flat file name YYYYMMDD_HH24MISS.txt. After i want to Zip that file with same file name.

    YYYYMMDD_HH24MISS.txt.zip,After that i want copy that Zip file into another location.

    Thanks in advance...

  • May 31, 2014 at 10:49 am

    #1718015

    that's all doable, so what's the SSIS problem that you have?

    Steve.

  • May 31, 2014 at 11:00 am

    #1718018

    I am able to generate file with YYYYMMDD_HH24MISS.txt.

    After that i want to zip that file with same Name.But i am getting error(Because time is changing frequently)

    Could you please send me your mailid,I will send you my package.

  • May 31, 2014 at 11:05 am

    #1718019

    Hi Steve,

    I am getting error,while Zipping the file with file name....

    Please assist me to solve the issue.

  • May 31, 2014 at 11:30 am

    #1718024

    Hi Steve,

    I am getting following error.

    [Execute Process Task] Error: In Executing "C:\Program Files\WinRAR\Rar.exe" "a D:\ZIPPINGFILE\20140528_225754.txt.zipD:\FLATFILEGENERATE\20140528_225754" at "D:\FLATFILEGENERATE\", The process exit code was "9" while the expected was "0".

  • May 31, 2014 at 11:52 am

    #1718026

    baddulas (5/31/2014)

    Hi Steve,

    I am getting following error.

    [Execute Process Task] Error: In Executing "C:\Program Files\WinRAR\Rar.exe" "a D:\ZIPPINGFILE\20140528_225754.txt.zipD:\FLATFILEGENERATE\20140528_225754" at "D:\FLATFILEGENERATE\", The process exit code was "9" while the expected was "0".

    Looks like you are missing a delimiter between the source and the destination file name passed to winrar.exe. If I remember correctly there should be a space between the archive name and the source file name.

    😎

  • May 31, 2014 at 12:27 pm

    #1718029

    Hi Eirikur Eiriksson,

    I am using Hours and Minutes and Seconds that's why it is changing.

  • May 31, 2014 at 1:20 pm

    #1718032

    Hi Steve,

    Any updates on issue.

  • May 31, 2014 at 1:33 pm

    #1718038

    baddulas (5/31/2014)

    Hi Eirikur Eiriksson,

    I am using Hours and Minutes and Seconds that's why it is changing.

    If you look at the error message, it says

    D:\ZIPPINGFILE\20140528_225754.txt.zipD:\FLATFILEGENERATE\20140528_225754

    when it should be

    D:\ZIPPINGFILE\20140528_225754.txt.zip D:\FLATFILEGENERATE\20140528_225754

    Add as space between the file names!

    😎

  • May 31, 2014 at 7:34 pm

    #1718049

    Definitely modify the expression on the @Arguments variable to have the space between the two file names as Eirikur pointed out, you can't have the parms run onto each other like that.

    It also looks like you've taken two different approaches to finding then appending the date & time to the file names. I'd go with the approach of using a variable to hold this info, then use that variable (or variables as you have) where needed. For example, you use @Dateparts and @TimeParts in the @Arguments as well as dynamically grabbing the current date and time. If you have the date/time in variable/s already, simply re-use this whereever you need it.

    Steve.

  • May 31, 2014 at 9:05 pm

    #1718053

    Hi Steve,

    I did same,as you mentioned.I have no luck.It's not working.

  • June 1, 2014 at 12:22 am

    #1718055

    Hi Steve,

    Still i am unable to fix the issue.Could you please give me the assistance.

    I need it very urgent....

    Thanks in Advance.

  • June 1, 2014 at 7:34 am

    #1718059

    Hi Steve,

    Any updates on issue.

    Thanks in Advance.

  • June 1, 2014 at 7:36 am

    #1718060

    Hi Eirikur Eiriksson,

    Still i am getting error.Could please help me on the issue.

  • June 1, 2014 at 8:53 am

    #1718062

    Have you implemented the changes suggested by myself and Steve?

    Few questions:

    1. Do you use variable(s) to hold the date and time value during the processing of each file?

    2. Are you using expressions to set the value of those variables in the file names?

    3. If yes, can you post the expression.

    4. Can you check and confirm that the output of the full command line used for the compression is correct.

    It would be better if you were slightly more verbose, especially error messages and more detailed description of steps and processes.

    😎

Viewing 15 posts - 1 through 15 (of 18 total)

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