When you run your process you can track progress by checking the rowcount of the table in sys.partitions with the iso level READ_UNCOMMITTED.

Did you understand what I meant about offloading...

Chances are you have your Flat File Connection Manager setup incorrectly. When you go to Preview, does your data line up? If not, make sure you are accounting for the...

Different OS requirements for one. I suppose a warning would be a kind addition to the site.

Sounds odd. Maybe you'll get lucky and Gail or Paul will drop by and relay something they have heard or seen about the issue you are seeing.

There is guarantee it will remove them....

subramani.rudrappa 78855 (2/6/2013)

---

But i am able to fetch data from SSIS by connecting to excel source and using import export wizard too without any error.which means we have Microsoft.ACE.OLEDB.12.0 available...

mayur birari (3/6/2013)

---

Hi @opc,

I did some testing with the indexed tvps interms of deadlocks. I did not find any difference between non-indexed and indexed versions. I created a simple application...

Correct. That's why you do leave...

To be fair, msdn scrips offer more than just the bare min and the licenses state that the software is there for 'dev use only.' This is to support dev...

weird forum error - this post was meant for a different thread - post removed

Files are either delimited, e.g. a CSV file, or fixed width. Which is it that you are dealing with?

Please supply the indexes on pp (patenit_property) and pp_staging as well as the INSERT statement used to copy the data.

One thing I can say is that if you were to...

Per Books Online "The COMPUTE and COMPUTE BY clauses are provided for backward compatibility." so use those in new development at your own risk. They do not exist in SQL...

Not under the same transaction, but you can manage that on your own.

Connection 1: BEGIN TRAN

Connection 2: BEGIN TRAN

Connection 1: Modify some data

Connection 2: Modify some data

-- If modifications on...

If you can use the SQLCLR here is an Aggregate Function I wrote to simplify the syntax for these types of queries that performs comparably (sometimes better, sometimes slightly worse)...