Forum Replies Created

Viewing 15 posts - 10,231 through 10,245 (of 13,874 total)

January 10, 2013 at 1:45 am

#1575641

  • RE: Calling SSIS Package in a trigger

    mpradeep23 (1/10/2013)

    Hi

    i trying call SSIS Package from a Trigger is there any perforamnce issue to the database

    thanks in advance

    with best regards

    pradeep

    Based on the limited information provided, my...

    January 10, 2013 at 1:43 am

    #1575638

  • RE: Importing one file into two database tables

    Yes.

    In the data flow, after the data source, add a MULTICAST.

    Connect one MULTICAST output to the existing table and another to the new table.

    January 9, 2013 at 8:47 am

    #1575300

  • RE: top 10 product in each month each year

    You've been here long enough to know the score. Please provide DDL, sample data and desired output in readily consumable form, as per the link in my signature.

    January 7, 2013 at 7:22 am

    #1574298

  • RE: Open SSIS package

    Create an empty solution and add the .dtsx file to it. Then you'll be able to open it.

    January 4, 2013 at 9:45 am

    #1573828

  • RE: Need to export excel sheet with SPECIAL formats

    opc.three (1/3/2013)

    The only way to format an Excel Workbook programmatically using SSIS is to leverage the Excel Object Model from a Script Task.

    One technique I have used in the past...

    January 4, 2013 at 4:11 am

    #1573674

  • RE: How do I parse a CSV file with extra commas in a field?

    Rick Lang (1/3/2013)

    Phil,

    Think I may have it. I used a flat file connection Manager, selected advanced and put 5 additional columns into the connection. Drug a Flat File...

    January 3, 2013 at 2:32 pm

    #1573490

  • RE: How do I parse a CSV file with extra commas in a field?

    Have a look here and see whether it gives you enough to get started with this.

    January 3, 2013 at 2:30 pm

    #1573486

  • RE: How do I parse a CSV file with extra commas in a field?

    Not - not as a source, but as a transformation.

    Essentially, the component takes each row as a single string and then, using parsing code within the script component, you break...

    January 3, 2013 at 2:20 pm

    #1573482

  • RE: How do I parse a CSV file with extra commas in a field?

    Rick Lang (1/3/2013)

    I've got a print log that is saved daily into a CSV file and I'd like to use SSIS to import it into Sql Server 2012. The...

    January 3, 2013 at 1:57 pm

    #1573469

  • RE: Writing Complex XML

    You could try varchar(max) instead.

    January 3, 2013 at 6:10 am

    #1573278

    • Viewing 15 posts - 10,231 through 10,245 (of 13,874 total)