Another option is to use a temporary table to store your update records.

Then, after the data flow task, you can issue one update statement against the destination table using the...

I don't believe it is possible to do it right away in the Flat File Source.

However, you can add a derived column component to add the doubel quotes:

"\" + MyColumn...

Phil Parkin (5/21/2010)

---

da-zero (5/21/2010)

---

Yeah, I'm very fortunate to have never worked with Access before, so I didn't realize the getdate() function doesn't exist in Access. Apparently Now() is the equivalent...

Yeah, I'm very fortunate to have never worked with Access before, so I didn't realize the getdate() function doesn't exist in Access. Apparently Now() is the equivalent (Google is your...

Can you show us the query that you are using?

If it is just nvarchar to varchar casting, do the following:

create a global temp table (or a fixed staging table, it doesn't really matter) that has the exact same structure...

Has the number that comes from the input file always two digits after the decimal point?

sachinrshetty (5/21/2010)

---

Hi I have used query in my source but how to write query to fetch rows containing todays date only.

I have used below query

SELECT ...

You have two options:

either filter on the data when you select it from the Access database (with a WHERE clause or something like that).

EDIT: Phil Parkin apparently already suggested this...

Can you give us the exact error, the expression that you use in the derived column editor and some sample data?

tommyh (5/21/2010)

---

da-zero (5/20/2010)

---

Why is the correct answer 4?

I count 7 types of indexes:

clustered, non-clustered, unique, index with included columns, indexed views, full-text and xml.

See http://msdn.microsoft.com/en-us/library/ms175049(v=SQL.90).aspx.

Even in the explanation given I...

Why is the correct answer 4?

I count 7 types of indexes:

clustered, non-clustered, unique, index with included columns, indexed views, full-text and xml.

See http://msdn.microsoft.com/en-us/library/ms175049(v=SQL.90).aspx.

Even in the explanation given I count more...

I think you have to deploy the entire cube.

But I believe that won't take so long, unless there is massive validation to do.

The following set-up should work:

in your script task, create 3 variables that will hold the counters.

Create a nested if then else statement in the Input0_ProcessInputRow method, which checks the value...

To be short: you can't do dynamic column mapping with out-of-the-box SSIS. The metadata will always be screwed over.

The only option is to use script tasks/components to dynamically read/write your...