I'm...

I just wanted to say that from an outside observers perspective, that I admire Lynn and Gus's continued professionalism in the face of what has ended up being a landslide...

That's great. I'm sure it works just fine, but the fact is that this problem is easily solved with tools and techniques already built into SSIS and SQL Server.

I...

Frank is right on with his advice. SSIS is an ETL tool. You can do all of your validations and transformations inside the data flow before loading the...

Gkhadka (8/7/2009)

---

No, the first process ie reading from flat file and loading into sql tmp tbl and then from tmp tbl to sql hist tbl. So here we have 2...

So you've configured your For Each loop to iterate through only the files you want to remove? Use the File System task inside your loop to delete the files.

When you are referring to 'the first process', do you mean reading the file in twice using 2 data flows to load your 2 tables? In other words, the...

Dynamically building out the BCP command and calling it from SSIS is as good an option as any. Any other way you go, you get bound to having to...

Your Xml example did not make it into your post! You may want to use the Preview option next time to ensure your post looks like you want it...

Your error is a memory buffer error for SSIS. This is usually because you have a data flow that is handling too much data, your server needs more memory,...

So if your package kicks off and there are no files in the folder to process, you want an e-mail sent out? If that's what you're looking for, create...

Well, Ken covered the other option, capture the return value of the executing Proc, but I would take it a step further and code it like this:

--Run subproc

DECLARE @err int

EXEC...

To notify you via email if your data flow reaches the error condition, I'd create an OnError Event Handler on the data flow task and use the send mail task...

Go to Control Panel>>Administrative Tools>>Component Serivces. Expand Component Services>>Computers, right-click on My Computer and Start MS DTC.

Can't you just set up an Alert (using SQL Server Agent's Alert feature) to monitor the SQL Server: Locks - Number of Deadlocks/sec counter?