Forum Replies Created

Viewing 15 posts - 46 through 60 (of 3,366 total)

  • RE: Adding Quotes around Every Column

    Koen Verbeeck (7/6/2011)


    Gift Peddie (7/6/2011)


    Vertigo44 (7/6/2011)


    Gift Peddie (7/6/2011)


    Vertigo44 (7/6/2011)


    Thanks! I eventually got it to work by using "\"" + CHG_PATNUM + "\"" in the Derived Column expression box.

    Funny you added...

    Kind regards,
    Gift Peddie

  • RE: Adding Quotes around Every Column

    Vertigo44 (7/6/2011)


    Gift Peddie (7/6/2011)


    Vertigo44 (7/6/2011)


    Thanks! I eventually got it to work by using "\"" + CHG_PATNUM + "\"" in the Derived Column expression box.

    Funny you added a derived task when...

    Kind regards,
    Gift Peddie

  • RE: Adding Quotes around Every Column

    Vertigo44 (7/6/2011)


    Thanks! I eventually got it to work by using "\"" + CHG_PATNUM + "\"" in the Derived Column expression box.

    Funny you added a derived task when you can just...

    Kind regards,
    Gift Peddie

  • RE: How to open .rdl to view xml in BIDS properly

    You should be able to open them in BIDs if you are not then something is wrong with your Visual Studio solution file, that is the file used to render...

    Kind regards,
    Gift Peddie

  • RE: Junk characters coming doing query from oracle server

    suresh.guglani (7/2/2011)


    While doing query to oracle through linked server degree symbol(°) is getting converted to question symbol(¿) .

    I have set remote collation to true in linked server definition & the...

    Kind regards,
    Gift Peddie

  • RE: Connecting developer to remote SSIS server

    David Webb-200187 (6/22/2011)


    Seriously? I just want them to connect to the SSIS server so they can extract packages, work on the locally, and then import them back. For...

    Kind regards,
    Gift Peddie

  • RE: Connecting developer to remote SSIS server

    David Webb-200187 (6/22/2011)


    I'm stumped on this one. I've set the correct dts role in msdb, and I've gone through the DCOM steps, but I still have to make the...

    Kind regards,
    Gift Peddie

  • RE: Need new laptop

    Thanks for the advice so I could use solid state drive instead of more memory. I will update as soon as I get the new box.

    😎

    Kind regards,
    Gift Peddie

  • RE: Multi column report in rdlc

    usharani.t (6/6/2011)


    i want to display record like this

    column1 coloumn2 column3

    1staddr 2nd addr thirdaddr

    RDLC means running the report in the ReportViewer control which...

    Kind regards,
    Gift Peddie

  • RE: Lessons Learned Pay Off

    Certification is a funny thing. Although the MS exams actually require quite a lot of work to pass, let's not forget that certification is essentially a vendor revenue stream....

    Kind regards,
    Gift Peddie

  • RE: Multi column report in rdlc

    Here are the 2010 samples but I am not sure what you mean by multi column because the Reportviewer control can be used to create reports against most RDBMS using...

    Kind regards,
    Gift Peddie

  • RE: SSIS reading cXML document

    nil-364356 (5/13/2011)


    dear experts,

    is there any way we can read and generate cXML using SSIS Package?

    Thanks

    Here is Biztalk schema see if you can consume it in XML data flow task because...

    Kind regards,
    Gift Peddie

  • RE: Reporting Services Installation (Option Greyed Out in Setup Dialog)

    david.Parsons 36778 (5/18/2011)


    Windows Authentication and Request Filtering are both selected in the Security options. All other Security features are off.

    What I am wondering is:

    1) Does Reporting Services have any other...

    Kind regards,
    Gift Peddie

  • RE: Competing with an MBA

    MBA - we have more VPs, Directors than IT workers?, who is going to do the real work? With US trade deficit thru the roof, are we ever going to...

    Kind regards,
    Gift Peddie

  • RE: Sum iif in Report Builder 2.0

    clarmatt73 (5/17/2011)


    Hi Charles,

    Thanks for the response, unfortunately i've tried that and still got the same error, all i'm getting is #error where the figure should be in the report.

    The actual...

    Kind regards,
    Gift Peddie

Viewing 15 posts - 46 through 60 (of 3,366 total)