Forum Replies Created

Viewing 15 posts - 301 through 315 (of 1,118 total)

  • RE: Importing data using OLE DB Destination Task

    If you open the OLE DB Destination component dialog, there is a selection called "Error Output". The default is to fail the component, in case of errors. You can change...

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

    August 1, 2010 at 10:00 am

    #1200765

  • RE: Readin email using SSIS Script Task

    quasar_phoenicis (7/22/2010)

    hi,

    I'm trying to create an SSIS package that reads an email from MS Outlook 2003 (using the subject as the criteria) then save the excel file attachment of that...

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

    July 26, 2010 at 9:40 am

    #1198264

  • RE: SSIS Parallel Processing

    WangcChiKaBastar (3/16/2010)

    I have to modify an existing package to enable parallel processing (multi threading) package currently processes flat files and dumps them over I need to enable process where it...

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

    July 26, 2010 at 9:30 am

    #1198260

  • RE: How to do parllel ETL for identical sources

    sqlfavor (4/7/2010)

    I have identical source databases(SQL Server) that I want to perform parallel ETL into single DW. The number of source databases can vary, so some sort of dynamic connection...

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

    July 26, 2010 at 9:27 am

    #1198259

  • RE: how to load DAT File which contains JSON object as one of the field into a Table

    saidwarak01 (7/22/2010)

    Hi,

    first of all thanks for your reply. It would be appreciable if you can share more information on my problem.

    Thanks.

    I have shared everything you need to start working...

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

    July 22, 2010 at 8:23 am

    #1196883

  • RE: how to load DAT File which contains JSON object as one of the field into a Table

    saidwarak01 (7/21/2010)

    Moderators,

    Can you please throw somelight on this problem.

    It is very urgent task and I need help from you guys.

    Thanks

    Hey,

    People are on vacation... come back in September 😉

    Just silly joke.....

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

    July 21, 2010 at 8:38 pm

    #1196607

  • RE: User string contents --> Flat File

    Barkingdog (7/20/2010)

    SSIS 2008: I have a user-defined string variable (contents created at run time....) which contains

    concatendated "lines" of data, each terminated by a carriage return line feed. I want to...

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

    July 21, 2010 at 8:28 pm

    #1196604

  • RE: SSIS package to import from Pervasive SQL

    kbucher (7/19/2010)

    John,

    Have you been able to resolve this?

    I'm coming across the same issues, and am unfamiliar with Pervasive as a data source.

    Have you tried using the standard DataReader Source component?...

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

    July 21, 2010 at 8:19 pm

    #1196602

  • RE: SSIS : How to get the IP Address of the Machine where package is running

    Check here for programming sample how to get current machine IP address. You can easily convert this into SSIS script.

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

    July 21, 2010 at 8:16 pm

    #1196599

  • RE: How to Unzip the file Using script task

    webooth (7/19/2010)

    I see something wrong with it when you don't state it's a commercial product upfront.:angry:

    It was stated a couple of lines below. The original post was made long time...

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

    July 19, 2010 at 3:59 pm

    #1195179

  • RE: Loading flat file using SSIS. File has fixed columns + can have any 6 out of a possible 60 columns

    If you can use third-party solutions, check the commercial CozyRoc Data Flow Task Plus. It supports combination of static/dynamic data flows and doesn't require programming scripts.

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

    July 9, 2010 at 12:26 pm

    #1190984

  • RE: table difference for incremental load

    npothineni (7/7/2010)

    Hi Everyone..

    I am looking for incremental load i got this link to achieve scd.Here they did with table difference,Is there any transformation for table difference in ssis 2008.please let...

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

    July 9, 2010 at 12:19 pm

    #1190982

  • RE: Importing flat files

    sridharparshi (6/28/2010)

    all these flat files are different from each other and destination tables are also different for every flat file

    so now i got some idea like looping through the all...

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

    June 29, 2010 at 10:57 am

    #1186536

  • RE: Using connections in Script Task

    Verify what is the type of connection you are using. This doesn't look like ADO.NET connection.

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

    June 29, 2010 at 10:51 am

    #1186530

  • RE: How to Decrypt Files with PGP using SSIS

    smacumber 77733 (6/25/2010)

    I was able to create code using Script Task to receive files from FTP site and then delete them, now I need to decrypt these files I brought...

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

    June 29, 2010 at 10:47 am

    #1186524

Viewing 15 posts - 301 through 315 (of 1,118 total)