Are you using a precedence constraint between the data flow and the filesystem task? This should insure that the data is extracted from the file before the archive process...

You could use one or more conditional splits (one for each quality check) that would either allow the row to pass through to the primary output or be redirected to...

Charlotte, I wrote an article on this topic recently - hopefully this will help:

http://www.sqlservercentral.com/articles/SSIS/68025/

hth,

Tim

There shouldn't be any reason that you can't do this, unless you have an issue of contention and you're getting deadlocks or excessive locking. When you say you cannot...

Actually, the example you mentioned, using "sp_" as part of a stored procedure name, is not forbidden by the database engine. It is considered by many to be a...

I ran across similar issues some time back when using one my backup dev machines, and it turned out that I was using an RTM (unpatched) version of BIDS 2005....

I don't recall having connected SSIS to a Pervasive system before. I've put a request out to the SQL folks on Twitter to see if anyone can help you...

Are you able to make modifications to the source files? If so, consider archiving the source files to a different directory after processing using the File System Task. ...

I'd start by trying Phil's suggestion, since mapped drives can be unreliable. But since you're getting a return code from the executable, the problem may be related to the...

I'm not quite sure what problem you're describing here. Are you trying to do many lookups on the same table? If you're using SSIS 2008, you can use...

I don't know of such a tool. If you're comfortable hacking XML, you possibly could create your own documentation tool to read the DTSX file and extract that kind...

Brian Knight has written a couple of books on SSIS, for versions 2005 and 2008. He just published a new book names 24 Hour Trainer (or something similar) that's...

It sounds like your string is being treated like a number, though from what you describe it shouldn't be. Perhaps the metadata on your source is out of date?...

Sure, you can hard-code the filename in the config file if you want to use a single output file (rather than one file per iteration of the loop). Be...

Jananth, you can use a configuration file to set the filename, but when used in the context of this example, the filename declared in the expression would win out at...