Viewing 15 posts - 9,646 through 9,660 (of 11,678 total)
Sarath Vellampalli (5/7/2007)
I created one newpackage and i want to add one new column in the destination table at package runtime.
If you want to add a column at runtime in...
March 30, 2011 at 2:12 am
smriti.subramanian (8/15/2009)
March 30, 2011 at 2:09 am
In the Flat File Source, did you select the checkbox for "Retain null values from source as null values in the dataflow"?
March 30, 2011 at 2:07 am
Nice question, but the answer is confusing. The first index should be a unique clustered index, but you can add more non-clustered indexes later on.
March 30, 2011 at 12:18 am
Nice introductory article, Andy! Can't wait for the rest of the series.
March 29, 2011 at 11:59 pm
Kiara (3/29/2011)
...
Major enough that it answered the entire design dilemma...
March 29, 2011 at 6:57 am
sobhan.ksb (3/29/2011)
I tried with import\export wizard, but i need a select query with condition where it can export only updated every one hour data between two...
March 29, 2011 at 6:10 am
brian.melvin (3/29/2011)
But I suppose I have to learn what Microsoft want me to 'know' in order to pass the exam
Indeed, that's how it works 😀
March 29, 2011 at 1:35 am
MarvinTheAndriod (3/28/2011)
Its being run on 2005 SSIS, the command line is as follows:/SQL "\STImport" /SERVER "DA-ACC-1" /X86 /CHECKPOINTING OFF /REPORTING E
That's odd, SQL Server 2005 shouldn't have the...
March 29, 2011 at 12:51 am
Was a log file created?
The SQL Server 2008 instance, is it a named instance or is it the default instance?
March 29, 2011 at 12:46 am
You can use the Import/Export wizard of SSMS to create an SSIS package. Then schedule this package in a SQL Server Agent job.
March 28, 2011 at 11:44 pm
You can either do it in a script task (as it is only one single value), or you can create a named range into the excel file (that just contains...
March 28, 2011 at 11:43 pm
happycat59 (3/28/2011)
I think you will need something like..ISNULL ([COLUMN_B]) ? [COLUMN_B] : [COLUMN_A]
Almost, the correct expression is:
ISNULL ([COLUMN_B]) ? [COLUMN_A] : [COLUMN_B]
March 28, 2011 at 11:40 pm
opc.three is right, with "refresh" they just mean load data into the destination.
This is how you solve such questions:
answer C and D can immediately be eliminated, as they have nothing...
March 28, 2011 at 11:35 pm
Viewing 15 posts - 9,646 through 9,660 (of 11,678 total)