Forum Replies Created

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

  • RE: Data Conversion Transformation

    The default setting for truncation is failure / error.

    from MSDN:

    Fail Component The Data Flow task fails when an error or a truncation occurs. Failure is the default option for an...

  • RE: Create Database

    BOL citation:

    FOR ATTACH [ WITH < attach_database_option > ]

    Specifies that the database is created by attaching an existing set of operating system files. There must be...

  • RE: Using the MERGE Statement in SSIS Via a Stored Procedure

    I'd use Slowly Changed Dimension transformation - much simpler for support / development / performance optimization / etc.

  • RE: A Simple way of Automating Scripts

    I mentioned Visual Studio 2010 Ultimate or Premium Editions.

    It has everything you need now - don't wait for 2012:-)

    The only problem - no multi-sever deployment tool

  • RE: A Simple way of Automating Scripts

    Very long discussion... Visual Studio was mentioned just once I'd say...

    Why do not use Visual Studio Database project functionality (with any code version control system)?

    Use normal build functionality, get *.DBSchema...

  • RE: Fun(?) with DATETIME2

    Brandie Tarvin (2/4/2011)


    Toreador (2/4/2011)


    Brandie Tarvin (2/4/2011)

    The trick is that date doesn't actually exist in some countries, including the U.S.

    But given that the date does exist in many other countries, SQLServer...

  • RE: Fun(?) with DATETIME2

    Executed without any problem as it was expected :unsure::Whistling:

    Cannot add screenshot 🙁

    What's the trick - missed point 🙂

  • RE: Creating indexes on computed columns

    Just wonder about user data meaning. If I have user defined table it means that it keeps user defined data.

    Here the very simple example of filtered index on computed column

    CREATE...

  • RE: Sending scheduled SQL query results via HTML e-mail using SSIS

    There is a simpler alternative for using Script Task for emailing - just use Execute SQL Task with the following code

    EXEC msdb.dbo.sp_send_dbmail @recipients='name1@example.com;name2@example.com',

    @subject = @Subj,

    ...

  • RE: SET ROWCOUNT and table variable

    Hugo Kornelis (8/26/2010)


    da-zero (8/26/2010)


    I do not really understand how the scope of the type variable works. It seems you can define it over and over again, without an error being...

  • RE: SSIS Precedence

    Nice one:-)

    We need more BI questions:-)

    Thanks

  • RE: Index Types

    michael.kaufmann (7/22/2010)


    Wayne,

    first of all thank you for compiling a QotD.

    However, I do not quite agree with the solution.

    'Unique' is just taking the definition of a clusterd or non-clustered index a...

  • RE: Predict the outcome

    dbowlin (7/15/2010)


    Not being able to use an increment of 0 makes sense, so an error makes sense.

    What about situations when you need table with the only row 🙂

    Logically thinking system...

  • RE: How to Access SSIS Remotely

    Thanks a lot! Great article!

  • RE: Multi-statement execution

    JosephDMarsh (2/5/2010)


    I chose 4, but (as it turns out) I was guessing. (I thought I knew what was going on, chose an answer and clicked 'Submit' before actually studying...

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