Forum Replies Created

Viewing 15 posts - 151 through 165 (of 7,164 total)

  • RE: Rollback if ETL fails

    moid.hassan (3/2/2016)

    Thanks a lot for your response. I will first try with setting the Transaction Option as required.

    Jeff is offering a scalable solution. Changing your Package to use a transaction...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 3, 2016 at 2:00 am

    #1862654

  • RE: Save file's name into a table

    Jeff Moden (3/2/2016)

    With the normal warnings about using undocumented features (which I frequently do, BTW), the following code will do what you ask and enable you to do more that...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 2, 2016 at 8:41 am

    #1862423

  • RE: Save file's name into a table

    adonetok (3/2/2016)

    Did you post new code?

    Jeff Edited his original post.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 2, 2016 at 8:35 am

    #1862420

  • RE: Save file's name into a table

    adonetok (3/2/2016)

    When I try script below but got an error said: Invalid object name '#order'

    select * from #order

    Lookup xp_cmdshell in Books Online to see the definition of the resultset it...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 2, 2016 at 7:33 am

    #1862386

  • RE: Save file's name into a table

    adonetok (3/2/2016)

    There are about 5000 jpg files stored in a file server in which the length of file's name is the same.

    For example, in server order \\order\2016

    20160101.jpg

    20160110.jpg

    ...

    20160228.jpg

    How to code to...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 2, 2016 at 7:22 am

    #1862382

  • RE: Rollback if ETL fails

    moid.hassan (3/1/2016)

    Hi,

    Need an advice on rolling back the ETL load if anything fails.

    I have a one truncate-and-load ETL process that runs every night, it first truncates the fact tables and...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 1, 2016 at 7:04 pm

    #1862256

  • RE: Extracting time from datetime adds a second? Why?

    jimtimber (2/29/2016)

    Thanks for that, its similar toExcel's datedif fuction (just about). I can use that to work out the exact difference between the different stages of the calls.

    Can I please...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 29, 2016 at 8:27 am

    #1861815

  • RE: Extracting time from datetime adds a second? Why?

    Sergiy (2/28/2016)

    Orlando Colamatteo (2/28/2016)

    Try this instead of going straight to a string:

    DECLARE @D DATETIME = '2016-02-28 19:04:51.997';

    SELECT CAST(CAST(@D AS TIME(3)) AS VARCHAR(8));

    It returns exactly the same result as the original...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 28, 2016 at 9:40 pm

    #1861715

  • RE: Extracting time from datetime adds a second? Why?

    jimtimber (2/28/2016)

    Hello!

    I am trying to extract the hh:mm:ss element of a datetime column of date. The date time column has the following format "dd:mm:yyyy hh:mm:ss".

    I used the convert(varchar (8), MyColumnName,...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 28, 2016 at 7:08 pm

    #1861711

  • RE: Not many DR Options in this case... HELP

    michellefs (2/28/2016)

    I'm working for a customer that has 800 GB data divided in 13 DBs. The have SQL 2008 R2 standard Edition, so cluster is not an option.

    We can only...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 28, 2016 at 7:02 pm

    #1861710

  • RE: Error in merge statement in Tsql

    baiju krishnan (2/27/2016)

    The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches more than one source row. A MERGE...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 27, 2016 at 8:02 am

    #1861629

  • RE: Please help fix this error in SSIS 2008 package, data flow..

    Jeff Moden (2/27/2016)

    Luis Cazares (2/26/2016)

    SSIS won't work correctly with temp tables. You need to use a permanent table for your script.

    Unless there's a workaround using certain settings, but I don't...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 27, 2016 at 7:59 am

    #1861628

  • RE: Please help fix this error in SSIS 2008 package, data flow..

    On your Connection Manager just set the RetainSameConnection property to True so the same connection is used across all your database requests.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 27, 2016 at 7:58 am

    #1861627

  • RE: CAST tinyint to nvarchar

    Steve Jones - SSC Editor (2/26/2016)

    BOL does note this will return an error, but the "E" in the chart is very misleading. I'd say this is one of the poorer...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 26, 2016 at 8:59 am

    #1861432

  • RE: Can a SQL Agent successfully run a job step that deletes that job?

    sgmunson (2/26/2016)

    Or is there an easier way to run as SSIS package just once? Don't want that package hanging around in job form...

    From what context are you trying...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 26, 2016 at 8:56 am

    #1861429

Viewing 15 posts - 151 through 165 (of 7,164 total)