Forum Replies Created

Viewing 15 posts - 9,436 through 9,450 (of 13,877 total)

  • RE: SSIS Licensing Question

    ducon (1/13/2014)

    Your powers of observation are quite strong despite the look of your profile pic ;).

    I was commenting on the old post about the need to troubleshoot and debut packages...

    January 13, 2014 at 10:03 pm

    #1679778

  • RE: Incluse Saturday and Sunday in calculation

    You've been a member of this forum long enough to know that you need to provide DDL, sample data and desired results in a consumable format in order to get...

    January 13, 2014 at 2:27 pm

    #1679721

  • RE: Cannot load into table having identity column - INSERT fails

    Lempster (1/13/2014)

    Phil Parkin (1/12/2014)

    Your error message suggests that you do not have the correct (or any) version of SQL Server Data Tools (SSDT) installed - please check that. It's not...

    January 13, 2014 at 10:05 am

    #1679645

  • RE: SSIS Licensing Question

    ducon (1/13/2014)

    You should look into SSIS configuration files. they are simple XML files. This way you can have prod and dev configurations that you substitute based on the environment where...

    January 13, 2014 at 8:42 am

    #1679607

  • RE: Cannot load into table having identity column - INSERT fails

    polkadot (1/12/2014)

    I installed BIDS 2012 but I think it just integrates Visual Studio 2010 within it's shell, and in my case it detects my 2010 packages but when I try...

    January 12, 2014 at 10:43 pm

    #1679491

  • RE: File import to table in Unix

    Thanks for getting into deeper

    Few of the rows , first column coming as empty . But do you think in SSIS or Excel this will be a issue as there...

    January 12, 2014 at 11:47 am

    #1679457

  • RE: File import to table in Unix

    If there is no problem,output would be

    C1 C2 C3 C4 C5

    NULLUSD1542.5214536xxxx

    NULL NULL1542.5214536NULL

    EUR NULL 1542.52 14536 xxxx

    Great, that helps.

    Now my question is: why in the above is there a NULL after...

    January 12, 2014 at 11:16 am

    #1679453

  • RE: File import to table in Unix

    sql crazy kid (1/12/2014)

    Phil Parkin (1/12/2014)

    Columns are not missing here . I have 5 column here ,looks like this.

    [Just a sample data ,but this is the format we load]

    col1...

    January 12, 2014 at 10:57 am

    #1679446

  • RE: File import to table in Unix

    Columns are not missing here . I have 5 column here ,looks like this.

    [Just a sample data ,but this is the format we load]

    col1 col2 col3 col4 col5

    USD1542.5214536xxxx

    1542.5214536

    EUR 1542.5214536xxxx

    What...

    January 12, 2014 at 10:50 am

    #1679443

  • RE: File import to table in Unix

    Here is few more details

    Backend - SQL server 2008 R2,SSIS installed

    OS - Unix Env

    We have many process running on unix ,connecting to sql server , BCP into sql tables ,...

    January 12, 2014 at 9:57 am

    #1679437

  • RE: File import to table in Unix

    sql crazy kid (1/12/2014)

    Phil Parkin (1/12/2014)

    Is there any way we can use ssis ?

    To do what, precisely?

    As you have given no examples of the data which is giving you problems,...

    January 12, 2014 at 9:00 am

    #1679431

  • RE: File import to table in Unix

    Is there any way we can use ssis ?

    To do what, precisely?

    As you have given no examples of the data which is giving you problems, providing any sort of useful...

    January 12, 2014 at 8:18 am

    #1679423

  • RE: SSIS Any-Query-to-Excel Worksheet?

    i couldn't seem to find a 2008 SSIS forum.

    No, there isn't one - at least last time I checked. But there is a generic SSIS forum here which seems to...

    January 11, 2014 at 6:16 am

    #1679365

  • RE: SSIS Any-Query-to-Excel Worksheet?

    Lowell (1/10/2014)

    I've got just enough exposure to SSIS to think the following is true: an SSIS project defines all it'sc olumns and datatypes before it does anything like insert them...

    January 11, 2014 at 5:23 am

    #1679362

  • RE: Want to update the table performance vice which transformation is best to use

    sharmili.net (1/10/2014)

    why should not use OLEDB cmd since its processing each row..or any other specific reason is there?

    That is the reason.

    January 10, 2014 at 1:55 am

    #1679063

Viewing 15 posts - 9,436 through 9,450 (of 13,877 total)