Forum Replies Created

Viewing 15 posts - 781 through 795 (of 893 total)

  • RE: ssrs 2008 - chart

    fmardani-786425 (9/14/2011)


    I have created a chart in ssrs 2008 report.

    The x-axis shows date i.e. 30 jun 2010, etc...

    The dataset returns 18 records and each one has a field...

  • RE: Passing more than one variable to DTexec to run a SSIS package?

    Hi,

    One or two things that needs to change:

    Your code should look like this: Note the change in the variable/value sets.

    ALTER PROC DBO.usp_ProcessClientData (@ClientID int, @ProductLine int)

    AS

    BEGIN

    DECLARE

    @PackagePath varchar(256)

    ,@Cmd varchar(4000)

    SET NOCOUNT ON;

    /*...

  • RE: SSIS Error Code

    john.sliwinski (9/13/2011)


    Thank you for your quick response.

    I am logging the errors to a text file which display:

    1. error code - the negative number I posted

    2. error column - always zero

    3....

  • RE: SDC Wizard Hangs on Getting Dimension Table to Load and Map Columns..

    good_c_ryan_19 (9/13/2011)


    When i Execute Task,it just stay on the slowly changing dimension(yellow) and didn't go through Insert Destination/OLE DB Command.

    I also tried to Run this package as a job on...

  • RE: SSIS Error Code

    john.sliwinski (9/13/2011)


    Does anyone have an idea how to solve an SSIS error code -10716007685? I have searched endlessly for anwers but nothing really worthwhile.

    I am trying to load a...

  • RE: Derive a dimension from source with no business key

    aaa-322853 (9/13/2011)


    Hello,

    I need to create a status dimension. In the source system each job has a status which is a text column selected from a drop down on the front...

  • RE: Model does not open in Report Manager

    tony.aguanno (9/13/2011)


    I appreciate the link - however, I am connected to the server and even the data source populates on the left. But in report builder 1.0 you just...

  • RE: Model does not open in Report Manager

    tony.aguanno (9/12/2011)


    When I select Load in report builder from the manager no dataset selections appear. It appears that you have to go add one.

    Is there any way to...

  • RE: SSAS - Which Products are in which stores?

    BIMind (9/9/2011)


    So of those products in those stores, how would i see my sales broken down by store by product if its not coming from the cube...write group by SQL...

  • RE: Specific Formatting Needs

    checkai (9/9/2011)


    Our firm has an invoice format that pushes some text to the bottom of the page (1st or 2nd; I believe it's the Always at End of Report property)....

  • RE: Model does not open in Report Manager

    tony.aguanno (9/9/2011)


    What I mean when I state that locally all is ok is that I have my local PC configured to run as a server.

    when I log onto the server...

  • RE: SSAS - Which Products are in which stores?

    BIMind (9/9/2011)


    Hi Guys,

    Sorry about my NOOB question. I have taken over a half developed cube. There are 2 dims, stores and products. I need to create something which shows which...

  • RE: Model does not open in Report Manager

    tony.aguanno (9/9/2011)


    on a 2008 server that may not have all of the SSRS components installed

    What if you click on "Open from Report Server"? Do you see the model then?

    I'm still...

  • RE: Model does not open in Report Manager

    tony.aguanno (9/9/2011)


    Yes it makes complete since -what i left out is that once I open report builder in report manager locally -the available tables from the model appear in the...

  • RE: Model does not open in Report Manager

    tony.aguanno (9/9/2011)


    I created a model using SSRS 2008 uploaded the model in report manager and only the properties appear and the Model does not open run. If I choose load...

Viewing 15 posts - 781 through 795 (of 893 total)