Please check this blog:

http://msbi2012.blogspot.com/2013/04/for-each-loop-with-file-system-task.html

Thanks

Sumit Joshi (sumit.joshij@gmail.com)

msbi2012.blogspot.com

oh...its a typo error...but the path is correct.

when ever I try using the path through variable it throw the error.

Yes you are right.

But I mean to say here that, in case of update and insert we will call it as "Upsert Pattern".

Any ways Thanks. 🙂

Thanks ,

Sumit Joshi (Lead Engineer...

Use the Lookup transformation to do such type of task. This scenerio is also called as Upsert Pattern.

Thanks ,

Sumit Joshi (Lead Engineer - HCL Technologies)

Moblie:- 0-9650899699, Skype: sumit.joshij

Blog:

Or in more complex scenario using the Derived column, you can use the given below expression:

REPLACE([Column 1],"\"","")

Thanks and Regards,

Sumit Joshi

Moblie:- 0-9650899699, Skype: sumit.joshij

Blog: http://msbi2012.blogspot.in/

Use "text qualifier" in File Connection Manager as " (doubleQuotes).

🙂

Then you have the attribute in it.

Check http://msdn.microsoft.com/en-us/library/ms345137(v=sql.90).aspx link for your reference.

Thanks

Sumit Joshi(sumit.joshij@gmail.com)

There is no XML Destination.

Workaround:

1) You have to convert you query in XML format like "FOR XML AUTO" or "FOR XML PATH"

and 2) then choose the destination in...

Thanks a lot.

thanks. its working in some of my test sample data.

you have to do it from script task.

can you plz share the sample file.

just go to the advanced tab-> output column and change the datatype.

or

use the conversion task.;-)

Please check your SP rights. this problem exist when the rights are not placed to you...;-)

Please check on http://msbi2012.blogspot.in/2012/09/expression.html