|
I am developing a package where I extract data from a excel source to my database.The data in the database is slightly modified from the input data and hence I use a Derived Column Transformation in the package.The column data I modify is as below. "(DT_STR,260,1252)(("DIR" + "\" + (SupplyDemandSpecialistEnterpriseId)))". I give the above statement in derived column where I need to concatenate "DIR" + "\" to the data in the column SupplyDemandSpecialistEnterpriseId. But I get error that the column cannot be parsied and that it has invalid elements.I tried other special characters like *,-,/,& in the place of "\" and it works fine.I tried the below statement too. "(DT_STR,260,1252)(("DIR\" + (SupplyDemandSpecialistEnterpriseId)))". But still get the error. Can anyone please guide me????It is urgent.
(comments are locked)
|
|
Hi, Sorry.Some problem in the editor.Actually my doubt was to use a single backslash beteween the quotes. It goes this way. "(DT_STR,260,1252)(("DIR" + "[single backslash]" + (SupplyDemandSpecialistEnterpriseId)))". I don know why backslash went missing after I submitted the question. Anyways the solution for the above mentioned problem is to use a double backslash in the place of a single one. Good that you sort this out yourself. And since it is the answer to your question, then mark it as the accepted one :)
Jan 29 '12 at 10:08 PM
Usman Butt
(comments are locked)
|
|
Is SupplyDemandSpecialistEnterpriseId a string type or an integer type? Is it possible that you need to convert that data to a string in order to concatenate it?
(comments are locked)
|
|
you need to double the backslashes when using them in SSIS expressions.
(comments are locked)
|
