ok, here it is: Its not perfect, but it works.This is part of my code, so let me explain. The important stuff is highlighted. You have to get a hold of your Task object from the particular package object that contains the TransferObjectTasks. One bad part that I can't figure out is how many objects there […]
2005-05-24
select id,order1 from od union select id,order2 from od union select id,order3 from od
2005-04-24
I agree with some of the ideas in the article, but I hate underscores in table field names. Capitalizing each word within the name is just as readable and much easier to type (i.e., GrossAmountPaid).And what's wrong with using a prefix and naming a table tblInvoices?I try to avoid abbreviations unless their meaning is just as […]
2005-04-06
What if someone sells a product whose only purpose is to kill people? Should they be shut down? Ask big tobacco how they feel about this!
2005-03-31
Hello,Is it possible to pass in a value from the global parameters into an Execute SQL task? If so, how? Basically, I need to execute a query based on the value in the dts global variables section, which this package will be executed using dtsrun or the DTS library.Thanks,Brian
2004-11-10
2004-11-04
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-11-01
I agree with Steve. I am doing the same thing for our accounting department and have scripts adding/removing accounts after the restore.
2004-10-15
I would like to create an identity on a static lookup table that can be used in bitwise operators. The static table will be used in a bitwise lookup to see if the particular record has an error against it. The main problem is that each record could have multiple errors. Example Valid0 = Item OK1 […]
2004-10-07
59 reads
<quote>I did pass on your suggestion about a profile trace to our systems engineer, but who knows if he will act on it, unfortunately.</quote>That's not good. You #need# to know where the bottleneck is! Try proving that everything else is ok - network speed, web server response etc.Certainly you should be getting a response in under a […]
2004-09-22
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers