Find out what the job runs and debug it, could be SSIS packages, stored procs etc.

I believe that this is the latest, unsure if Steve has added any more since this

http://www.sqlservercentral.com/Forums/Topic935523-83-1.aspx

Not sure on that, you will need to build some sort of linking in 1 of the servers.

Something like using linked servers, or building a merged database of both DB's...

Thats a VB script that your editing, mine is a C# script, if you change the type on the properties of the task you can change it between C and...

Something like this?

DECLARE @Table TABLE (SD DATETIME, ED DATETIME)

INSERT INTO @Table VALUES

('2012-09-30 12:35:26.033','2012-09-30 12:51:05.170'),-- 15.650000

('2012-09-29 16:27:35.957','2012-09-29 16:43:45.987'),-- 16.166666

('2012-09-28 20:07:19.493','2012-09-28 20:23:33.343'),-- 16.233333

('2012-09-27 01:05:07.513','2012-09-27 01:20:00.410'),-- 14.883333

('2012-09-20 11:11:27.083','2012-09-20 11:29:00.037'),-- 17.550000

('2012-09-19 17:56:50.700','2012-09-19 18:15:17.540')-- 18.450000

SELECT...

We do exactly the same thing, but we download the files first then use a for each loop to process them all.

We use a script task with the following code,...

If you know the logic and the joins and have the SQL statements to do all the work, you just need to use the data flow tasks and supply the...

Then yes, SSIS will be able to read data from 1 database then insert it into another database.

There really isn't much difference between the two.

If you want a scaled out web farm, powerview, alerts or data driven subscriptions then you need Enterprise, otherwise you can get away...

What it looks like you need is a UNION clause, either in a stored proc on direct in the data set.

SELECT

1,2,3

FROM

DB1.dbo.Table2

UNION / UNION ALL

SELECT

1,2,3

FROM

DB2.dbo.Table1

Where is your data coming from?

Once we know that we can say if SSIS will perform the tasks needed to import the data for you.

Are you a member of any group which exists on the SQL server, say a domain group or a local group which has access to other things.

ProcessAdmin you can add a member to processadmin and also KILL connections, nothing relating to security.

Also have you logged out and back in again to SQL as usually the changes dont apply until you have.

Do you have any server level roles assigned to yourself?