Can we 'do a Wikipedia' on this thread and block it? Permanently.:hehe:

Hi Sean and thanks for the response.

My point is that using Object Explorer to connect works as you would expect (with colour coding from Registered Servers) unless that colour coding...

I know that this is an old thread, but I think it's the best place...

I've just been caught out by this - luckily nothing major, but still a production server...

public2 61705 (1/16/2012)

---

I hope to eventually offload the whole thing to the users or at least a group of select users. But it seems I'm stuck well before that.

And no,...

Elliott Whitlow (1/16/2012)

---

Is the process known? What I mean is that if Phase 1 returns X result you will ALWAYS go Branch A, if it returns Y then you...

public2 61705 (1/16/2012)

---

The problem is that I don't have the decision beforehand, it's based on some intermediate results. Looking at those results, I can decide if I want to continue...

Are you hoping to give this functionality to users? Or is it just a package which a developer will run interactively from within Visual Studio?

Right click the relevant SQL Agent job and View History - you should be able to get a more detailed error message there. Please post it.

Somewhere in there (I don't have SSIS in front of me), there is a list of objects to transfer - you just have to expand a few properties. Keep looking!

Check out the various properties of the Transfer task - that is where the tables will be specified. It might not be doing a truncate - rather a delete/recreate (I...

And setting it as an Expression, not directly as a property.

Nice!

Anamika (1/9/2012)

---

hi,

i have a table with every minute data, if i want to select data for every 15 minute how can i do it.

for example

01/05/2012 5:40:00 PM 1

01/05/2012...

Evil Kraig F (1/6/2012)

---

Your server needs the Office Suite installed, and possibly the exact driver you're looking for. You'll also most likely have to turn on the 'run in...

This thread illustrates so very well the consequences of not forcing the OP to provide a proper set of requirements before answering ... talented people who could tackle the problem...