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...

Use the FLOOR function - it exists in SSIS as well:

if number = floor(number) then

--number is whole

else

--number is not whole

end if

Using what - VB.NET?

Check out this thread:

http://www.sqlservercentral.com/Forums/Topic285021-146-1.aspx

Or Visual Foxpro, for which another (free) driver is almost certainly required.