Viewing 15 posts - 6,901 through 6,915 (of 9,715 total)
prasanna-750812 (12/5/2010)
The number of sources will not be constant for each run.............so i think we can't use multiple sources or multiple data flow tasks.............
Sounds like a case of needing a...
December 6, 2010 at 5:04 am
Craig Farrell (12/3/2010)
December 6, 2010 at 5:01 am
PaulB-TheOneAndOnly (12/3/2010)
Brandie Tarvin (12/3/2010)
December 6, 2010 at 4:56 am
guruprasadurs (11/15/2010)
Last time i resolved a issue with the help of u....
December 3, 2010 at 11:45 am
Roy Ernest (12/3/2010)
Brandie Tarvin (12/3/2010)
Oh, it...
December 3, 2010 at 8:50 am
Paul,
Repopulating a table isn't necessarily that easy. Especially if it has foreign keys, indexes, constraints, etc. If it's a heap, then not so bad. But you're also forgetting the question...
December 3, 2010 at 8:48 am
Alvin Ramard (12/3/2010)
I have a confession to make.While setting up WordPress yesterday, I had to create a MySQL database.
I hope y'all will forgive me.
Blasphemy! Blasphemy! Ban him from the...
December 3, 2010 at 8:45 am
On an interesting side note, I did not know until today that SQL Server considered text, ntext, image, sql_variant, and XML data types as "variable-length."
Oh, it makes sense when I...
December 3, 2010 at 8:33 am
sqldba_icon (12/3/2010)
Brandie the column i have deleted is a ntext data type.Would DBCC Cleantable still help? If not how do i clear space , please advice.
Do you have a...
December 3, 2010 at 8:29 am
Patrick2525 (12/3/2010)
December 3, 2010 at 8:08 am
Articles like this always interest me. .
http://education.yahoo.net/articles/quick_career_changes.htm?kid=1BOPU
Forget about the paralegal reference. Look at the others. How many of you have ever been in a situation where salaries like this would...
December 3, 2010 at 7:12 am
Chris Morris-439714 (12/3/2010)
What folks often forget about tally tables is that they are a source of rows as well as numbers.
I've actually used a Tally Table to do that too,...
December 3, 2010 at 6:43 am
stewartc-708166 (12/3/2010)
There is a difference between the data providers to connect to Excel pre 2007 vs post 2007.
Ah. Good to know. Thanks for clarifying.
December 3, 2010 at 5:34 am
Josh,
Can you give us DDL code for the other tables too? And it would help to know which of those tables in the query is the one that #mytable is...
December 3, 2010 at 5:31 am
If it does need to happen in SSIS, delete via the Execute SQL Task in Control Flow. Don't use the OLE DB SQL Component in the data flow task. As...
December 3, 2010 at 5:27 am
Viewing 15 posts - 6,901 through 6,915 (of 9,715 total)