I assume you wanted to backup all the databases that existed in the temp table.

I would suggest using a cursor as explained in this article

http://www.mssqltips.com/tip.asp?tip=1070

You may change the table...

Why ??

Agree with others here..

By the way, was the position an entry level and the Senior DBA grilled as if it's a senior level DBA?

Yeah, but at least it fetches more than the 150 shown on SSC.

Surely not entire list, but something to start with...

I saw this as a common one for everyone to display the last 150 posts.

I then figured out using Google..

Check this link..

site:sqlservercentral.com homebrew01

I use the same link and replace my...

So you mean that Job Owner does not have permissions on the Server?

Have you made sa as the Owner (If sa is not disabled) and tried?

You could do it by first importing into a staging table and then use

something like this

Insert into table1

Select name address phone,getdate()

from staging table

OR

You can create a linked...

I am neither a master in those but wanted to share a thought.

The choice depends on what is that you looking to and also how much are you interested in...

Do not cross post ! Please reply at the post under the thread given below, since that is more appropriate board (this one being SSIS)

http://www.sqlservercentral.com/Forums/Topic844981-338-1.aspx

We need to ask what is the problem, since we cannot see what is the error you are getting (if you are getting one).

You need to look at the...

What do you mean by centralization, I may be wrong, you may be referring to Consolidation as centralization.

Do you have multiple Instances on multiple servers and would like to consolidate...

Are you seeing that last line only is not being imported?

Check if the last line has any additional data which does not align well with the rest of them.

Use the Following script to find your failed job details...

The script displays the records when a particular job fails.. ( You can alternately remove the last line of the code...

Hi Lakshmi,

I would have a simple job that runs every 15 mins or so and checks the execution result of the SSIS Package Job and if the last run was...

Query Execution Plan might provide how optimizer is executing the query and information of Index existing on the table is not mentioned by you.