Viewing 15 posts - 5,671 through 5,685 (of 9,643 total)
As I said, just set the Text Qualifier property of the Flat File connection to a double-quote and SSIS will ignore commas between double-quotes.
March 12, 2009 at 5:16 pm
Which table in the example is tableA and which is tableB? Which table is showing the clustered index seek? Can you post the execution plan? When was...
March 12, 2009 at 5:15 pm
simon phoenix (3/12/2009)
yes paul , i want to remove the comma inside the quoatiationThanks
Simon
If the data has text qualifiers like quotes all you need to do it set the text...
March 12, 2009 at 5:01 pm
Are there text qualifiers? If not, do you have any control or influence on the creation of the flat file to have them added?
Can you attach a file similar...
March 12, 2009 at 4:59 pm
What is the purpose of removing the commas? Are you replacing with another delimiter? Do you mean commas contained in the delimited columns? Like this example:
Name, Age,...
March 12, 2009 at 4:37 pm
Please don't double post. Post answers here: http://www.sqlservercentral.com/Forums/Topic674812-148-1.aspx
March 12, 2009 at 4:34 pm
You need to lookup "Parameter Sniffing". This is usually the culprit in these situations.
One other comment is that you might get better performance if you remove the functions from...
March 12, 2009 at 3:54 pm
Bob Hovious (3/12/2009)
Congratulations, Gail 🙂 And congratulations also for being Geek of the Week.http://www.simple-talk.com/opinion/geek-of-the-week/gail-shaw-geek-of-the-week/
Yeah, congrats. I'm looking forward to (hope I haven't missed) the...
March 12, 2009 at 2:51 pm
Lynn Pettis (3/12/2009)
GilaMonster (3/12/2009)
Bob Hovious (3/12/2009)
I missed out on Babylon 5 🙁 It fell during a period of years where I never had time for TV.
It's...
March 12, 2009 at 2:09 pm
Steve Jones - Editor (3/12/2009)
I'm just glad they're coming here instead of Google first 🙂
As an MVP aren't you disappointed they didn't use Live search?:P
March 12, 2009 at 1:14 pm
GilaMonster (3/12/2009)
lmu92 (3/12/2009)
How can you be sure that the fragmentation question relates to indexing?Context.
Ditto.
March 12, 2009 at 10:58 am
Darn, Gail beat me to it. Don't know why your blog wasn't on page 1 of my google search.:D
March 12, 2009 at 10:19 am
prvreddy (3/12/2009)
Hi all,1)Why a table have maximum one clustered index ?
Because the database physically stores the data in the order of the clustered index and you can only physically...
March 12, 2009 at 10:16 am
Can you post the connection string the app is using (changing sensitive information of course)?
Is there an error message being returned? If, so what is it?
Have you tried running...
March 12, 2009 at 8:45 am
Typically you put is after the "AS". This is typically what is considered the top of the Stored Procedure, Everything above the ALTER/CREATE PROCEDURE is technically not part of...
March 12, 2009 at 8:08 am
Viewing 15 posts - 5,671 through 5,685 (of 9,643 total)