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...
January 25, 2016 at 9:18 am
Phil Parkin (1/22/2016)
g.britton (1/22/2016)
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
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...
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
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...
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...
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...
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...
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.
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...
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...
December 9, 2015 at 12:52 pm
With a title like that, you've been watching too much "Big Bang Theory"
December 2, 2015 at 6:51 am
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...
November 24, 2015 at 2:25 pm
Viewing 15 posts - 91 through 105 (of 499 total)