Viewing 15 posts - 91 through 105 (of 499 total)
We went over to MinionBackup a while ago. No need for scripts like this (though I'm a big-time Python fan! So much better than PowerShell I hardly know...
Gerald Britton, Pluralsight courses
January 25, 2016 at 9:18 am
Phil Parkin (1/22/2016)
g.britton (1/22/2016)
Gerald Britton, Pluralsight courses
January 22, 2016 at 12:52 pm
Yet Another DBA (1/21/2016)
I think that most will use a developers copy or msdn copy for all non-production copies of sql.
+1
Gerald Britton, Pluralsight courses
January 21, 2016 at 6:52 am
Koen Verbeeck (1/14/2016)
Regarding the view: no idea. Haven't used views in SharePoint yet. And I try to use SharePoint at the...
Gerald Britton, Pluralsight courses
January 19, 2016 at 5:15 pm
FWIW This must be a bug in 2008R2. Just tried the same thing in 2012 SSDT and it works as expected
Gerald Britton, Pluralsight courses
January 15, 2016 at 12:58 pm
Found the problem:
The staging table was being read using a view that referenced the target table. SSIS was not reading all the staging records in one go (which would...
Gerald Britton, Pluralsight courses
January 5, 2016 at 1:30 pm
My connection string server name was a FQDN. Turned out that was the issue. SQL (apparently) doesn't parse the server name to extract the leftmost value and compare...
Gerald Britton, Pluralsight courses
January 5, 2016 at 11:53 am
Go into Advanced Editor for the OLEDB destination.
- Select Input and Output Properties.
- Expand OLE DB Destination Input.
- Expand External Columns.
- Select each column whose data type you want...
Gerald Britton, Pluralsight courses
December 16, 2015 at 1:24 pm
Alvin Ramard (12/15/2015)
Phil Parkin (12/15/2015)
g.britton (12/15/2015)
Alvin Ramard (12/15/2015)
I don't know why it got things wrong, but you can edit your connection and make the required connections.
Of course. however the...
Gerald Britton, Pluralsight courses
December 16, 2015 at 7:15 am
Alvin Ramard (12/15/2015)
I don't know why it got things wrong, but you can edit your connection and make the required connections.
Of course. however the connections are already correct.
Gerald Britton, Pluralsight courses
December 15, 2015 at 1:18 pm
Koen Verbeeck (12/10/2015)
g.britton (12/9/2015)
In this case, there are two connection managers -- one for each database. Would you suggest using one connection manager and three-part naming on the...
Gerald Britton, Pluralsight courses
December 14, 2015 at 7:53 am
That's interesting!
In this case, there are two connection managers -- one for each database. Would you suggest using one connection manager and three-part naming on the SQL statements in...
Gerald Britton, Pluralsight courses
December 9, 2015 at 12:52 pm
With a title like that, you've been watching too much "Big Bang Theory"
Gerald Britton, Pluralsight courses
December 2, 2015 at 6:51 am
good find! that settles it then
Gerald Britton, Pluralsight courses
November 24, 2015 at 2:33 pm
ScottPletcher (11/24/2015)
I believe it may be due to the deferred resolution SQL uses for permanent tables that don't exist during parsing. Then again, maybe not :blink:
I'm thinking something else...
Gerald Britton, Pluralsight courses
November 24, 2015 at 2:25 pm
Viewing 15 posts - 91 through 105 (of 499 total)