Great - thanks for that!

Have you configured the output as 'Append' or 'Overwrite'?

If only the final file is appearing in there, I would suspect 'Overwrite'.

Andrew Watson-478275 (4/19/2013)

---

Yes, but it will recalculate that connectionstring every time it uses it (i.e. every time round the loop).

Create a new variable User::FullOutputFileName (or whatever), and assign its value...

No. Each side of the AND condition has to be evaluated to determine whether the row is selected.

But...

SQL Knight (4/18/2013)

---

All 3 of these AS Clause below will work in MS T-SQL.

But my question is which on is more proper type of formatting for T-SQL (Now and in...

I've just read this a few times and I'm still not sure what you mean. What, exactly, do you mean by 'short circuit'?

manibad (4/18/2013)

---

thanks for everyone who have replied..

Actually i am not in a position to work on SQl or Script task and code the data to achieve my destiny..i can do...

I don't think that there is an IsDate function in SSIS. If you don't mind doing a bit of coding, you could create a script component and do a Regex...

You are responding to a post which is nearly five years old.

Can you load your data from a CSV file rather than Excel? Things will work better if you can change your source.

Is your column really called Column_Name?

Paul Hernández (4/15/2013)

---

Hi Phil,

Thanks for your quick answers.

In my case the source is a OLE DB component, and the reason to do such a things is the final destination is...

So do you mean that somehow you will check all of the data values in all of the columns, looking for those columns which do not contain any values at...

Can you possibly attach a screen shot showing how things are connected?

Have a MERGE proc and call that instead?

I would refine your REPLACE slightly to include the '.' - this would help avoid the problem Mark mentioned.

update Documents

set DocumentFileName = replace(DocumentFileName, '.TIF', '.pdf')

where...