The successvalu property foe execute process task is configurable. Even though the default is 0, you should change this according to the process you are using.

You should refer the manual...

Karen Grube,

a) You can configure SQL agent to run packages from file system. So if you can place the package in a fileshare and if the sql server agent has...

Glad to help:)

Lavanyasri (2/21/2013)

---

Thanks to all.

I go through the link , now my issue with the decimal data type

SELECT col1 FROM table2

WHERE col2 > 9999999999.99999

OR col1 < -9999999999.99999

In this script col1...

Hash match can spill to tempdb.

details on hash join

http://technet.microsoft.com/en-us/library/ms189313(v=sql.105).aspx

Tempdb may be use while grouping sorting etc.

You should look ate the execution plan and see whether any index/ query rewrite can help.

If you need help please share the execution...

The percentage you are seeing is the percentage relative to the batch.

Since there is only one query in batch it shows 100 percent.

If you had more than one statement for...

Check whether you have proper indexes for the child table.

Run a delete statement enabling execution plan and see whether the index is being used.

Amit,

This looks like an old thread, still

Mostly the problem would be firewall.

Look what port is configured in Reporting services configuration manager (Or ask your DBA).

Ask your network folks to open...

You cannot create computed columns that refernces other tables

http://msdn.microsoft.com/en-in/library/ms191250(v=sql.105).aspx

You might want to create a trigger to implement this, or if you are in the design phase, try to incorporate this...

Even though you have give 100 rows per job, maximum number of (total) rows(1000) is reaching frequently.

You can increase this to say 5000 and see whether it is enough for...

Jordan,

How many rows you have in sysjobhistory?

select * from msdb.dbo.sysjobhistory

In addition to nicks suggestion, you can use script task as per the below link

http://stackoverflow.com/questions/1954582/ssis-2008-excel-2007-formatting-excel-columns-properly-exporting-not-importin

I have not used this , but will keep this in mind so may be useful...

crazy_s245 21087 (2/19/2013)

---

This code works in SQL 2005 and returns the inserted row, only there was error "Column, parameter, or variable #4: Cannot find data type Date". Same code...

Gail,

Apart from forcing a hint, I would like you revisit the TOP clause. I have seen TOP behaving unexpectedly particularly when you dont have an order by. Its is...