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...

My comment relates to this sentence:

1) to fail the package if the file is not available, then execute the package again at a later time, or 2) we can...

Your selection logic is flawed. You should read Gail's article, but I think that this would be closer to what you need:

select * from test_data

where Eid = (case when...

You are responding to a thread which is 2 years old!

SKYBVI (1/4/2012)

---

I want to update a column in a table.

I am using:-

update table

set column name =....

except (sub query giving other COLUMN VALUES as output)

I dont want the sub query resulted...

How will the query know that the first result should be excluded the second time it runs? It's no longer random at that point, unless you put the selected names...

xRafo (12/29/2011)

---

I just Need 1 row.

The table have around 2000 records.

I've been testing the above query but sometimes give 2 times return the same value,

I need not repeat random...

CHANDRASHEKHAR SINGH (12/29/2011)

---

Hi,

Building a package is a standard Practice. When you deploye your package from Dev environment to Production environement, you should build your package, which will craete the .msi...