Post reply

SSIS

  • October 9, 2013 at 10:02 pm

    #299626

    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

  • October 9, 2013 at 10:03 pm

    #1657370

    easy , very easy. 🙂

  • October 10, 2013 at 12:44 am

    #1657387

    EZ PZ 😀

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

  • October 10, 2013 at 1:30 am

    This was removed by the editor as SPAM

  • October 10, 2013 at 1:34 am

    #1657396

    Easy, if you know it.

  • October 10, 2013 at 2:00 am

    #1657400

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

  • October 10, 2013 at 2:41 am

    #1657409

    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.

  • October 10, 2013 at 4:12 am

    #1657430

    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

  • October 10, 2013 at 6:26 am

    #1657485

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

  • October 10, 2013 at 9:11 am

    #1657605

    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

  • October 12, 2013 at 1:25 am

    #1658057

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

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • October 15, 2013 at 3:38 pm

    #1658740

    Easy for me, with my BI focus. 😉

    Thanks for the question, Stanley!

  • October 31, 2013 at 3:02 am

    #1662947

    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

  • June 10, 2015 at 9:16 am

    #1804379

    Wao..I scored 1 Mark.

    Thanks.

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

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