Forum Replies Created

Viewing 15 posts - 121 through 135 (of 1,118 total)

  • RE: Set batch size for CreateNewOutputRows of script source component?

    GattJ (8/22/2011)

    The files coming in may belong to 4 different DTDs and can contain namespaces too. When I tried using XML source with DTDs, I faced issues. That is why.

    You...

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

    August 22, 2011 at 8:44 am

    #1371454

  • RE: Set batch size for CreateNewOutputRows of script source component?

    Hi,

    Why not use the standard XML Source component ?

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

    August 21, 2011 at 6:53 pm

    #1371235

  • RE: Required urgent help - DB2 Database connectivity

    Have you tried using IBM Data Server Runtime Client ? It is free.

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

    August 18, 2011 at 7:25 am

    #1370106

  • RE: Dynamic SQL in SSIS

    As Koen said, out of the box it is not possible. The standard Data Flow Task doesn't support dynamic data flows.

    If you can use third-party solutions, check the commercial Data...

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

    August 11, 2011 at 3:49 pm

    #1367632

  • RE: sourcing from a remote FoxPro free table directory?

    Unless you are able to setup Windows "Network Share" to this remote system, I don't see how you will otherwise be able to open this database for reading.

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

    July 27, 2011 at 3:01 pm

    #1359695

  • RE: Script Task looses reference to external DDL

    Hi,

    Open AssemblyInfo.cs from your external DDL solution and tell us what you have defined for: AssemblyVersion

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

    July 20, 2011 at 6:38 pm

    #1356109

  • RE: Do not create Flat file destination when No Rows in ADO Net Source

    I would recommend against checking the RowCount property of ADO recordset. This might be very expensive operation if you are running against large recordset because the whole recordset have to...

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

    July 14, 2011 at 8:14 am

    #1352847

  • RE: encrypt the data in the pip

    Sachin4all (7/7/2011)

    In ssis ,Is there anyway to encrypt the data with a password just before writing to the csv which i have to upload it to sftp.

    and also is it...

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

    July 14, 2011 at 8:08 am

    #1352842

  • RE: How to configure the FTP task ?

    ananda.271085 (7/7/2011)

    connection cannot be established,server name, port number or credential may be invalid.

    The error message is a bit confusing. Still what this error means is what you have specified for...

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

    July 7, 2011 at 11:49 pm

    #1350150

  • RE: How to configure the FTP task ?

    ananda.271085 (7/6/2011)

    I am trying to configure the FTP task. In the connection manager the server name and credential for local is accepting but different server name and credential its showing...

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

    July 7, 2011 at 11:08 am

    #1349861

  • RE: Address Scrubbing Components in SSIS

    SQL STEWIE (7/7/2011)

    We are currently looking to use SSIS to do real-time address scrubbing. I was wondering if anyone of knew of any third party components or tasks that can...

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

    July 7, 2011 at 11:06 am

    #1349855

  • RE: How to mimic a transaction when MSDTC isn't available

    You may try using temporary tables, which may work or not. I would recommend this article, which contains useful information.

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

    June 23, 2011 at 10:28 am

    #1343217

  • RE: Blob field Help (SSIS)

    rocky_498 (6/22/2011)

    Thanks for your reply. Do you know any tutorial or Form about this issue? i google it but no luck.

    No idea. I would recommend you ask about the Microsoft...

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

    June 22, 2011 at 10:33 pm

    #1342786

  • RE: Blob field Help (SSIS)

    I think I have better idea now what is needed. This field actually contains a complete Microsoft Word document , right? I don't think it will be easy for you...

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

    June 22, 2011 at 10:11 pm

    #1342783

  • RE: Blob field Help (SSIS)

    Still very unclear. Actually you almost repeated the same description. I don't know where you get these links , in what system , etc. It looks like you are mixing...

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

    June 22, 2011 at 9:48 pm

    #1342780

Viewing 15 posts - 121 through 135 (of 1,118 total)