Try adding SET NOCOUNT ON at the beginning, as you have multiple SELECT statements in your query, albeit that only one returns data.

If you execute this in SSMS, what do...

Hmmm, I should put this in my signature. 😀

Take a look in the MSDB database. In the system tables, there are a few tables that contain job information. Look for tables like dbo.sysjob* .

eshwararao.ch (11/28/2011)

---

Thanks for the reply.

The package is getting executed when i execute it manually either from BIDS or from the management studio Integration services. but if i call it from...

As said before, the AS clause in the SELECT statement is for aliasing the columns, which is disregarded by the INSERT statement.

Your statement should have looked like this:

INSERT INTO #ATable...

I suggest you read the help files of all the ssis functions that you want to use.

For example:

http://msdn.microsoft.com/en-us/library/ms141719.aspx

In the examples you can clearly see that you need to put double...

I have setup.exe on my CDROM of SQL Server 2008R2. Don't go in the x64 or x86 folders, just stay at the root folder.

Don't use *, but actual column names.

If you do not have a header, the Excel source will take F1, F2, ..., Fn as column names.

You sure? You might miss a couple of hilarious pants jokes. :w00t:

Welcome back.

Pulivarthi Sasidhar (11/28/2011)

---

Hi,

My SQL query returns data with HTML Code as single row

I used Execute SQL task & Objects variable to get the SQL resultset.(When i used String variable it...

RonKyle (11/24/2011)

---

For those using 2005, I would recommend doing a left join from the staging table to the target table, including in the SELECT statement of the columns that would...

sqlfriends (11/23/2011)

---

For merge in SQL, it is new to me, is it as flexible as using Select ...left join on.... on column is null...pattern to compare tables to insert and...

arkiboys (11/28/2011)

---

They do not work because using $A6:A6 then shows say 21/3/2011

Then on mapping this to the oledb destination, it is NOT using the column name because there is none...

roger.plowman (11/28/2011)

---

You know, the fact this was a trick question highlights a glaring flaw in T/SQL (or perhaps SQL in general?). Using single quotes for both strings and dates is...

Roy Ernest (11/28/2011)

---

My article on Audit came out today. This is part 1. (Change Tracking). Yay...!!! As expected the rating is not great. 🙁

Second part has already been submitted...