SSIS

  • kapfundestanley

    SSCertifiable

    Points: 5627

    Comments posted to this topic are about the item SSIS

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • Mr. Kapsicum

    SSCertifiable

    Points: 6128

    easy , very easy. 🙂

  • Koen Verbeeck

    SSC Guru

    Points: 258907

    EZ PZ 😀

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • This was removed by the editor as SPAM

  • Carlo Romagnano

    SSC-Insane

    Points: 21711

    Easy, if you know it.

  • sqlnaive

    SSCoach

    Points: 17435

    Hippey... As I am into learning phase in SSIS, so happy to get it right. Very good question. 🙂

  • Michael Riemer

    SSCarpal Tunnel

    Points: 4795

    Although easy if you know it and logical if you don't (since the other three aren't actually database tasks).

    I don't think the documentation is very clear in highlighting the limitation, as the first bullet point explains:

    Specify the OLE DB connection manager to connect to the destination SQL Server database and the table or view into which data is inserted. The Bulk Insert task supports only OLE DB connections for the destination database.

    This can be kind of misleading when referencing only OLE DB, since you can access most databases through OLE DB. It may be worth expanding on the fact that it references the SQL Server Bulk Insert functionality, which isn't present on other databases.

  • TomThomson

    SSC Guru

    Points: 104762

    Michael Riemer (10/10/2013)


    Although easy if you know it and logical if you don't (since the other three aren't actually database tasks).

    I don't think the documentation is very clear in highlighting the limitation, as the first bullet point explains:

    Specify the OLE DB connection manager to connect to the destination SQL Server database and the table or view into which data is inserted. The Bulk Insert task supports only OLE DB connections for the destination database.

    This can be kind of misleading when referencing only OLE DB, since you can access most databases through OLE DB. It may be worth expanding on the fact that it references the SQL Server Bulk Insert functionality, which isn't present on other databases.

    I think somehow that "OLE DB connection manager ot connect to the destination SQL Server database" kind of gives it away, since "the destination SQL Server database" is an SQL Server database and hence not an Oracle or Postgres or DB2 or anything else database except an SQL Server database. 😀

    Anyway, an alternative reference would have been http://msdn.microsoft.com/en-us/library/ms139892%28v=sql.105%29.aspx/css which classes the tasks in an interesting way, and shows Bulk Insert Task as the first task of the "Sql Server Task" type, and the only one of the list in todays question which is in the list for that type. Of course that's SQL 2008 documentation (the SQL 2008 R2 version of that page is pretty much the same) and teh sql Server 2012 version of th epage has thrown away that useful classification (it lists the types, but doesn't say which tasks beong to any of them, which is not exactly helpful). So although that alternative reference would perhaps have been a better one for 2008 and/or 2008 R2 the reference given in the explanation is actually better on that page because the information is preserved in the 2012 version, instead of thrown away. I find it hard to think why useful information in BoL does that sort of disappearing act every now and again, perhaps someone in the BoL team doesn't like giving too much information an=bout sql Server away. :angry:

    Tom

  • logitestus

    SSCrazy

    Points: 2816

    I just like the fact that by basis of logical deduction I was able to answer correctly. Now I am off to solve "crimes"... 🙂

  • SQLRNNR

    SSC Guru

    Points: 281210

    thanks for the question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Hany Helmy

    SSChampion

    Points: 13321

    Guessed it right although never used SSIS until now in production.

  • Revenant

    SSC-Forever

    Points: 42467

    Easy for me, with my BI focus. 😉

    Thanks for the question, Stanley!

  • jfgoude

    SSCrazy

    Points: 2586

    got 1 point, but was not really sure to understand meaning of the question

    Found the answer by logical deduction as Server Database Engine purpose is to store, process and secure data

  • SQL_Hunt

    SSC-Dedicated

    Points: 33261

    Wao..I scored 1 Mark.

    Thanks.

Viewing 14 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply