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.

Are you looking for the function to do this?

Eg

if a <> int(a) then ----> error file

or more detailed instructions? I'm assuming that you are not operating within SQL -...

Can you describe roughly why you need to run the SP so frequently and give us an idea what it does. Maybe someone here will have other ideas about how...