See my preceding post - the line in bold. It was not showing correctly before, so I just edited it. Maybe that was your problem.

Add a Script task after your SQL task.

Click on Script and In ReadOnlyVariables, enter User::InDatabase

Click on Design Script and enter just one line in Main() to make it look like...

Edit the task. Choose 'Expressions' and create a new one by clicking on the ellipsis, then select SourceDatabaseName as your property and enter the variable expression under 'Expression' ...

I think I would handle this slightly differently.

I would split the input columns so that the numeric data is in one column and the 'special' character is in another.

I would...

There is an SSIS Data Flow Transformation called a Merge Join, which takes as its inputs (sorted) data from two datasets and merges them in the way you want.

The staging...

Or, depending on the nature of your source, you could have used 'SQL Command' as your data access mode and added a suitable WHERE clause to exclude the unwanted data.

That is not what I mean. If you right click white space in the control flow window and select Variables, a list will be displayed. Column 1 is variable name,...

Can you confirm the scope of your variables?

Unless this needs to be done in (near) real time, a scheduled package containing a simple foreach loop should be sufficient for your needs ...

I added a derived column called 'Match' to a test transformation - expression as follows:

price == floor(price)

where price is a numeric(17,4) field and it worked perfectly, using the examples you...

I think I would be tempted to use an 'Expression and Constraint' Precedence Constraint to control the flow, as Excel files are not really errors, just a different path ...

Can...

Jeffrey Williams (4/17/2009)

---

The error message is telling you what the problem is:

...

The permissions on the services appear to be correct - and shouldn't need to be changed. I would...

Do you mean that you are having trouble writing the T-SQL? Or some other problem?

Yep, you need to change Local System Account to something which has the appropriate access - a domain user.

Panks (4/16/2009)

---

I have tried both dbase III and IV but they dont work.

The problem is i am not a DBA, just a developer. So i can't

download and install just any...