Perhaps this thread is of interest.

Script component is what you mean, I think.

Well done on taking the time to find a solution to your problem.

I still have concerns over the potential performance of your...

Don't think so. But you can use a combination of SUBSTRING and RIGHT to achieve the same thing - something like this (untested):

UPPER(SUBSTRING(@FileName,1,11))=="NEWPRODUCTS" && UPPER(RIGHT(@FileName,3))=="TXT"

I can't see any reason why this would help in this case, but I have generally had more success using UNC paths rather than mapped drives for jobs like this.

No problem!

Hehe.

Here's how it's done in SSIS.

1) Add a data flow task.

2) Add an OLEDB source connection to the DF.

3) In the connection manager settings for the OLEDB source, select 'SQL...

Thanks for the extra detail - makes more sense now.

If you want to avoid loops, you'll need to use the power of the database - and as the data is...

I'll start off by saying that I am almost certain that no WHILE loop will be required here.

But in order to get to a solution, I'll need to ask a...

It seems that you are not the first to come across this problem. Take a look here and see whether it might be relevant.

Jeff Moden (11/11/2011)

---

Gosh... I went back and looked at one of the links for SQL Server questions and answers. Part of the reason that I recommend NOT using such...

Not sure I understand. How is this related to SSIS?

Note to OP: sorry for hijacking your thread 🙂

Morocco is hectic and chaotic. An interesting place, with some excellent people and many more who are just trying to separate me...

Koen Verbeeck (11/10/2011)

---

Phil Parkin (11/10/2011)

---

kramaswamy (11/8/2011)

---

IF there isn't a huge amount of logic being used to transfer the data, maybe you could use a foreach loop, and have a table...

kramaswamy (11/8/2011)

---

IF there isn't a huge amount of logic being used to transfer the data, maybe you could use a foreach loop, and have a table which has the names...

luismarinaray (11/2/2011)

---

Hi,

How do you update a group of records with the following "features",

By each group, update every record, with a counter which has to begin from 1 for each group.

I...