It really does sound like a permissions issue to me, did you check in the job details that it was executed by the user account you'd expect it to? And...

Alternatively if data driven subscriptions aren't an option, you could do it via SSIS (bit of a faff to maintain though so would use this as last resort) - have...

Can you post the exact error returned?

If you go to the job, click 'view job history', then expand the latest run and select the relevant step, is there an...

Is the account running the job the same one you used to test the package?

Is your snapshot configured to use a UNC path? (e.g \\myamazingcomputer\c$\mysnapshotfolder rather than c:\mysnapshotfolder)

Otherwise it could be an issue with your articles - would suggest carefully checking publisher vs subscriber...

Do you mean that it's importing a row consisting of entirely NULL values, or that when a certain field is NULL it shouldn't be imported? Is there a primary key...

I don't have the means to test at the moment - perhaps this would work?

SELECT *

FROM [Sheet1$B2:Q2]

UNION

SELECT *

FROM [Sheet1$B9:Q]

In the data flow source, use 'SQL Command' and do something like:

SELECT *

FROM [Sheet1$B9:Q]

ChrisM@Work (10/6/2015)

---

tindog (10/6/2015)

---

ChrisM@Work (10/6/2015)

---

Perhaps the data which the SSIS package interacts with is not in cache the first time it's run.

I'm surprised it takes so long for so few rows....

ChrisM@Work (10/6/2015)

---

Perhaps the data which the SSIS package interacts with is not in cache the first time it's run.

I'm surprised it takes so long for so few rows. What exactly...

RTaylor2208 (10/6/2015)

---

Its very hard to say without actually seeing what is happening at the specific time on the server.

However it sounds potentially like you have blocking occurring which is holding...

Under the top menu (where you have 'Welcome, username', 'My Account', 'BriefCase', 'LogOut') you'll see some grey text - starting with 'Control Panel' in bold font. To the right of...

If it must be dealt with in SSIS you could use slowly changing dimension for upserts (you would need a separate task for your DELETEs). However in my experience this...

Do you have this at the top of your script:

Imports Microsoft.SqlServer.Dts.Runtime

I'm not a vb guru either I'm afraid, do you get any errors if you just copy in the procedure and leave the rest as is? (I.e Public Sub Main()....End...