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...

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...

Was it the principle of using...

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...

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...

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...

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...

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

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...

thanks.

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...

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...

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...

ah - gotcha.

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

thanks

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...