Forum Replies Created

Viewing 15 posts - 7,741 through 7,755 (of 13,882 total)

  • RE: executing dynamic DDL for each object in my database...

    Or, if the copy really is 'almost' the same, perhaps you could consider generating an exact copy and then applying the changes to that.

  • RE: read file *.db, *.px paradox from ssis

    Perhaps you would be so good as to re-read my question & try again.

  • RE: Integration Services & Multiple Developers

    ElNevera (1/7/2016)


    Phil Parkin (1/7/2016)


    So, do your development using Windows Auth and then use an SSISDB Environment to reconfigure the connections accordingly after deployment, so that they work on the server.

    Thanks...

  • RE: Integration Services & Multiple Developers

    ElNevera (1/7/2016)


    Phil Parkin (1/7/2016)

    Is there a reason you're not using Windows Authentication?

    Whilst initially setting up the packages we were using Windows Authentication but when I deployed the packages to SQL...

  • RE: read file *.db, *.px paradox from ssis

    dramon14 (1/7/2016)


    Friends , I need to read files * .db and * .px ( paradox ) through a process of SSIS ( dtsx ) , so far I could not...

  • RE: Integration Services & Multiple Developers

    ElNevera (1/7/2016)


    Hello

    I work in a newly created BI team. We have experience using Business Objects for ETL and some development experience using Visual Studio 2013 and TFS. We are using...

  • RE: Are the posted questions getting worse?

    Michael L John (1/6/2016)


    Ed Wagner (1/6/2016)


    Sean Lange (1/6/2016)


    Ed Wagner (1/6/2016)


    Brandie Tarvin (1/6/2016)


    Sean Lange (1/6/2016)


    Wow. I rarely have to deal with user issues but I was just on a phone call...

  • RE: Are the posted questions getting worse?

    Alvin Ramard (1/6/2016)


    Jeff Moden (1/6/2016)


    Brandie Tarvin (1/6/2016)


    djj (1/5/2016)


    SQLBill (1/5/2016)


    If I hear of any openings anywhere that allow full work from home, I'll pass them your way.

    -SQLBill

    There all over the internet.:-P...

  • RE: Are the posted questions getting worse?

    Sean Lange (1/6/2016)


    Wow. I rarely have to deal with user issues but I was just on a phone call with one of our own people having an issue with our...

  • RE: Selecting a decimal

    sql_only (1/6/2016)


    Phil Parkin (1/6/2016)


    sql_only (1/6/2016)


    Phil Parkin (1/6/2016)


    sql_only (1/6/2016)


    was missing DECIMAL(18,16)...

    Might as well use (19,16) or (19,17) – same space occupied on disk (ref. here).

    Yes you're right.

    I have had to...

  • RE: Selecting a decimal

    sql_only (1/6/2016)


    Phil Parkin (1/6/2016)


    sql_only (1/6/2016)


    was missing DECIMAL(18,16)...

    Might as well use (19,16) or (19,17) – same space occupied on disk (ref. here).

    Yes you're right.

    I have had to settle with 2...

  • RE: advantages of having multiples files in a filegroup

    Hugo Kornelis (1/6/2016)


    GilaMonster (1/6/2016)


    On the same disk, none at all.

    ... in most scenarios.

    If you have a database that has a very high amount of table allocations and deallocations, you can...

  • RE: Selecting a decimal

    sql_only (1/6/2016)


    was missing DECIMAL(18,16)...

    Might as well use (19,16) or (19,17) – same space occupied on disk (ref. here).

  • RE: Header and Detail Data

    bpowers (1/5/2016)


    Ok I have two separate data flow tasks setup and can manually fire them off to populate the flat file. How do I set this up to run the...

  • RE: SQL SERVER 2014 - View value changes depending on the date

    antonio_scp125 (1/5/2016)


    SSCertifiable thanks for your response! You're right and I didn't explain very well the situation.

    Every time that a record are insert in the table, the flag New_Player be equal...

Viewing 15 posts - 7,741 through 7,755 (of 13,882 total)