Viewing 15 posts - 976 through 990 (of 11,676 total)
SELECT DISTINCT
t2.Number
,t1.Name
,t1.Country
FROM table2 t2
LEFT JOIN table1 t1 ON t2.Number = t1.Number;
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 25, 2015 at 8:30 am
No, not really.
As you noticed, the "security" can easily be circumvented.
The only "option" to secure the package so that you only can open it is to use EncryptAllWithUserKey, but then...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 25, 2015 at 3:53 am
Does the stored procedure have multiple result sets? Or multiple statements?
Try using EXEC WITH RESULT SETS.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 25, 2015 at 12:57 am
You can either download the open-source SharePoint adaptor, or you can download the new OData source from Microsoft.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 25, 2015 at 12:38 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 25, 2015 at 12:35 am
Jeff Moden (2/24/2015)
Brandie Tarvin (2/24/2015)
Jeff Moden (2/24/2015)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 25, 2015 at 12:33 am
What if you use an OLE DB Destination with Fast Load instead of the SQL Server Destination?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 25, 2015 at 12:32 am
That's probably not going to work.
Your temp table has to exist when you are designing the package.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 24, 2015 at 6:16 am
er.mayankshukla (2/24/2015)
hmm,Looks like I have to use hardcodes table names in sql command in OleDB Destination
I'm curious, how exactly do you use a SQL statement in the OLE DB Destination?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 24, 2015 at 5:48 am
Phil Parkin (2/24/2015)
Did you mean OLEDB Command, by the way?OLEDB Destination does not have a SQLCommand.
Well, it does have one, but I don't think it's actually used. (or actually useful)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 24, 2015 at 4:47 am
Why does the package fail?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 24, 2015 at 3:12 am
Interesting question, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 24, 2015 at 2:52 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 23, 2015 at 1:44 am
Lynn Pettis (2/22/2015)
And for the geeks out there:
......
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 23, 2015 at 1:42 am
balasach82 (2/22/2015)
1. Do I have to move ReportServerTempDB too?2. Apart from moving ReportDB's, any other way to migrate Reports?
1. In the article I linked to they restore the ReportServerTempDB as...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 23, 2015 at 1:39 am
Viewing 15 posts - 976 through 990 (of 11,676 total)