OK, here's what you'll need to do.

1. Set up a For Each Loop Container in your control flow.

-- Collection tab settings

...

Your UPDATE statement is written to where it would update the entire wce_contact table if your sub-select returns a rowcount > 0.

Can you post your table DDL for wce_contact? ...

So you have CSV files that were generated from some source that you want to import into a SQL Server instance using SSIS. Are all of the CSV files...

Have you looked into Package Configurations?

Let's see if we can get Steve's take on that question.

Or maybe document it in an...

Where is it getting the table name from? It looks like you've got double quotes in the table name.

So if you set up an OLE DB connection in SSIS and use the 'Test Connection' button, does it connect?

ODBC may work, but you may find it to be a...

Phil Parkin (6/22/2009)

You might also consider doing...

jeffrey yao (6/20/2009)

Michael Valentine Jones (6/18/2009)

Just say that “normalization” is theoretical nonsense that so-called gurus like Date and Celko throw around...

Peter, have you tried using the file system task with the copy option?

So when you tried the ODBC connection, did you already have an ODBC data source configured to your Sybase DB? What happens if you try to connect to the...

What are you wanting to do with the filename? Have you thought about using package variables to get it in there instead of trying to access the connection manager...

It's just a difference in how the data providers read the data. If you're reading it from flat file, it does not know what the original format was from...

I don't know if they are really bugs. The Checksum function does not guarantee uniquness so you could end up with a row being identified that is not a...