Did you try using OLE DB Destination instead of SQL server destination.. bcz many times SQL server destination behaves weirdly..

Can you post your table structure ... Does all the fields in your dest.. table it allow NULL Values???

What are you trying to do exactly??? I thought u just wanted to update your table.. using a raw file

Since the values of a result set are normally stored in a object they cannot be retrieved .. Alternative is to use a script component and convert this object variable...

you can use expressions instead of the column... basically replacing the column with ISNULL and IF ELSE Expression

Thats a very nice article.. thanks a lot willem..

The easiest way to this would be to use a data flow task with Source and Record Set Destination that will hold your values in a variable...Then in the Control...

Elliott's Link will probably give you a good explanation...

As phil suggests the best way would be to use IsNULL() but ... what's important is what to do u want if its a NULL value.. DO u what to...

My approach would be to use a for each loop with a script and the other desired workflow process.... i would loop through all the files and use a script...

See the attachment... you should see it in the same path... Did you build and deploy the package to the msdb?? If you connect to SSIS using SSMS are you...

did not get you...

This can be done in many ways.. one of them being using script task..I think that Everyone working on SSIS needs to know basic scripting because there are many things...

By looking at your post all i can think of is that your getting an error while parameters to the Execute SQL Task bcz you are using "?" parameters before...

What does your result set look like... does it have the Email address... Can you post some more information about what you are trying to do...

Probably you can achieve...