Forum Replies Created

Viewing 15 posts - 511 through 525 (of 5,678 total)

  • RE: SQL query works in SSIS, SSMS/SQL server but fails in deployment?

    When you login to the VM, find the 'My Computer' or 'Computer' icon. Rt-Click that, go to manage. In the window that comes up, go to "Services and...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    January 16, 2014 at 12:41 pm

    #1680825

  • RE: SQL query works in SSIS, SSMS/SQL server but fails in deployment?

    blasto_max (1/16/2014)

    I don't have any knowledge of administration. Can you point me to some guide which could help me to perform the troubleshooting which you mentioned ?

    Eg. how do...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    January 16, 2014 at 11:58 am

    #1680811

  • RE: SQL query works in SSIS, SSMS/SQL server but fails in deployment?

    blasto_max (1/16/2014)

    It is failing when I deploy it into SQL server agent and manually execute via rt-click > start job at step.

    Okay, definately running under the agent then, if...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    January 16, 2014 at 11:35 am

    #1680802

  • RE: SSIS Package

    yashuvp (1/16/2014)

    Perfect, this saved me lot of time and energy. Much Appreciated.

    Thanks,

    Yash

    My pleasure, glad I could help.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    January 16, 2014 at 11:22 am

    #1680798

  • RE: Reading Text File in package and executing SQL Statement

    blasto_max (1/16/2014)

    I wonder why someone would provide this in a text file (or even in a database table - i've seen this). Is there a better way to do the...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    January 16, 2014 at 11:21 am

    #1680797

  • RE: SQL query works in SSIS, SSMS/SQL server but fails in deployment?

    Is the deployment failing when you deploy the package to the MSDB server and manually execute via Rt-Click, or when you schedule it via the Agent?

    If it's the Agent, make...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    January 16, 2014 at 11:17 am

    #1680794

  • RE: Reading Text File in package and executing SQL Statement

    skunapuli 98471 (1/16/2014)

    Hi Team, my client provides a text file which contains multiple sql statements.

    Whut? Why? ... but alright.

    I need to loop through all of them execute the...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    January 16, 2014 at 11:13 am

    #1680792

  • RE: SSIS Package

    You're using DTExecUI (User Interface), which is why.

    What you want is plain old DTExec:

    http://technet.microsoft.com/en-us/library/ms162810(v=sql.105).aspx

    By the by, why not just use a job and the SSIS step in SQL Agent?

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    January 16, 2014 at 11:07 am

    #1680784

  • RE: One script to drop all temporary tables

    TheSQLGuru (1/16/2014)

    Why do you want a script to do this? Temp objects are automatically "managed" by the engine. Just close the connection and you don't have to worry...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    January 16, 2014 at 10:55 am

    #1680777

  • RE: what is the order of execution of a sql statement with GO statements?

    JP10 (1/16/2014)

    Hello,

    Curious if I have the code below as an example and I execute this code does sql execute from top to bottom? And does the Update run and...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    January 16, 2014 at 10:52 am

    #1680771

  • RE: Avoid ISNumeric and dealing with Nullable Columns

    I'm not overly familiar with enlight, but your approach seems reasonable. The big deal with that is the scientific float items (1.03E-12) which may/may not fit into the target....

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    January 16, 2014 at 10:42 am

    #1680769

  • RE: We're not craftsmen and craftswomen

    I'm glad y'all have environments with space that let you validate your backups. Round here, I'm on the 'pray it worked' method, because I have no place to put...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    January 16, 2014 at 10:30 am

    #1680763

  • RE: We're not craftsmen and craftswomen

    It's wierd, but when I saw the title to this article I had thought this would be chasing a different concept. One where we SHOULDN'T be craftspeople, because right...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    January 15, 2014 at 12:25 pm

    #1680408

  • RE: Creating job to run SSIS package Remotely

    jude.pieries (1/9/2014)

    HI

    This link will give you most of the instructions of executing a SQL job remotely.

    http://judepieries.blogspot.co.nz/2013/09/how-to-execute-sql-job-remotely.html

    Hope this is what you are looking for.

    Thanks

    Jude

    Please note, that's remote execution of...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    January 10, 2014 at 3:27 pm

    #1679336

  • RE: Snapshot Isolation Level - Too good to be true?

    Bad_Karma (1/10/2014)

    Thanks for the heads-up, however what I was considering was leaving the default database isolation level as-is, and instead just declaring the isolation level on all of my SSRS...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    January 10, 2014 at 3:25 pm

    #1679335

Viewing 15 posts - 511 through 525 (of 5,678 total)