Correct!

No. You use SQL Server Business Intelligence Development Studio (BIDS) to edit packages.

Jason Coleman (4/9/2010)

---

Yep...thats finally what I have had to do.

Seems strange though that the final task seems to transform the data on its own. even if u tell it...

Once you have a string field which contains, for example .75

you can add a derived column that prepends a 0

the string is then 0.75 and that is what will go...

You could try putting a data conversion task in - to cast your numeric field as string - and then map the converted field to your destination, after manipulating the...

Exactly the same error? If not, please post the error message.

No - mine was stuffed from the start 🙂

I've had unexpected problems with the File System task in the past. In the end, I threw in the towel and wrote a bit of script in a script task...

Jason Coleman (4/8/2010)

---

That is what I have described in the first post...

I can make the script so it searches for a particular file, but when the file (or files)...

Have you tried using the Send Mail task?

SQLStatementSource, I think.

Use an Expression within an Execute SQL task to combine static text and variables for your UPDATE statement.

As long as you can find some suitable selection logic, you could use a conditional split to redirect header rows (to nowhere).

(from memory) In your dataflow, just right-click on the line from your datasource and select Add DataReader.

Then follow the prompts to add the columns you are interested in.

Then when you...

If you add some data readers in your data flow just after your source, you should be able to easily verify whether the modified data is being read.