Forum Replies Created

Viewing 15 posts - 7,591 through 7,605 (of 13,877 total)

  • RE: SSIS error

    PSB (2/5/2016)


    Hi,

    Integration: Error at server : XYZ. The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

    The sample URL used is :

    https://teamspace.abc.com/sites/LLL/LLL-SAP/SARNew/Archive/_vti_bin/listdata.svc

    We access the...


  • RE: Physical or VM - ODS

    SQL!$@w$0ME (2/4/2016)


    Hi Guys,

    Could you please give some guidance on selecting hardware for a new DB server. This will be a new Operational Data Store setup. Expecting moderate ETL load (SSIS...


  • RE: Are the posted questions getting worse?

    Michael L John (2/4/2016)


    Grumpy DBA (2/4/2016)


    Michael L John (2/4/2016)


    GilaMonster (2/4/2016)


    jasona.work (2/4/2016)


    Man, there's a reply to one of my topics (which really already has been answered, although Gail raised an important...


  • RE: Are the posted questions getting worse?

    jasona.work (2/4/2016)


    Luis Cazares (2/4/2016)


    jasona.work (2/4/2016)


    Man, there's a reply to one of my topics (which really already has been answered, although Gail raised an important point) by CELKO, and I can't...


  • RE: Select Latest record by comparing 2 tables.

    For each combination of machine/instance?


  • RE: Select Latest record by comparing 2 tables.

    kavithaje (2/4/2016)


    Sorry i did not understand clearly.

    Can you please give me some real example with the below query?

    Thanks in advance.

    Without knowing your table structures, the examples provided are as real...


  • RE: Are the posted questions getting worse?

    Grant Fritchey (2/4/2016)


    Grumpy DBA (2/4/2016)


    In the past I worked with a couple developers (SQL and Oracle) who used Select * quite often. At every code review I would point...


  • RE: Select Latest record by comparing 2 tables.

    John Mitchell-245523 (2/4/2016)


    WITH Combined AS (

    SELECT Timestampcol, <other columns>, 'Table1' AS TableName

    FROM Table1

    UNION ALL

    SELECT Timestampcol, <other columns>, 'Table2'

    FROM Table2

    )

    SELECT Timestampcol, <other columns>, TableName

    FROM Combined

    John

    I think you might need to extend...


  • RE: Compability level

    Edvard Korsbรฆk (2/4/2016)


    Well, I found the correct answer in the end.

    checked on the DB, which was used by the customer - it had level 110.

    Next question is of cause, what...


  • RE: What is the True Version of Code?

    Orlando Colamatteo (2/3/2016)


    removed silly post...

    Your own, presumably? ๐Ÿ™‚


  • RE: Compability level

    You seem to have found the correct answer, using the wrong technique ๐Ÿ™‚

    Different versions of SQL Server support different compatibility levels (see here).

    Within a SQL Server instance, databases can have...


  • RE: Source control with SSIS

    Have a look at TFS Power Tools.

    You'll need to select the correct version for your environment. Once you've done that, you'll get a certain amount of TFS functionality available to...


  • RE: Running SSIS packages from CMS server on target servers

    Orlando Colamatteo (2/3/2016)


    SQL_Surfer (2/2/2016)


    I've about 200 SSIS packages that needs to be run on 10 different instances. What is the best way to configure this dynamically? Ideally I'd like to...


  • RE: FTP with Configuration Manager for Connection String

    Dave R (UK) (2/3/2016)


    Currently not running 2012 so not an option ๐Ÿ™

    Really frustrated as the solution works with the one exception of multiple lines in configuration table

    OK. Then you are...


  • RE: Running SSIS packages from CMS server on target servers

    I just had another idea, which may or may not work in practice.

    Create a 'master' package. This package searches a specific local folder and executes any packages it finds there.

    Deploy...


Viewing 15 posts - 7,591 through 7,605 (of 13,877 total)