If there is no delimiter, it is, by definition, not a CSV file.

It's a fixed-width file and you can use SSIS to import it and break it into its constituent...

ameda16 (7/27/2010)

---

an idea: use no cashing instead of full precaching, the default caching type

No caching, in which the reference dataset is accessed by each row in the rowset. To...

So your DF contains duplicates? Why not get rid of them early in the DF and save yourself the trouble? If not, what happens when the lookup is successful? How...

Looks like you are running that code for every row in your pipeline and then assigning a single result - presumably based on the values in the last row in...

Define your flat file source to be fixed width (not CSV). Then define your fields based on start pos / length etc - haven't done it for ages, so can't...

So you want the same value in every row?

That's fairly easy - here's how.

Create a package scope integer variable to hold the count.

Create an Execute SQL task to run the...

Please provide more detail - your requirement is difficult to understand. An example would help.

Have a look at the MERGE JOIN transformation - maybe that can do what you need. Difficult to know for sure without seeing examples of your data.

This thread looks very similar to this one:

http://www.sqlservercentral.com/Forums/Topic955373-148-1.aspx#bm955545

Why are you asking the same, or nearly the same, question again? What was wrong with the solutions proposed?

Looks to me like your delete query is not sophisticated enough and will leave behind orphaned records - except your referential integrity rules are currently stopping that. Be careful.

niffer76 (7/23/2010)

---

I am still struggling with this a bit. I have set up the ForEach loop container to pick up the files based on the file name using "*"...

You'll need three dataflow tasks.

That does not mean that you need three packages. You can chain from one DF to another, or run them in parallel, within the same package.

Are you saying that...

That article refers to an import to SQL Server, not an export to Excel.

Can you try explaining what's going on?

Why do the INSERTs fail?