Viewing 15 posts - 1 through 15 (of 39 total)
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...
October 16, 2017 at 10:47 am
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...
October 16, 2017 at 2:25 am
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...
October 12, 2017 at 12:15 pm
Sorry, misread what you had asked.Caller is me "MicrosoftAccount\MyName@gmail.com"
October 12, 2017 at 10:54 am
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
October 12, 2017 at 10:50 am
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...
October 12, 2017 at 10:45 am
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...
October 11, 2017 at 2:03 pm
To SQL running on my own laptop.So at present, everything is on my laptop.
October 11, 2017 at 1:03 pm
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...
October 24, 2013 at 3:20 am
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...
May 18, 2012 at 1:31 am
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...
January 26, 2012 at 8:43 am
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.
March 9, 2011 at 4:48 am
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...
July 27, 2010 at 2:14 am
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
July 26, 2010 at 7:36 am
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...
July 26, 2010 at 7:09 am