Viewing 15 posts - 1,111 through 1,125 (of 3,232 total)
stravis (8/18/2009)
August 19, 2009 at 9:06 am
Look in BOL for SET FMTONLY. It will allow you to run a SP, but only get back metadata.
August 18, 2009 at 4:52 pm
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...
August 18, 2009 at 2:26 pm
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...
August 18, 2009 at 2:23 pm
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....
August 18, 2009 at 2:21 pm
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...
August 18, 2009 at 1:49 pm
tigrank (8/6/2009)
We decided to develop our own app that will do this. Essentially what it does is setup triggers in each table that needs a...
August 18, 2009 at 1:43 pm
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...
August 18, 2009 at 1:35 pm
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...
August 18, 2009 at 11:08 am
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...
August 18, 2009 at 10:55 am
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....
August 18, 2009 at 9:34 am
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...
August 18, 2009 at 9:17 am
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. ...
August 17, 2009 at 12:27 pm
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...
August 14, 2009 at 2:33 pm
Besides the MLK identity column, is there any way to uniquely identify rows? What is RECID?
August 14, 2009 at 10:12 am
Viewing 15 posts - 1,111 through 1,125 (of 3,232 total)