Viewing 15 posts - 10,471 through 10,485 (of 13,879 total)
Actually, I have SSMS, just no reports. That's why I am looking for DMVs etc to help me figure out how big this one record is. Looks like I need...
August 30, 2012 at 10:48 am
One possible way around this is to create a SQL Agent job which runs the package and then to allow the user to kick off that job, rather than the...
August 30, 2012 at 9:48 am
Use Redgate's free SQL Search tool - no coding required and works well.
August 30, 2012 at 9:33 am
Gianluca Sartori (8/30/2012)
--snipTested on oracle 11.2.0.1.
Turncoat!
🙂
August 30, 2012 at 7:05 am
harri.reddy (8/29/2012)
i know ,it has so many variation.what is the other way in ssis, i can achieve.
plz help me
Ah, you must mean the magic-wand component.
August 29, 2012 at 2:17 pm
harri.reddy (8/29/2012)
i am usinf this expression for my first columnREPLACE(SUBSTRING(product,1,FINDSTRING(product," ",1) + 0),","," ")
i need help for second and third.
please help me
Not really what I asked for. What is your...
August 29, 2012 at 1:25 pm
harri.reddy (8/29/2012)
i need derived column solution ,not sql
Write out your detailed logic for breaking the column into three and we'll help with the solution. Might need a Script Component if...
August 29, 2012 at 12:14 pm
Use a multicast to broadcast data from one source to multiple destinations.
August 29, 2012 at 12:11 pm
I suggest that you search for something like "shredding a recordset in ssis".
August 29, 2012 at 12:10 pm
kishoremania (8/29/2012)
Can anyone please look into it
Not until you prove that you have tried. There are plenty of resources available on the Internet for this fairly straightforward task. Come back...
August 29, 2012 at 12:08 pm
Never seen anything like it, sorry, no idea at all.
August 29, 2012 at 12:06 pm
Luis Cazares (8/29/2012)
Ideally you should only store the digits and format the phone in the front end. However, you'll need an extra field for extension...
August 29, 2012 at 10:31 am
Nasty. Can you explain a bit what the package is doing?
If you remove that expression, does the package work?
Is pageref.cpp something which you are explicitly using in the package?
August 29, 2012 at 2:13 am
harri.reddy (8/28/2012)
in my package i am gettign error like ,
truncation may occur due to inserting data from data flow column "Copy of Column 34" with a length of 20...
August 28, 2012 at 10:59 am
sandeep rawat (8/28/2012)
question is still not clear
+1 - no idea what's going on here!
August 28, 2012 at 10:45 am
Viewing 15 posts - 10,471 through 10,485 (of 13,879 total)