If you want to add a column at runtime in...

smriti.subramanian (8/15/2009)

---

i thought the password might not be saved and added a config file and saved the password. But then too it gave the same errors. can you suggest me...

In the Flat File Source, did you select the checkbox for "Retain null values from source as null values in the dataflow"?

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.

http://msdn.microsoft.com/en-us/library/ms191432.aspx

Nice introductory article, Andy! Can't wait for the rest of the series.

Kiara (3/29/2011)

---

I'm going to take a moment and thank you all yet again for help that you didn't know you just provided.

...

Major enough that it answered the entire design dilemma...

sobhan.ksb (3/29/2011)

---

Thanks for your response,

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...

Indeed, that's how it works 😀

That's odd, SQL Server 2005 shouldn't have the...

Was a log file created?

The SQL Server 2008 instance, is it a named instance or is it the default instance?

You can use the Import/Export wizard of SSMS to create an SSIS package. Then schedule this package in a SQL Server Agent job.

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...

What is the protectionlevel of the package?

Almost, the correct expression is:

ISNULL ([COLUMN_B]) ? [COLUMN_A] : [COLUMN_B]

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...