Forum Replies Created

Viewing 15 posts - 1,006 through 1,020 (of 1,118 total)

  • RE: "Set Global Variables" cannot run on this edition of Integration Services.

    sachinbb (12/24/2008)


    It is SQL Server 2005. What is the upgrade if i need any?

    thnx

    You will need at least standard edition.

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

  • RE: Converting DTS to SSIS

    sachinbb (12/24/2008)


    Hi All,

    I finally got the proper syntax for the DTEXEC 32 bit running. Now i m facing a incompatible version issue.

    I am running SSIS Packages on a...

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

  • RE: "Set Global Variables" cannot run on this edition of Integration Services.

    sachinbb (12/24/2008)


    Hi All,

    I am running SSIS Packages on a Windows Server 2003 and my DTEXEC command is runnibg as Version 9.00.1399.06 for 32-bit.

    Has any one seen this error?

    The task "Set...

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

  • RE: send mail task

    Can you post more information like what is the error that you are getting?

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

  • RE: load five sources into five destinations

    Phil Parkin (12/22/2008)


    So the sources are being updated continuously? Or just from time to time? You may encounter some locking problems.

    One approach could be to move the source file to...

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

  • RE: error when using transfer DB task

    Do you have sa2 login?

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

  • RE: Is it possible to set a variable from within an Execute Package Task?

    jonathan.strauss (12/22/2008)


    Hi all - can anyone tell me if there's a way to directly set a variable by the 'Execute Package task'?

    I have a logging package and I want...

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

  • RE: SSIS dataextraction from GBase & Universe datasources

    Can you elaborate more about GBase and Universe? I've never heard about them. Did you check if you can find ODBC providers for them? If you can, then you can...

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

  • RE: Configure memory for Integration Services service and monitor current use of memory by SSIS

    There is no place where you specify global limit for SSIS processes. You control memory consumption granulary, by controlling specific SSIS tasks memory constraints. A good example is the Lookup...

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

  • RE: Problem trying to cmdshell a 32bit SSIS package - 8 char

    Check this post.

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

  • RE: Buld insert error

    Did you try to read the file from a local hard drive? Also did you try creating mapping to this network share and then using the mapping instead? This error...

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

  • RE: Configure memory for Integration Services service and monitor current use of memory by SSIS

    This is unusual question, Marios. Why would you want to know how much memory is consumed by the SSIS service? Do you have an issue in particular?

    I don't think you...

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

  • RE: Buld insert error

    So your problem is not permissions problem, but a problem of the file being accessed simultaneously from another process.

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

  • RE: Buld insert error

    Can you try giving full permissions to the file? Another issue might be if another process has opened the file in non-share mode.

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

  • RE: FTP TASK in SSIS

    You have to install SSIS+ library. It is available for download here.

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

Viewing 15 posts - 1,006 through 1,020 (of 1,118 total)