Forum Replies Created

Viewing 15 posts - 76 through 90 (of 101 total)

  • RE: Need example to execute stored procedure using script task.

    Hi Sharath,

    Thank you. I have tried with your code.

    cn.Open "DSN=BI_Database;UID=" & DTSGlobalVariables("gstrTargetLogin").Value & ";PWD=" & DTSGlobalVariables("gstrTargetPassword").Value

    Here "BI_Database" is data source. I'm able to open connection successfully when I use...

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

    May 3, 2010 at 3:42 am

    #1161158

  • RE: Need example to execute stored procedure using script task.

    Hi Sharath,

    Thanks for your response. Yes I want to use Script Task. Can you provide me sample code.

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

    April 30, 2010 at 2:05 am

    #1160257

  • RE: Error when running Execute SQL Task

    Hi,

    Thanks for your response. I have changed connection from ODBC to ADO.NET. Now it started working.

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

    April 30, 2010 at 1:08 am

    #1160243

  • RE: DateTime Trick

    Interesting..:w00t:

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

    October 27, 2009 at 4:16 am

    #1071099

  • RE: error in dts package while executing through jobs?????Need immediate reply

    Hi,

    check your data sources and linked servers once.

    KSB.

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

    August 21, 2009 at 4:27 am

    #1042679

  • RE: Proxy Account

    If I executeEXEC xp_cmdshell 'dir *.exe';

    GO it is working fine.

    And if I execute BCP job I'm getting error.

    Thanks for reply

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

    August 13, 2009 at 5:27 am

    #1038610

  • RE: Proxy Account

    This link might assist you: http://www.dbnewsgroups.net/group/microsoft.public.sqlserver.programming/topic16744.aspx

    I have tried this too..

    EXEC sp_configure 'show advanced options', 1

    GO

    RECONFIGURE

    GO

    EXEC sp_configure 'xp_cmdshell', 1

    GO

    RECONFIGURE

    GO

    exec sp_xp_cmdshell_proxy_account 'domain\user', 'password'

    Still getting same error.

    Thanks,

    KSB

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

    August 13, 2009 at 4:13 am

    #1038576

  • RE: Proxy Account

    Thanks for reply.

    Try using GRANT EXECUTE on xp_cmdshell to [india\xg536]

    Executed fine but same results. Getting the following error [p]Error string: [Microsoft][ODBC SQL Server Driver][SQL Server]The EXECUTE permission was denied...

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

    August 12, 2009 at 11:53 pm

    #1038472

  • RE: character limitations on sp name, & function name

    Hi,

    Maximum length for stored procedures and functions name is 128.

    Always choose name as meaningful and as much as short.

    Thanks,

    KSB.

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

    August 12, 2009 at 12:42 am

    #1037859

  • RE: Display columns as Rows

    Hi,

    You can use PIVOT. Check this link:

    http://msdn.microsoft.com/en-us/library/ms177410.aspx

    KSB.

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

    July 28, 2009 at 4:44 am

    #1030943

  • RE: Reporting Services Color Property

    Hi,

    Keep the same in color property and change text box Expression as

    IIf(Fields!DocNumbr.Value)=NULL,"Invoice Not Raised",Fields!DocNumbr.Value)

    KSB.

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

    July 27, 2009 at 6:26 am

    #1030453

  • RE: Error in SQL Job

    Hi,

    Check whether your servers are linked in Server Objects -> Linked Servers

    and also verify protocols TCP/IP and Named Pipes are enabled or not.

    KSB.

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

    July 27, 2009 at 6:12 am

    #1030448

  • RE: problem with ROUND()

    Hi Lowell,

    Thanks for the resolution.

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

    July 27, 2009 at 5:56 am

    #1030440

  • RE: problem with ROUND()

    Hi Lowell,

    Thanks for quick reply and it is working fine for decimal.

    What about for float..?

    Thanks.

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

    July 27, 2009 at 4:55 am

    #1030422

  • RE: Need update query to update the same table

    Hi GSquared,

    Yeah, your query helped me. And now i have to update the same to the same table and need to delete the second row.

    Thanks.

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

    April 9, 2009 at 11:40 pm

    #975575

Viewing 15 posts - 76 through 90 (of 101 total)