When using just the script component in the dataflow I don't believe this data is readily available. It may be available if you write a custom data-flow component. ...

If they know the port then instance name should not be important. However I believe this to be a generally bad practice and limits the ability to change the...

Can I ask why you would do this?

CEWII

You could edit the project file directly, it really is nothing more than a text file. I've done it many times, especially to re-order things..

CEWII

Provided there is a primary key candidate in the data itself then you can do it in one pass. If not then you will almost certainly have to read...

Even if you could change it there really is no reason. If you look under the hood I'm fairly sure you will find that dbo owns the objects either...

sashafroyland (8/2/2009)

---

Hello,

Looking for some stats to compare MS Access with SQL Server Express. Stats to include would be INSERTs per second and complex query retrieval of record sets under 500...

SQL 2005 what sp? I am assuming SP4 for the OS, which would likely be 2000 if you are talking about SP4 and 2000 is the only one I know...

Do the other things above before you resort to this:

http://rip747.wordpress.com/2008/05/26/rebulding-msdb-in-sql-server-2005/

CEWII

The most common statement in SQL is SELECT. Others are INSERT, UPDATE, and DELETE.

Let me put it to you this way, you shouldn't use ANY of them until you...

By doing transformations in the dataflow from the source to the destination the data doesn't get written to disk before it ends up at the destination. Since there are...

I don't think I would, that is really just a front-end tool. You are really looking at something to do it in the background. So you are doing...

When you run it interactively in BIDS what does it do? Depending on how big the package is and how many objects it has to validate and where they...

Something caught my eye in your last post, your .NET programmer recommended a .NET solution, while I'm NOT saying he is wrong, I am always wary of what I call...

No retries?

CEWII