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?

I missed the London one's due to family...

If you dont want yourself to re-add access, then you will want to remove db_accessadmin also.

Members of the db_accessadmin fixed database role can add or remove access for Windows logins,...

IIFC it should automatically appear when the logfile is restored on the secondary.