How big is your database. I am assuming you are doing this just to do some development/testing for yourself? If that is the case, just an OLE db source to...

You can try what I do for the same thing. I put it in my own drive and call it from the file systems task ( under existing folder) each...

I am guessing here. I was confused when you said it worked fine everytime but then sometimes it fails. Then when I reviewed your error, there is something that it...

This should not be a problem. I have done this before. Please correct me if I am wrong. You want to dump ALL the tables in SQL database to ONE...

Lee Hemmings (2/14/2008)

---

I have simple SSIS package which i created using the export wizard and saved it.

I then open it in BIDS to add the email task. But the...

I also think the same way. I think there can be some problem in the configuration. If not, it can be the jobs created by mistake. Did you call the...

Make sure you close ALL package when you exit SSIS each time. This way, when you open it next time, you just have to navigate to your package and open...

I hope you don't have too many columns to ease your problem here. Basically, this is one of those famous problems where the flat file would have been generated by...

tanmayi_mukundan (2/12/2008)

---

Hi all,

I have used an OnError event handler in my package where it logs when an error has occurred. However, if the package stops executing midway or the execution...

I hope it is as easy as this. I am quite not clear with your question whether you are trying to do something else or not but this is where...

Thanks of helping. I got the same as yours from the MSDN site, but...

Matt Miller (2/14/2008)

---

I don't know if this helps you - but if you use the data conversion task to attempt the conversion - there's a "red arrow" coming out of...

Thanks so much for that idea. I tried it out and it worked. I am also trying something easier. If I ever succeed in that, I will share it. But...

Forgot to add that if everything matches and when the success file goes, those source flatfiles will enter my Database table. I know how to do this but just wanted...

Okay, let me put it this way, probably I was making everyone confused as I myself was one!

Day 1: I will be getting in source data from flat file to...