Honestly don't know as I haven't had a chance to use it. If RAW isn't working, perhaps just a flat file would work. I just vaguely remember Jamie...

Can you CAST(SUM(Money) as numeric(12,2)) or something similar?

-Pete

I think you can also create one directly on the Parameters section, but in general you're probably better off with the global variables section.

Also, watch out for the various properties,...

While not my direct incident, I was close by when the message was played. This happened maybe 7-8 years ago when a company I worked for wrote/supported an app...

Yeah, that "Delay Validation" setting isn't played up nearly as much as it should be from what I've seen. Most of the docs I've looked at hint that it's...

You don't for most things in SSIS. You use an expression and set the "Delay Validation" property to "True" if the table won't exist until the package creates it....

Jay, please try to work through the steps. If you encounter a problem, post details. It's not so difficult that a little trial and error should see you...

Why not do this:

Create a Global Variable called "MaxDate" or some similar name.

Create a connection to your table in server C.

Using a SQL Task, "SELECT MAX(DateCreated) FROM DB3.dbo.Table3" and assign...

I think Jamie Thompson touched on something similar to this @ his Blog Site - http://blogs.conchango.com/jamiethomson/default.aspx. I think he discussed the idea of getting the data you...

Actually, I was thinking more of making it part of the package - as a component for each file with a filter set up that matched whatever you need to...

Only problem is that I don't have any DBase or FoxPro files that I could send to you. I use those from other customers and can't create them. ...

I'd probably have used the For Each File process to look for files in the folder and process anything that matched my criteria with a final task that moved the...

I would try to create one package in SSIS and see how long it takes to write one component. If the time to develop an SSIS package is excessive...

Good book - look at Professional SSIS from Wrox or the new release from MS Press for which the name escapes me at the moment.

As for Importing DBase files -...

Just went through this on both sides. Don't put SEQUEL in your resume unless you're referring to something other than SQL. (And that's not even worth pulling in...