Can someone please help me on this one still?

WOW guys! Thanks for the great help. I really appreaciate the help. I know that without solid column, it is hard to compare datas, but the way the data is...

Thanks for the support. But how is the comparison supposed to work? Meaning, there is no specific column given to me to compare the two day's data (yesterday, today...and so...

I don't understand your problem. You want...

Lynn Pettis (1/10/2008)

---

I would also recommend buying a book on SSIS. Wroks has a very good book that would be helpful: Profession SQL Server Integration Services 2005 (I hope...

Yap, Maybe someone can help you with that if you post a new one.

cbrinson (1/9/2008)

---

1) Under Server Explorer in Visual Studio I can open the DSN that connects to my source Btrieve database (It is not a SQL Server 2005 database). I can...

I believe you can use the [Conditional Split] transformation and then [Send Mail Task]. This will easily solve your problem.

Well, I think you are really stuck. Okay. Now that you have been seeing the interface for several days, it is easier to coach you.

First: Can you confirm where...

cbrinson (1/8/2008)

---

Thanks for the replies. I just started reading BOL today. My boss has unrealistic expectations. I need to extract data from a Pervasive SQL database, transform it and use...

I guess you have just started using SQL Server 2005. SSIS stands for SQL Server Integration Services. It is totally different than what we had in SQL 2000 previously even...

I learned a lot about certification when some questions asked like this. What's up with all those people that want dumps rather than studying hard for the exam? It benefits...

I have done this in past and it is pretty simple. Just check the Over write data in the file option under connection manager tab in your Destination flat file...

There is some good question posted by Lookup_BI below your post. Lets wait for the answer there and see if that would really help you prepare for the exam. Read...