stravis (8/18/2009)

---

It is kind of convoluted, but what do you all think of returning the results as XML then querying that XML for the column data? I have been...

stravis (8/18/2009)

---

Thanks, I tried this, but it only gets me the same result set without any data. If I run this through a query tool then I see the...

Look in BOL for SET FMTONLY. It will allow you to run a SP, but only get back metadata.

It's hard to help without more information. As requested, please post your query. In addition to that, sample data and an example of what your result set should...

I suppose that depends on what you want to do with the invalid rows. If you have 10 rows in your file and 2 have invalid dates, what do...

Some sample data along with an example of the result set you would like to see based off of your sample data would help you get a better quality answer....

I would not recommend altering the schema on a system table. If you want to have more verbose pacakge logging, create your own logging table and edit your packages...

tigrank (8/6/2009)

---

Thank you all for the replies.

We decided to develop our own app that will do this. Essentially what it does is setup triggers in each table that needs a...

That's not really enough info to help you JM. You'll need to post some sample data, your expected results, and an example of the query that you already have...

Right, I understand that. What I'm saying is that I'm sure that you've learned quite a bit as we've worked through this thread.

Why don't you make an...

OK, you should have learned enough about working with transactions in SSIS to make a good effort at this one.

Why don't you tell me what you think you...

For those of us who are not Oracle users (anymore), you'll need to give an example of a data set and what results set you expect the function to create....

Naveen,

Frank is spot on. That is exactly where I was heading! Use the data flows to do the work for you and get rid of the staging...

So RECID is unique? If so, I assume you are getting that in your file? Create 2 data flows. The first to load your parent table. ...

Enter SQL Server 2005 table partitioning. I would recommend looking into partitioning your table by date. Your delete/purge process will become a metadata switch instead of a traditional...