Forum Replies Created

Viewing 15 posts - 376 through 390 (of 1,118 total)

  • RE: SSIS upgrade issue for Konesans 2005 to 2008

    srinivasable (4/15/2010)

    I tried to install 2005 konesans in windows 2008 but it's giving error.

    Thank you

    Srini

    What errors do you get? Did you have SQL 2005 installed in advance?

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

    April 15, 2010 at 10:32 am

    #1152285

  • RE: SSIS upgrade issue for Konesans 2005 to 2008

    srinivasable (4/15/2010)

    Thanks for the Reply.

    I am doing in windows Server 2008 box with SQL 2008. I upgraded all the packages but I am getting error for the Checksum and Trash...

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

    April 15, 2010 at 10:15 am

    #1152269

  • RE: SSIS and license seats

    manuelroman98 (4/13/2010)

    Hi forum,

    Does SSIS needs a license seat when executing a package remotely thru SQL Server Agent ?

    Regards,

    Manuel Roman

    Which machine is doing the actual execution? When you say "executing package...

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

    April 15, 2010 at 7:19 am

    #1152095

  • RE: SSIS upgrade issue for Konesans 2005 to 2008

    srinivasable (4/12/2010)

    Hi,

    I have 200 to 240 SSIS packages for SQL 2005. Now we are in the process of upgrading from SQL 2005 to SQL 2008. We are using konesans (Checksum...

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

    April 15, 2010 at 7:14 am

    #1152086

  • RE: Is It Possible To Use a GUID As a Global Variable?

    dndaughtery (4/12/2010)

    Any dea how to set a user variable's value inside the Input0_ProcessInputRow funtion?

    You cannot set the variable from there. You can set it only in the PostExecute method.

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

    April 15, 2010 at 7:11 am

    #1152083

  • RE: How to send many files to FTP server

    seeteshh (4/9/2010)

    Our client has instructed to write script task where ftp password & other information is kept in some other files.

    You can accomplish this without a need to write a...

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

    April 9, 2010 at 10:05 am

    #1149244

  • RE: Two Mail at a Time through Script Task

    sqlusers (4/7/2010)

    Hi,

    Is it possible to send two separate mail (Successful Mail and Non-matching records) through Script Task at a time in SSIS?

    --

    Why not use the standard Send Mail...

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

    April 8, 2010 at 10:09 am

    #1148435

  • RE: Error Connecting to Oracle Database using script task

    LOOKUP_BI-756009 (4/6/2010)

    I was able to grab data from Oracle using the [Oledb Source] Connection Manager without any problems.

    But I would like to use script task instead to connect, perform validation...

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

    April 8, 2010 at 10:04 am

    #1148427

  • RE: How to send many files to FTP server

    seeteshh (4/1/2010)

    Hello,

    Has anyone coded a script task that will upload 2 or more files to an FTP folder?

    I have done the same using a ForLoop and an FTP task but...

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

    April 8, 2010 at 9:59 am

    #1148423

  • RE: Stability of Table Difference component from CozyRoc

    xnl28-574517 (3/29/2010)

    Just wondering if anyone has any experience using the Table Difference component in a production environment?

    I'd like to know how stable and performant the component is.

    Hi,

    This is CozyRoc. The...

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

    March 31, 2010 at 9:11 am

    #1143165

  • RE: Custom Transforms

    daustinash (3/26/2010)

    I'm going to be creating some custom transforms over the next few months and did a bit of poking around looking for a place to contribute them to and...

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

    March 29, 2010 at 7:38 am

    #1141413

  • RE: Error in Script Task SSIS

    Why do you use script component to read from ODBC ? You can use the standard DataReader Source component to get your data.

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

    March 29, 2010 at 7:35 am

    #1141409

  • RE: SQL 2005 SP3 Upgrade 4262 from 3233 Failing for Integration Services and Client Components

    Exercise in perseverance. Congratulations on your patience!

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

    March 24, 2010 at 8:04 am

    #1138937

  • RE: Is bulk insert faster then OLE DB copy using data flow task?

    M Shah (3/18/2010)

    Using linked server with select into will lock the table right until the insert is done? The server that the data is finally moved to is used...

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

    March 18, 2010 at 3:52 pm

    #1136355

  • RE: Is bulk insert faster then OLE DB copy using data flow task?

    M Shah (3/18/2010)

    Good question. It is a third separate machine. So is the data brought into a buffer on this third separate machine? Please let me know?

    Thank...

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

    March 18, 2010 at 3:26 pm

    #1136345

Viewing 15 posts - 376 through 390 (of 1,118 total)