Forum Replies Created

Viewing 15 posts - 1 through 15 (of 312 total)

  • Reply To: Save Data Factory Without Publishing?

    Sounds like you need to configure a dev ops repository. You can then create a branch of tour code that can be edited and tested separate to the master branch...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    December 26, 2019 at 6:51 pm

    #3710601

  • Reply To: Passing triggerID to the destination column

    Hi

    If I have correctly understood what you are trying to do, you want to pass a pipeline parameter as part of the data copy from source to destination, inserting the...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    December 18, 2019 at 3:48 pm

    #3708831

  • RE: Reporting Services Disaster Recovery

    One thing though, and this is just the perfectionist in me. Your article kept on saying "Principle" instead of "Principal". And it bothered me.

    Was it the principle of using...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    April 7, 2016 at 7:56 am

    #1870490

  • RE: Custom Schemas

    I've used schematic a fair bit to seperate logical setss of tables, but th best use I found in etl is the ability to have landing, staging and erro tabl...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    November 13, 2015 at 1:57 pm

    #1839750

  • RE: Autogenerating SSIS file import packages using Biml

    Could BIml be used to auto generate SQL to oracle interface with data type conversions easily or would it require the need to build some form of table column and...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    September 10, 2015 at 12:12 am

    #1825588

  • RE: SQL SSIS to Oracle CLOB Performance Issue..

    Hi dave.

    We used SQL 2012 with the oracle attunity 2.0 data connector in the end.

    It's still not what I would call fast but we got our data migration down to...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    May 6, 2014 at 3:30 am

    #1710978

  • RE: Running 1 SSIS package parallel

    try using a for loop.

    what your suggesting is possible, but not straight forward.

    One possible way to do it is create a package to dynamically create a package with a...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    February 24, 2014 at 9:17 am

    #1691612

  • RE: DB Mirroring - Witness server at PROD or DR?

    I'd run it on a seperate site completely or consider using manual failover to ensure your running on the right server

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    February 24, 2014 at 9:04 am

    #1691599

  • RE: Cannot open New SSIS Project in SQL Server 2008 R2

    thanks for posting cecilchampenois....

    you should be labeled a jedi - not a grasshoper 😀

    like the others.... you've saved me a lot of time. (just a shame MS can't...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    November 27, 2013 at 4:50 am

    #1669410

  • RE: SSIS performance tuning Default Buffer Max Rows

    thanks.

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    November 18, 2013 at 6:55 am

    #1667124

  • RE: Reporting Services Disaster Recovery

    carl.landry (10/17/2013)

    I never looked at this very deeply but I believe that scheduled report executions (for subscriptions, for example) create a SQL Agent task to program the execution at the...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    October 22, 2013 at 2:49 am

    #1660411

  • RE: Reporting Services Disaster Recovery

    l543123 (4/21/2010)

    Nice article! Quick question, sorry if its silly. If use is accessing reports from a front end application using url's like http://SQLTEST01/ReportServer/Report1 or http://SQLTEST01/Reports/Report1, then if the failover happens...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    October 22, 2013 at 2:38 am

    #1660410

  • RE: issues creating a hierarchy - Vehicle Category - vehicle type - vehicle make - vehicle model

    Top man yayomayn! :Wow:

    My dimension is working now. Really appreciate your help.

    ➡ For anyone reading this thread with a similar issue - I have attached a xlsx doc...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    October 17, 2013 at 9:39 am

    #1659391

  • RE: issues creating a hierarchy - Vehicle Category - vehicle type - vehicle make - vehicle model

    ah - gotcha.

    Ok - Will give that a go - might not be today, but I'll let you know if it works.

    thanks

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    October 17, 2013 at 6:42 am

    #1659288

  • RE: issues creating a hierarchy - Vehicle Category - vehicle type - vehicle make - vehicle model

    My results are definitely a little funky! 😀

    I tried having separate fields and defining the 3 fields (i think it was three I had) as a logical key to join...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    October 17, 2013 at 5:19 am

    #1659236

Viewing 15 posts - 1 through 15 (of 312 total)