Forum Replies Created

Viewing 15 posts - 1 through 15 (of 32 total)

  • RE: Help with Multiple Parameter

    Hi Thomas,

    You can try similar logic for splitting the coma delimited value to rows.

    ---

    DECLARE @delimitedstring varchar(8000) = '-ALL- -99,Race 01,Ethnicity 02,Gender 03'

    DECLARE @xmlvalue xml

    set @xmlvalue = N'<root><r>' + replace(@delimitedstring,',','</r><r>') +...

    January 2, 2014 at 9:02 pm

    #1677104

  • RE: Create a Calculated Member in existing Cube

    Hi,

    I did the calculated measure changes, new claculated members usign AMO.

    I tried using Script task of the SSIS 🙂

    Please find the sample code to edit a named SET in...

    August 29, 2008 at 9:45 am

    #865112

  • RE: Create a Calculated Member in existing Cube

    Thanks for your reply.

    I may not be able to use BIDS here.. We need to customize OR chage the calculated members during / after the cube deployment.

    Fro Ex: Dynamic Time...

    August 28, 2008 at 8:16 pm

    #864809

  • RE: Running Packages in Management Studio

    Hi Ruth,

    There is a better and simple approach wich we can avoid 'Script Task' (I used Script task along with some other requirements)

    If your ServerName (Initial Catalog),LoginID and Password are static...

    January 11, 2007 at 11:37 pm

    #682818

  • RE: Running Packages in Management Studio

    Hi Ruth,

    I have followed two approaches to resolve this problem.

    1. Used only domain accounts (windows authentication) for initializing the Connection managers (I have noticed that, this issue arising only when we...

    January 10, 2007 at 11:03 pm

    #682612

  • RE: Running Packages in Management Studio

    Hi Ehlinger,

    I can give some insights for this problem.

    Please check the Service startup login for the 'SQL Server Agent' and make sure that same login is present in 'SQL Server' with enough credentials.

    I...

    January 10, 2007 at 8:34 am

    #682398

  • RE: how to use alter table command to change the column''''s datatype from money to varchar

    Hi Shweta,

    This is the genral command to do so.

    Alter

    table Test_Table alter column Col1

    January 10, 2007 at 6:13 am

    #682346

  • RE: Transactions in SSIS

    Hi Chirag,

    I couldn't simulate the problem.

    I just set the trasaction options you have provided. ('Required' to package and 'supported' to all three SQL Tasks). 

    For me first two tasks are running successfully...

    January 10, 2007 at 5:51 am

    #682342

  • RE: Running Packages in Management Studio

    Hi Ehlinger,

    I was also facing a similar kind of problem while running a package from production environment, even though it is executed successfully from my development environment (BI studio on...

    January 10, 2007 at 5:38 am

    #682340

  • RE: Select Records then run report

    Hi Smith,

    My understanding of the problem above mentioned is:

    1. You wanted to retrieve Dataset by passing multi values (selected by user from a check box list)

    2. Parameter will be coma delimited Ex:'1,2,3,4,5,6' 

    Generic Solution:

    I am also faced a...

    January 8, 2007 at 7:47 am

    #681759

  • RE: Trusted Connection Issue

    Hi All,

    First of all thanks for Lynn for the reply.

    We have resolved the issue. There was nothing to do with VPN, Logins, and Domains etc.

    Issue is with the client operating system...

    October 6, 2006 at 7:38 am

    #664594

  • RE: Accessing Data from AS/400 System

    Hello Greg,

    Thanks a lot for your information.

    I have downloaded the driver from the link given by you.

    Regards

    Agson Chellakudam

    September 20, 2006 at 8:12 am

    #661503

  • RE: Accessing Data from AS/400 System

    Thanks a lot Jimmy and Fernado for the replies.

    Can you please give me some more information?

    I am not able to find db2 driver on my OS (Windows 2000 Sp 4). As...

    September 19, 2006 at 8:37 am

    #661283

  • RE: DtExec Command

    Hi Markus

    First of All Sorry for the delay in replying..

    Legacy DTSs are running fine with 'Dtsrun' command.

    Thanks for the information!.

    Regards

    Agson Chellakudam

    August 8, 2006 at 1:07 am

    #653771

  • RE: Report Model from Analysis Services Project

    Hi Myles

    Thanks for your reply

    It is working fine.

    Regards

    Agson Chellakudam

    July 13, 2006 at 12:30 am

    #648872

Viewing 15 posts - 1 through 15 (of 32 total)