Forum Replies Created

Viewing 15 posts - 166 through 180 (of 1,118 total)

  • RE: Script Task referencing its own properties

    Guys,

    I did the following:

    - defined TaskName in ReadOnlyVariables input.

    - called the following code from script: MsgBox(Dts.Variables("TaskName").Value)

    And it worked, showing script task's name. I think it is incorrect to use System::...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    March 16, 2011 at 10:47 pm

    #1299783

  • RE: inpuits required for SSIS reusable component

    marees.inspire (3/15/2011)

    HI,

    I want to create some reusable components in SSIS.

    Can you give me your inputs/suggestion as i am a newbie on this.

    Thanks in Advance.

    If you can use third-party solutions, check...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    March 16, 2011 at 10:36 pm

    #1299781

  • RE: Loop through tables and transfer

    Hi Andrew,

    If you can use third-party solutions, check the commercial CozyRoc Data Flow Task Plus. It is an extension of the standard Data Flow Task and it is designed to...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    March 10, 2011 at 6:18 am

    #1297034

  • RE: Downloading files from MVS(Mainframe) to local folder using FTP Task(SSIS)

    kendoln (3/8/2011)

    TITLE: SSIS FTP Task

    ------------------------------

    An error occurred in the requested FTP operation. Detailed error description: 200 Representation type is Ascii NonPrint

    200 Port request OK.

    550 No data sets found.

    Check this discussion[/url].

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    March 8, 2011 at 6:07 am

    #1295803

  • RE: Downloading files from MVS(Mainframe) to local folder using FTP Task(SSIS)

    kendoln (3/7/2011)

    I tried with that. I can't get it into that.

    What happens? Do you get an error or what?

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    March 7, 2011 at 4:33 am

    #1295247

  • RE: Parse City and State

    As other knowledgeable people have said before me, parsing address information is not easy task and it is not a matter of one or two "smarty pants" expressions.

    If you can...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    March 4, 2011 at 7:01 am

    #1294633

  • RE: Copy tables from one server to another using SSIS

    "We pay you to do it. Stop making us pay for other tools to do your job."

    Weird logic. But you can easily explain it will cost N times more to...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    March 4, 2011 at 6:48 am

    #1294627

  • RE: Copy tables from one server to another using SSIS

    CozyRoc (3/4/2011)

    Another solution would be the CozyRoc commercial solution Data Flow Task Plus. It can retrieve the source and destination component's metadata at runtime and it doesn't require programming.

    Ah, I...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    March 4, 2011 at 6:10 am

    #1294601

  • RE: Copy tables from one server to another using SSIS

    Koen,

    The programming solution will work. However it is too demanding for many users. Another solution would be the CozyRoc commercial solution Data Flow Task Plus. It can retrieve the source...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    March 4, 2011 at 5:51 am

    #1294591

  • RE: Copy tables from one server to another using SSIS

    Koen Verbeeck (3/4/2011)Therefore the use of dynamic SQL. You construct the whole SELECT and INSERT statement on the fly.

    But, to be true, this will only work if the destination and...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    March 4, 2011 at 5:32 am

    #1294586

  • RE: Downloading files from MVS(Mainframe) to local folder using FTP Task(SSIS)

    What is p04.xusr.g481ddw(0) ? File or folder ?

    Try the following remote parameter:

    /p04.xusr.g481ddw(0)

    or

    p04.xusr.g481ddw(0)

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    March 4, 2011 at 5:05 am

    #1294561

  • RE: Copy tables from one server to another using SSIS

    Koen Verbeeck (3/4/2011)

    You can use a for each loop to loop over the table and store the tablename in a variable.

    Then you can construct a dynamic SQL statement in an...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    March 4, 2011 at 5:00 am

    #1294556

  • RE: Downloading files from MVS(Mainframe) to local folder using FTP Task(SSIS)

    You are not going to see files, when you open the browser window. It is only used for browsing remote folders. If you want to download all files from specific...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    March 3, 2011 at 10:30 am

    #1294151

  • RE: Copy tables from one server to another using SSIS

    Hi Sonal,

    Do you have the tables from source created in the destination database? Or you have to create them first?

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    March 3, 2011 at 10:26 am

    #1294147

  • RE: processing .NAF file

    phamm (2/25/2011)

    Hi all, just wonder if anyone has processed .NAF file? Would it be the same as processing .txt file? I right to load it into the db as...

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    March 3, 2011 at 10:17 am

    #1294137

Viewing 15 posts - 166 through 180 (of 1,118 total)