What about the more insidious dependencies like the finance sql query that hard coded the product type and now one of the financial numbers is getting reported up understated but...

bighow2008 (12/20/2011)

---

Hi,

I have 2 tables report (contains Raw data) and exceptions (filter for the Raw data). I'm trying to take "report" table and use the NOT EXISTS statement...

one more thing I just noticed - is it normal for these kinds of transactions to be serializable? You might have to scroll right on the trace xml, but...

GilaMonster (10/31/2011)

---

Very likely.

It's trying to convert an S lock (which the select would...

As put so eloquently by Andre the Giant:

I do not think that word means what you think it means.

😀

is the SSIS service installed and running on the server that is trying to execute the package?

I think your easiest method would be to write a script that splits it into two files based on the logic you describe (look for the separator text between the...

you're validating data that's already been validated? why?

Never? Absolutely never?

I think I'd say almost never.

For example, maybe you're loading a warehouse staging table from a...

Jeff Moden (10/27/2007)

---

David,

"Dropping the time" should be done on the display side of things... not on the import side of things. Reason being is that the only way you...

try this post on another forum:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1074276&SiteID=1

will it run if you use dtexec from the command line, running from the server logged in as the same user that runs Agent jobs? does your package use...

the easy way to do this is to write a generic "load" process that will load all your files into corresponding tables, then use a checksum compare as previously suggested....