Forum Replies Created

Viewing 15 posts - 451 through 465 (of 1,118 total)

  • RE: Querying Active Directory

    Try to direct to Trash Destination first only the source. Then include the script component, still directing to Trash Destination. Then you should know by this moment if the...

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

    January 20, 2010 at 1:21 pm

    #1106301

  • RE: Execute SSIS Package from C#.net

    Do you have SSIS 2005 installed on the machine where you execute the code above? The CLSID you have included above is for the Application object in 2005.

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

    January 20, 2010 at 12:58 pm

    #1106282

  • RE: Querying Active Directory

    Jack,

    How do you know which is the slow part? I would recommend you test each step one-by-one to determine if the call to the custom DLL is indeed the slow...

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

    January 20, 2010 at 12:54 pm

    #1106280

  • RE: Http Connection Manager

    I just tested with the URL you have provided above and it worked fine from my site.

    Do you have firewall in place? IE and Firefox might work because they use...

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

    January 20, 2010 at 12:52 pm

    #1106278

  • RE: please help - transforming flat text via script component

    You have equivalent to readline. Just define your layout as one column and use CRLF as your row delimiter and you should be good to go.

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

    January 18, 2010 at 9:26 pm

    #1105212

  • RE: Web Services Task transformations

    RJ-389260 (1/14/2010)

    Hi CozyRoc,

    Your scenario is exactly what I am trying to accomplish. Do you know of any references where I can get more detail about how to accomplish this? Thanks

    I...

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

    January 14, 2010 at 9:52 am

    #1103744

  • RE: Exporting Data to AS400 from SQL2005 with SSIS is SLOWWWWW

    Brad Johnson-378105 (1/14/2010)

    Rick,

    I've tried all of the same connections that worked for you, with the exception of iSeries Access for Windows ODBC data source. I think this requires SQL...

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

    January 14, 2010 at 9:44 am

    #1103737

  • RE: Schedule SSIS package containing Execute Process Task for PSFTP

    If you can use third-party solutions, check the commercial Cozyroc SFTP Task. It is fully integrated in SSIS and you will not experience issues like the above.

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

    January 13, 2010 at 9:20 am

    #1103146

  • RE: Running SSIS Packages in Batch file remotely

    Check SQLBI DTExec. It can help with the remote package execution.

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

    January 13, 2010 at 9:16 am

    #1103138

  • RE: Script Task Issue

    LOOKUP_BI-756009 (1/11/2010)

    Im having trouble getting Console.Writeline() to work in Script Task [VB.Net].Visual Studio 2008

    There is no pop up of Console window showing up.

    Here is just a simple code Im trying...

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

    January 13, 2010 at 8:35 am

    #1103093

  • RE: how to attach the data stored in a full result variable to the body of a message in send mail task in ssis

    saidwarak01 (1/11/2010)

    Hi Everyone,

    I would like to store the query results into a variable which is of object type as my result set operation is set to full result set in...

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

    January 13, 2010 at 8:21 am

    #1103083

  • RE: Exporting Data to AS400 from SQL2005 with SSIS is SLOWWWWW

    10061 error code means connection refused. I think you will find this discussion useful. Verify if you have the correct port specified to your server.

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

    January 11, 2010 at 12:44 pm

    #1102003

  • RE: Exporting Data to AS400 from SQL2005 with SSIS is SLOWWWWW

    Is there an error message you are getting? Have you tried to make a post in the IBM DB2 forum?

    Try posting your question here.

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

    January 11, 2010 at 11:00 am

    #1101947

  • RE: connecting to Oracle with network authentification

    If the Oracle driver doesn't support Windows Authentication, you have to use standard logon name/password approach.

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

    January 11, 2010 at 7:37 am

    #1101782

  • RE: email task problem

    Do you get an error message?

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

    January 8, 2010 at 9:14 am

    #1100962

Viewing 15 posts - 451 through 465 (of 1,118 total)