For me the 'disappearing script' is a nuisance, but not big deal, as I only have one Import and now only one line of code. But in other circumstances, it...

Steve, thanks for your suggestion.

One thing I have noticed in Visual Studio 2015, is that the Script Task seems to occasionally loose its settings and reverts to Visual...

Phil - Yes the account is local admin

Thom - Everything is on the laptop, so I should be able to kill the WiFi connection and it should still...

Sorry, misread what you had asked.
Caller is me "MicrosoftAccount\MyName@gmail.com"

Phil,

As mentioned above, if its called via the Agent, then SQLAGENT.
It's is called directly or via the Catalog.Create stuff, then CALLER_INFO is blank.
Thanks

Thom,

Thanks for your input. Its maybe sort of confirmed by the report All Executions - Overview, showing CALLER_INFO as blank.
Although, I've also found that if I set up...

Thom,

Permissions was my though as well, hence the Read permission for Everyone on the folder with the *.jpg files. Which is overkill, but in my mind should eliminate...

To SQL running on my own laptop.
So at present, everything is on my laptop.

Thanks

With a bit more research, I've answered my own question.

I added a hidden parameter, which I called Language. This is passed in with the Subscription data, and then simply...

I struggled with this as well. It's slightly messy, but what I ended up doing was creating a temp table with a single field, then loading the UTF-8 source into...

Sorry for the delay in getting back to you (I got sidetracked on to some other issues).

But your right, it was a problem with NULL's. I thought I had tested...

Todd,

Thank you, you were spot on, I had Destination for the SCD1 output instead of a OLE DB component. Reviewing the video made it obvious.

Thanks

I hope this is what you expected.

The table structure for storing the pivoted data will look like this -

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[c]') AND...

Sorry, should have also said, that we are only interested in data from the source file, where the TTITLE contains the following text -

Premanufacture Notices Received From

Notices of Commencement From

Test...

Yes I know all about the very widely held views on cursors, but personally I'm not to worried about this aspect, as at least I have something that works! Your...