Viewing 9 posts - 1 through 9 (of 9 total)
Am I correct in assuming that Transaction replication with Immediate Updating Subscribers also requires primary keys to be added to each table, or at least each table that gets updated...
December 22, 2009 at 6:54 am
Thank you all for your input and help on this. I'm going to use the bulk insert, as we've had some problems with SSIS package that's in place now.
Steve
November 24, 2009 at 1:19 pm
I looked at BULK INSERT, but unfortunately the comma-separated values have some fields that are
also delimited by double quotes, like this...
...MWF,0227813,"Miller,Steve", 1,PI, 0,Y,UWCOL,BRB1501,BRB Administration,...
Is there a way...
November 23, 2009 at 1:50 pm
Hi Jan,
Yes, you're right, it's not a temporary table, and the real table has many more columns, as it's actually part of a data mart, an extraction from an Oracle...
October 1, 2009 at 6:52 am
No, I don't want the trigger to enforce uniqueness. The sole purpose of this trigger will be to update a column in which there isn't a value, based on...
September 29, 2009 at 8:37 am
Thank you both, that's what I figured. It gives me another reason to ask that we put a primary key on the table, as I didn't find any columns...
September 24, 2009 at 6:09 am
Awesome Jeff, thank you very much, the results are just what I wanted!
Steve 🙂
July 23, 2009 at 8:01 am
Jeff,
Thanks for your advice on posting etiquette, this was my first post. It didn't quite work though, now the CSV file that is being created surrounds the values...
July 22, 2009 at 11:35 am
Viewing 9 posts - 1 through 9 (of 9 total)