Viewing 15 posts - 8,671 through 8,685 (of 8,733 total)
GilaMonster (3/28/2014)
Eirikur Eiriksson (3/28/2014)
SELECT @ProductID= ProductID FROM Product WITH (NOLOCK) WHERE SalesID= '@salesId' and Product = 'Clothes '
Apart from not being SARGable...
All the predicates in that query are SARGable. They're...
March 28, 2014 at 3:11 pm
SELECT @ProductID= ProductID FROM Product WITH (NOLOCK) WHERE SalesID= '@salesId' and Product = 'Clothes '
Apart from not being SARGable, this query puzzles me, would you ever have a SalesID value...
March 28, 2014 at 2:51 pm
Ranzz (5/26/2011)
what are benfits and disadvangates of online and offile?
CREATE NONCLUSTERED INDEX [_dta_index_dClientCode_16_437576597__K7_K3_1]...
March 28, 2014 at 1:31 pm
tlunsf (3/28/2014)
Ninja's_RGR'us (5/26/2011)
What didn't you understand in my previous post?What part of ONLINE = SOMETHING OTHER THAN OFF GOES HERE are you having troubles with?
It is comments like this that...
March 28, 2014 at 11:08 am
cooljagadeesh (3/27/2014)
which way is the better for 1 million records inserting into one table1) insert into destination
select * from source
2) BULK INSERT destination
FROM '\\computer\source.txt';
3) BCP
Quick...
March 28, 2014 at 1:57 am
sandeep.patel1 (3/27/2014)
I want to assing my Aggregate transformation output(Which Returns only one value like 5.50) into a Variable.
How can i do this.
I already created a variable in Package...
March 28, 2014 at 1:26 am
Well, this is what I got when I tried that:
Error1Error loading 'Weekly_FullSnapshots - Forecasts Live - xml edit.dtsx' : The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT)).G:\Mhub_Operations\DATA\SSIS\Archive_Snapshots\Weekly_FullSnapshots -...
March 27, 2014 at 10:55 pm
Create a variable which has high enough scope for all the tasks you want to use the variable in. Then assign the initial value to the variable where the value...
March 27, 2014 at 2:49 pm
The way I would do this is :copy the package file, open the package in a text editor, delete everything including the tags between any instances of <DTS:ConnectionManager> and <DTS:ConnectionManager...
March 27, 2014 at 2:10 pm
ErikMN (3/27/2014)
March 27, 2014 at 11:09 am
One suggestion is to use derived column and the replace function inside the left function.
March 27, 2014 at 10:58 am
kmdavisjr (3/27/2014)
March 27, 2014 at 10:37 am
You can query the xml package file to list all connections, look at this thread for more info;
http://www.sqlservercentral.com/Forums/Topic1380488-21-1.aspx
March 27, 2014 at 8:55 am
Quick question, are you using full-text search on the server?
Edit:
The server is pretty smart when it comes to interpreting even the strangest of user's naming :w00t:
As an example, this...
March 27, 2014 at 2:58 am
No "clean" function that I know of, manual labour I am afraid.
To speed the process, use the property (F4) window, lists connections etc. of data flow and control...
March 27, 2014 at 2:09 am
Viewing 15 posts - 8,671 through 8,685 (of 8,733 total)