yosiasz (11/3/2009)

---

Yes I have tried it and ran into too many issues which was the 443th issue, I thought it was not clearing the Sheet when actually it was but...

No - it should not do that. For some reason, the Excel driver thinks that there is data in the spreadsheet in the preceding rows.

Try recreating the template from File/New...

What is the format of the DBF files? Are these database files? What driver are you using to connect to them?

Is the meta data in all the source files the...

Have you checked the Forced Execution Result (or similar - haven't got SSIS open right now)?

Of course UTF-8 is supported.

Truncation errors happen (usually) because your source data is too wide for either:

a) The variables they are held in as they pass along the SSIS pipeline,...

stricknyn (11/2/2009)

---

Hi all,

There's no CountIff feature in aggregate task? I have data in one of my dataflow columns of my data flow component in which the data is arranged...

🙂 I'm sorry, but I'm out of ideas. This is simple and there's not much else to check.

Describing something in an IT process as "not working" is rarely going to give people sufficient information to allow them to help diagnose a technical issue.

Your assumption is correct, so something else must be happening.

a) Double check the scope of the variables

b) Double check that the variable is actually being set as you think (Msgbox...

This is also simply achieved with a short piece of script, if you feel like dabbling. This would have the added benefit of not feeling like a bit of a...

Get that man a beer :exclamation::exclamation::exclamation::exclamation:

I am impressed & will no doubt be checking out this thread again when next I have to import from Excel 🙂

No problem & good luck. Too many people have wasted too much time on this Excel data-typing / NULLing issue.

Thanks for going to all that effort Peter - it will come in very useful in the next couple of days.

No - those approaches won't work. The data doesn't even make it into the data pipeline.

The Excel driver 'decides' on a datatype for every field as it is pushing the...

Your VB sample is just doing the file copy - am I right?

How are you structuring the rest of your package (the backup/restore bits) to achieve the parallelism you are...