I don't know enough about SAN mirroring but I'm pretty sure that the database doesn't exist until the data is restored, I think the mirror takes snapshots of the data...

I don't know how far you are on with this but for what it's worth for anything over 1Gb I wouldn't use SSIS, use the bulkloader, SSIS XML parser is...

Am I missing something or is this nothing to do with SSIS?

Yes, as long as the account the SSIS package is running under has permissions to read from the server in question, for example if running under VS then your account...

Basically the error is saying that you don't have login rights for the PC-SRV-ERP_HR\ERP.TRANSIT.mis which I'm guessing would be an mis db on a PC-SRV-ERP_HR\ERP.TRANSIT instance.

I'm assuming that the...

I get data like this all of the time, assuming you need to remove these characters you need to create a script to open the file and scan through line...

I'm doing roughly the same thing at the moment, has your agent job got permissions to access all of the DB's that you do through Visual Studio, if not you'll...

Anyway, I think I'd probably use WHERE (MONTH(join_date) < 6 OR MONTH(join_date) = 8), I'm guessing it's faster than an IN statement, I can't be arsed to check though.

Um, again I'll chorus with the rest:

month(dob) in (1,2,3,4,5,8) - dob???? It doesn't exist, did you mean join_date? Sorry but you're wrong.

datename(m,join_date) like '%a%' - fair does, I cocked up...

Cheers. I ended up using a global variable to create the table each time and then dumping to an OLE DB destination connected to the table via variable.

The Case statement worked and I should've thought of it myself, cheers. So, next question, when I'm breaking down the address I'm adding it into variables the same way using:

SET@TempSQL...

Basically, I'm stripping letter by letter and removing spurious characters and then grouping them into words which I'm storing as an array (well a table variable).

Any chance of you posting the MyMethod part of the COM?

Okay, so it's running a local DCOM on the box, which should still be running under the local IIS but regardless that isn't the problem. It sounds as though the...

The parameters are UK address lines and I'm going to be doing some processing on them within the loop. So an example would be

@Address1 = '10 Downing Street'

@Address2 = 'Whitehall'

@Address3...