I created a package with a Foreach Loop container.  It loops on all files in a directory and put the current file name in a variable "FileName".

In that container, there's...

You could use a ForEach loop container and put the data flow task inside.

Can you give a more detailled error msg?

Is the file used for the Flat File Connection available from the server?  Example, if it is C:\Folder\File.csv, that file should be in...

I had the same problem.

The OLEDB driver provided by IBM is bugged.

We use Microsoft's now.

Try REPLACE([AssetDescr], "\"","in")

I hit that kind of problem once.

Let's say you have a list of value you want to compute the ratios:

id - qty

1, 10

2, 20

3, 30

4, 40

You want to calculate the...

Yes it can be pretty confusing...

When the FileSystem Task asks for a Source Connection ("Specifies the connection of the source files"), it is actually asking for a single file not...