0

Hi all,

With BIDS (Business Intelligence Development Studio)/SSIS, I have a process that downloads zipped CSV files. I store the files using the naming convention from the source ie 03260020-eng.csv. In a script task using BIDS, I would like to rename the file to exclude "-eng" but I'm not sure how to go about this. I have an idea to use a Right Trim but am unsure about the syntax. Can someone guide me with this?

3
Contributors
8
Replies
11
Views
4 Years
Discussion Span
Last Post by Stuugie
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.