Forum Replies Created

Viewing 15 posts - 7,801 through 7,815 (of 13,882 total)

  • RE: Incremental Loading using SSIS

    RonKyle (12/19/2015)

    RonKyle - why won't you use stored procedures to do a final insert?

    I do use stored procedures for the final insert in the sense that there is a...

    December 22, 2015 at 7:13 am

    #1847435

  • RE: Load date time field to date field

    Have a look here.

    This gives you an idea of data type mappings between SQL Server and SSIS.

    The implication of the link is that you should attempt to get your input...

    December 22, 2015 at 7:03 am

    #1847431

  • RE: Are the posted questions getting worse?

    It seems that everyone in this thread spends their spare time shooting things :exclamationmark::-D

    December 22, 2015 at 6:32 am

    #1847419

  • RE: Rollback transaction in SSIS

    Sushant Yadav (12/21/2015)

    Hi All,

    Need your help in below scenario.

    We have SSIS packages which involves Oracle and SQL servers. We have logic like when data is transferred to Oracle from SQL...

    December 22, 2015 at 6:19 am

    #1847415

  • RE: Cast as Numeric

    I was trying to divide by 0

    Let me advise you against that. You'll get an error.

    December 21, 2015 at 2:21 pm

    #1847271

  • RE: Database Design Question

    joshdbguy (12/21/2015)

    I have some developers that want a bunch of fields added to an existing table (it's fairly new) including a GUID field (UUID). My recommendation was that instead of...

    December 21, 2015 at 1:14 pm

    #1847256

  • RE: select * into works but insert into select gives conversion error

    s.kandepi3 (12/21/2015)

    I am inserting some data from a self join CTE into a table. When i do select * into to load data into that table it works fine. But...

    December 21, 2015 at 12:54 pm

    #1847247

  • RE: Restore Backup to a d different Dabase Name

    Welsh Corgi (12/21/2015)

    How do I Restore Backup to a d different Database Name?

    Did you even check BOL for this? It's something which I would expect someone with thousands of SSC...

    December 21, 2015 at 8:45 am

    #1847164

  • RE: T-SQL MERGE INTO

    It's a readability word. You can omit it if you choose (much like the word AS when aliasing columns).

    December 18, 2015 at 12:40 pm

    #1846868

  • RE: Number of Databases per Instance

    butcherking13 (12/18/2015)

    I was looking to see if there is a pattern or average by response to see if I might be better off creating another instance and moving some databases...

    December 18, 2015 at 10:57 am

    #1846845

  • RE: Number of Databases per Instance

    butcherking13 (12/18/2015)

    I was wondering what do you all think or have as an average of databases per instance?

    At what number are you comfortable with before you want to move to...

    December 18, 2015 at 7:44 am

    #1846776

  • RE: How to append data in SSIS file task

    ssisguy (12/17/2015)

    Thanks guys...finally i got it..i just used 2 different connection managers and same file name..it worked out

    We'll done. I'd forgotten about that trick.

    December 17, 2015 at 1:33 pm

    #1846655

  • RE: How to append data in SSIS file task

    Manic Star (12/17/2015)

    i always seem to import things like this to a staging table, then export the results to the file.

    The OP does not mention any requirement for an import.

    December 17, 2015 at 12:07 pm

    #1846639

  • RE: How to load different CSV files to different SQL tables

    only4mithunc (12/17/2015)

    Hi All,

    I have a requirement in which I have multiple CSV files ( columns and data are different in each file ) and I need to load this into...

    December 17, 2015 at 11:12 am

    #1846632

  • RE: How to append data in SSIS file task

    Easiest way I know is to create two separate files and then use an Execute Process task to append one to the other

    copy file1.txt+file2.txt all.txt

    December 17, 2015 at 11:09 am

    #1846630

Viewing 15 posts - 7,801 through 7,815 (of 13,882 total)