Viewing 15 posts - 976 through 990 (of 11,678 total)
SELECT DISTINCT
t2.Number
,t1.Name
,t1.Country
FROM table2 t2
LEFT JOIN table1 t1 ON t2.Number = t1.Number;
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...
February 25, 2015 at 3:53 am
Does the stored procedure have multiple result sets? Or multiple statements?
Try using EXEC WITH RESULT SETS.
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.
February 25, 2015 at 12:38 am
Jeff Moden (2/24/2015)
Brandie Tarvin (2/24/2015)
Jeff Moden (2/24/2015)
February 25, 2015 at 12:33 am
What if you use an OLE DB Destination with Fast Load instead of the SQL Server Destination?
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.
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?
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)
February 24, 2015 at 4:47 am
Why does the package fail?
February 24, 2015 at 3:12 am
Lynn Pettis (2/22/2015)
And for the geeks out there:
......
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...
February 23, 2015 at 1:39 am
Viewing 15 posts - 976 through 990 (of 11,678 total)