Forum Replies Created

Viewing 15 posts - 16 through 30 (of 48 total)

  • RE: Problem With Header

    GSquared (10/20/2010)

    How are you building the header? If I remember correctly, you're using a local variable to do that. Can't you just add the quotes in the code...

    October 20, 2010 at 2:15 pm

    #1239924

  • RE: Problem With Header

    GSquared (10/20/2010)

    If you specify a data qualifier in your export, all of the fields will be enclosed in quotes (or whatever character you choose for it).

    I did have specified the...

    October 20, 2010 at 11:56 am

    #1239848

  • RE: Add the headers associated with, and particular fileds.

    Hi All, Thanks a lot for the effort and help you provided.

    I have resolved the issue. I have added a excute sql task inside the for each loop. The...

    October 18, 2010 at 12:34 pm

    #1238643

  • RE: Add the headers associated with, and particular fileds.

    preensheen (10/18/2010)

    Phil Parkin (10/18/2010)

    Please provide some sample data, showing what your source looks like and what you would like to see in your destination. Your explanation is confusing.

    My source looks...

    October 18, 2010 at 11:09 am

    #1238558

  • RE: Add the headers associated with, and particular fileds.

    Phil Parkin (10/18/2010)

    Please provide some sample data, showing what your source looks like and what you would like to see in your destination. Your explanation is confusing.

    My source looks this...

    October 18, 2010 at 10:32 am

    #1238525

  • RE: Add the headers associated with, and particular fileds.

    Alvin Ramard (10/18/2010)

    I think you'll get much better responses to your questions if you post all the information required to answer your question. I'm not going to go read...

    October 18, 2010 at 10:09 am

    #1238501

  • RE: Import from Excel to .DAT file

    Alvin Ramard (10/14/2010)

    Yes.

    When specifying your filename name, just use .dat for the extension instead of .csv

    I tried to do an example in a similar way, but when I was trying...

    October 15, 2010 at 8:46 am

    #1237608

  • RE: change the values while tranforming

    Alvin Ramard (10/12/2010)

    You could use a conditional split followed by as many derived columns as you need.

    Hey ya, I thought about it..i have many columns which have bit values, I...

    October 12, 2010 at 3:17 pm

    #1235887

  • RE: change the values while tranforming

    Alvin Ramard (10/12/2010)

    preensheen (10/12/2010)

    Hi All,

    Is it possible to chage the values while transforming the values in SSIS. For example...I have bit values coming from database..say 0 & 1 and...

    October 12, 2010 at 1:50 pm

    #1235847

  • RE: Send a mail if the Step Failed in Job

    Chowdary Pulivarthi (10/8/2010)

    Hi,

    I have a job with 4 steps.

    Step1 :

    Step2:

    Step3:

    Step4:

    If my step 3 is failed i need to send a mail and execute the step 4.

    Could you please help me...

    October 8, 2010 at 3:29 pm

    #1234557

  • RE: How to add quotes to string at SSIS level

    Phil Parkin (10/6/2010)

    Specify " as your text qualifier in your flat file destination connection manager.

    hey thanks a lot for the fast response, it worked out for me.:-D:-)

    October 6, 2010 at 10:38 am

    #1232799

  • RE: Dynamic column names at the destination

    Raunak Jhawar (10/5/2010)

    Absolutely, the package flow would resemble as below:

    Original data --> Derived Column Task --> Pivot Task --> Destination

    Hey thanks a lot. Working on it and let you know...

    October 6, 2010 at 10:21 am

    #1232776

  • RE: Dynamic column names at the destination

    getoffmyfoot (10/5/2010)

    preensheen (10/4/2010)

    Hi All,

    How can I have the dynamic column names at the detination, My colums name chages every quater. I mean to say, the date should be added...

    October 5, 2010 at 1:55 pm

    #1232051

  • RE: Dynamic column names at the destination

    laksgovi (10/5/2010)

    What is the Business Intelligence tool you are using? SSRS or SSIS

    SSIS

    October 5, 2010 at 1:52 pm

    #1232048

  • RE: Dynamic column names at the destination

    da-zero (10/5/2010)

    Well, you can't. At least not with out-of-the-box SSIS.

    There are possibly some commercial add-ins that let you achieve this task.

    So basically, you are stuck with scripting. Either in a...

    October 5, 2010 at 7:17 am

    #1231666

Viewing 15 posts - 16 through 30 (of 48 total)