It's hard to do that directly in the dataflow, so I would suggest that you read all your data first and then write it to some sort of staging table...

When I read your recommandation for refreshing the metadata of the data source, I get the feeling that in the case of an OLE DB Source, you select the table...

Thanks for the info.

Shouldn't the order by 1,2,3, instead of 1,1,1?

I think that if you give them all the same order, they are evaluated at the same time, and of course no row...

Thanks for the link!

Nice question. I didn't know that constants (like 1) could be placed after CASE, so I definately learned something today.

Doesn't Amazon ship to Indonesia?

Regarding the first problem: that's quite odd that the package still fails after removing the tasks. But, with SSIS and its underlying metadata, you never know. Without the exact error...

Sorry, I was wrong. (In my mind it was OK, but I wrote it down incorrectly :-)).

If you copy entire packages or if you deploy them to other systems, the...

SSIS uses internal ID's for its connection managers under the hood.

Normally, copying packages will not harm your connection managers (I do it all the time), but it will screw up...

What is the purpose of the package? What tasks/data flows/components are present in the package?

chaudharyabhijit (5/21/2010)

---

Hello,

The expression is working and everytime i run the data flow i do see a new file come up with the current date. Now i have placed this data...

It seems it is has something to do with the logging.

Check if the connection manager used to log is configured correctly.

(it should point to a specific log table in the...

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