The syntax looks correct.. can you post the error?

1) The easiest way would be to take the file as a source and use a Derived Column to Find and Replace and then insert them into a new file.....

That's right .. it will result in a meta data error... If you want a dynamic approach you need to use Script component

I am not a core programmer.. i have used similar code as below in the past (got it from a website, not sure where) .. I have modified it a...

Its hard to tell with that error message.. you definitely need to provide the complete path.. In the Excel connection Manager, browse and then select the correct file..

Alternative Approach:

Try to...

What is the current value of your variable... if you left it blank.. Enter a Filepath(preferably the text file path that you have used in the DFT). You need...

Definitely, the string value should be inserted between double quotes and try this

(DT_DBDATE)(DT_STR,10,1252)(YearE == "00" ? "" : ((DT_STR,4,1252)YearE + "-" + (DT_STR,2,1252)MonthE + "-" + (DT_STR,2,1252)DayE))

the most important thing...

Nice to see that it helped.

yeah , try changing the where clause as terraberry suggests.. there's a high chance of wrong output when you miss\exclude "()" when using "OR" & "AND"

I understand Elliot, i replied to post only to say that he has an option of writing a switch case Exp also, if he wants to and if performance is...

Please check this link below with a similar problem.. i would suggest you to use Variable Input as Input Type in the Execute SQL task and use Record set destination...

You can use a Switch case as an EXP in derived Column...

imani_technology (5/11/2010)

---

Exactly! For example, let's say there is a "Group" column in the data set. Based on that value, the output file should go to either:

\Main Directory

\\ Group...

Dont know how can you solve that issue using SQL but SSIS would be the best and easiest way.. If you want to try, Let me know i can help...

You can do that.. assuming that you have a variable which stores the complete path of the file like C:\foldername\foldername\filename.. if so, then create another variable and use substring and...