Forum Replies Created

Viewing 15 posts - 961 through 975 (of 1,118 total)

  • RE: package with 64Bitruntime is set false

    nabajyoti.b (1/16/2009)


    i have encountered an sissue in 64-Bit version of a script task. On further investigating, i have found that there is a property for a project

    Run64BitRuntime is required...

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

  • RE: Acquire Connection error

    keywestfl9 (1/15/2009)


    Since it is not windows authentication i got to pass the userid and pwd inside the package.

    i tried to use save password option also.

    When i try to create...

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

  • RE: SSIS FTP Not Passing Password

    Jolly Ollie (1/15/2009)


    I want to be sure I am in the right place to answer your question. I opened the package, then F4 key, scrolled to the bottom of...

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

  • RE: Query timed out in SSIS

    Ells (1/15/2009)


    Thanks for reading and hopefully helping,

    I have put the error message at the bottom of this post. ALL SQL is 2005.

    I have SSIS on Server2 along with my data...

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

  • RE: Connection manager for excel version 2007

    Jagger (1/15/2009)


    Hi,

    I'd like to export table with more 66 000 rows to excel 2007.

    In SSIS connection manager setings - if I chose excel I can't find option to select...

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

  • RE: SSIS FTP Not Passing Password

    Jolly Ollie (1/14/2009)


    I must have missed a setting. I have an SSIS SQL 2005 package written in the Visual Studio that first outputs an ASCII file, sets up an...

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

  • RE: Problem in inserting data to sybase database from SSIS

    abansal (1/15/2009)


    Hi All

    I am getting the problem in connecting to Sybase database from SSIS Bulk Insert Task. The same is working fine with SQL Server.

    What exectly I need is I...

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

  • RE: Access to variables in Script Task

    scottpod (1/15/2009)


    CozyRoc (1/14/2009)


    Scott,

    If you define a variable in the script dialog, you should not use variable dispenser to access it. Just use the following code to write to the variable:

    Dts.Variables("requestString").Value...

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

  • RE: ssis configuration

    pat (1/14/2009)


    Hi all,

    I have SSIS package working fine, but the problem is this i want to use package on dev, test and prod system.

    but the problem i am having that...

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

  • RE: Access to variables in Script Task

    scottpod (1/14/2009)


    I have a user variable that is defined at the package level called requestString.

    In my Script Task I added a ReadWriteVariable 'requestString' (without the quotes).

    I then...

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

  • RE: DTSX packages - have to hard code login information ?

    onlo (1/14/2009)


    Dear Ramesh,

    Thank you for your information.

    But I need step-by-step instructions, can you tell me some web sites about what you said ?

    Regarding the migration assistance tools, check DTS xChange

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

  • RE: IP address of Server that runs SSIS

    Sameer Sait A (1/14/2009)


    Hi,

    I will try to be as clear as possible.. with as much as i know.

    We have a clustered SQL Server 2005. As of now we have created...

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

  • RE: problem with scheduling

    mamsay (1/12/2009)


    hi all,

    im using one script task which edits data present in a excel sheet.

    the script working fine when im running the package.

    but when i schedule the package, it...

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

  • RE: searching for an article

    mamsay (1/12/2009)


    hi,

    anyone knows how to schdule a package which consists of a script task which edits the data present in a excel sheet.. is there any article for it..

    kindly requesting...

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

  • RE: regarding union

    srkreddy8 (1/12/2009)


    in ssis 2005 there is no transformation called 'union'.how can we do the union operation in the ssis2005.

    Why you decided there isn't union transformation? Your toolbox is probably corrupted....

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

Viewing 15 posts - 961 through 975 (of 1,118 total)