Forum Replies Created

Viewing 15 posts - 16 through 30 (of 96 total)

  • RE: WSDL link in SSIS

    keywestfl9 (8/13/2010)

    For each environment the wsdl link differs, i want to be doing it outside the package by changing the link based on the migration of the package to different...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    August 13, 2010 at 12:54 pm

    #1206877

  • RE: Package fails with ERRORLEVEL(-1073741819) when deployed in Server

    Suresh.Utham (8/13/2010)

    Hi All,

    I've deployed a package in SQL 2005. When i try to execute, it's getting following error without any subsequent processing.

    ERROR - SSIS package <<<Package Name>>> failed ERRORLEVEL(-1073741819)

    When...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    August 13, 2010 at 12:49 pm

    #1206874

  • RE: How to display a pause and warning message in SSIS

    tripower (8/13/2010)

    OK, I did that with a VB scrip message box that has an OK and Cancel button but how to I cancel execution of the package if the user...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    August 13, 2010 at 12:35 pm

    #1206863

  • RE: Issue regarding stored procedure

    river22_34 (8/13/2010)

    Hi,

    Will this command work if I am in another database for ex, If I am in "SQL_Training" database will it get executed in this database ? or do i...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    August 13, 2010 at 9:12 am

    #1206722

  • RE: Issue regarding stored procedure

    river22_34 (8/12/2010)

    Hi,

    I am getting this message when i executed this SP by using xp_cmdshell

    "Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    August 13, 2010 at 8:46 am

    #1206704

  • RE: How to display a pause and warning message in SSIS

    tripower (8/13/2010)

    I wanted to create a pause with a warning message at the beginning of certain packages due to the potential impact on the database. How would I do this...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    August 13, 2010 at 8:42 am

    #1206695

  • RE: Issue regarding stored procedure

    river22_34 (8/12/2010)

    Hi,

    can you also provide me the code on how to call dtexec in a stored procedure and run it using xp_cmdshell command . The entire code ?

    I found this...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    August 12, 2010 at 12:34 pm

    #1206282

  • RE: Issue regarding stored procedure

    river22_34 (8/12/2010)

    Hi,

    Thanks for your prompt reply.

    Could you provide me the steps on how to do this in SQL Server agent ?

    1. Connect to the sql server database engine from where...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    August 12, 2010 at 12:24 pm

    #1206267

  • RE: SSIS Package not using the XML Config File

    Once you change or edit the config file, and then copy it up to the SSIS server, you need to remove and add the file back into the SQL Job,...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    August 12, 2010 at 12:18 pm

    #1206263

  • RE: Issue regarding stored procedure

    river22_34 (8/12/2010)

    Hi,

    In regards to running the SP, here's how i plan to do it.

    - I can update or insert any row in the excelsheet and then save it.

    - Next I...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    August 12, 2010 at 11:52 am

    #1206243

  • RE: SSIS Package not using the XML Config File

    AndrewSQLDBA (8/12/2010)

    You can do that. I thought the same thing, until I started looking thru the actual XML code that is generated. All that you really have to do is...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    August 12, 2010 at 9:56 am

    #1206144

  • RE: Issue regarding stored procedure

    set @sql = ''

    set @sql = 'exec C:\Documents and Settings\varunj\My Documents\Visual Studio 2008\Projects\Integration Services Project2\Integration Services Project2\Package.dtsx'

    --exec (@sql)

    You can't run the SSIS package using exec command. You need to call...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    August 12, 2010 at 9:44 am

    #1206127

  • RE: MOVE SSIS PACKAGES from Development to Production server...

    sql_freak (8/11/2010)

    Hi Guys

    I am new to SSIS

    Current situation in company

    They have SSIS packages which are already been deployed in production server, But 2day we found one package in...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    August 12, 2010 at 8:40 am

    #1206050

  • RE: Creating tables on the fly with SSIS

    Phil Parkin (8/11/2010)

    But if the table doesn't exist at design time, you can't create the dataflow.

    have done data population dynamic using DTS... We pulled the column info using systables from...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    August 11, 2010 at 9:37 am

    #1205461

  • RE: Creating tables on the fly with SSIS

    tripower (8/11/2010)

    I wanted to create a set of tables on the fly using a SQL script can I do this via an Execute SQL task or is there a better...

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

    August 11, 2010 at 9:34 am

    #1205457

Viewing 15 posts - 16 through 30 (of 96 total)