Forum Replies Created

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

  • RE: Error executing SSIS package using xp_cmdshell

    Hi All,

    I got a very weird problem now.

    My etxract is running in bids, it is running is command prompt, it is running in dtexeui, but my package fails when...

    November 26, 2010 at 10:17 am

    #1255856

  • RE: Error executing SSIS package using xp_cmdshell

    Thanks all for the Help.

    I really didn't know where it went wrong..but I redid all the work and it worked.

    November 24, 2010 at 11:20 am

    #1255235

  • RE: Error executing SSIS package using xp_cmdshell

    da-zero (11/23/2010)

    Quoting BOL:

    The Windows process spawned by xp_cmdshell has the same security rights as the SQL Server service account.

    Does this service account has the necessary priviliges to the specified location?

    yes,...

    November 23, 2010 at 7:55 am

    #1254472

  • RE: Error executing SSIS package using xp_cmdshell

    I am able to execute the package in the command prompt...i want to execute the same in SSMS.

    Please advice

    Thanks,

    Preensheen

    November 22, 2010 at 3:34 pm

    #1254097

  • RE: Error executing SSIS package using xp_cmdshell

    da-zero (11/22/2010)

    preensheen (11/22/2010)

    I am not able to identify why i am getting this. Please Advise.

    I have enlighted the important pieces for you:

    Started: 9:17:39 AM

    Error: 2010-11-22 09:17:39.84

    Code:...

    November 22, 2010 at 3:13 pm

    #1254087

  • RE: How to get the result from SP to dataflow task

    John Rowan (10/28/2010)

    preensheen (10/27/2010)

    John Rowan (10/26/2010)

    Data Flow source adapters do allow for SP execution. Does attempting this give you an error?

    Yes, i am trying to pass parameter and and...

    October 29, 2010 at 11:53 am

    #1244365

  • RE: First time SSIS package guy here

    John Rowan (10/25/2010)

    The source adapter can usually glean the result set metadata from nested SP calls, but it sometimes gets confused when there are several nestings and many selects within...

    October 29, 2010 at 8:03 am

    #1244209

  • RE: How to get the result from SP to dataflow task

    preensheen (10/26/2010)

    Hi All,

    My stored procedure results in a table. and now i need to use this result to load the dats to csv. But I am not able to execute...

    October 28, 2010 at 3:31 pm

    #1243879

  • RE: Problem With Header

    John Rowan (10/28/2010)

    Why can't you just include the double quotes in with the header variable? How are you getting the header variable into the file?

    Thanks a lot for all...

    October 28, 2010 at 3:28 pm

    #1243875

  • RE: Problem With Header

    GSquared (10/21/2010)

    preensheen (10/20/2010)

    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...

    October 28, 2010 at 12:21 pm

    #1243767

  • RE: Today's Random Word!

    traction

    October 27, 2010 at 8:53 am

    #1242952

  • RE: How to get the result from SP to dataflow task

    John Rowan (10/26/2010)

    Data Flow source adapters do allow for SP execution. Does attempting this give you an error?

    Yes, i am trying to pass parameter and and everything correctly but...

    October 27, 2010 at 8:14 am

    #1242914

  • RE: stored procedure not working in Execute Sql Tak

    da-zero (10/26/2010)

    The reason why it works in SSMS is because your connection is still open, so you can still access the global temp table ##temp.

    In SSIS however, the connection manager...

    October 26, 2010 at 11:38 am

    #1242466

  • RE: Foreach loop in SSIS package

    ranganathan.arumugham (10/15/2010)

    Hi guys,

    I need to perform a loop operation that Retreives data set for each user from data base and perform some operation. please provide me with some helpful links....

    October 26, 2010 at 10:03 am

    #1242397

  • RE: Table Variable as output parameter in SP

    ChrisM@home (10/26/2010)

    Prassad Dabbada V R (10/26/2010)

    Where is the question? or the topic itself is question?

    It's the invisible man skiing.

    Please ignore the topic...I didn't find a way to delete the topic...

    October 26, 2010 at 9:45 am

    #1242384

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