Viewing 15 posts - 16 through 30 (of 47 total)
Forgot to mention - generally we have 3 or 4 filegroups, all with 2 files each - total size of files is about 90GB, with about 40% of that space...
June 20, 2008 at 9:10 am
You want to check out the lookup transformation. See an example here : http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx
December 13, 2007 at 6:05 pm
Gotcha. The easiest SSIS route to follow here (if you don't want to pump your data into sql and then use TSQL) is to have a data flow task,...
December 13, 2007 at 5:59 pm
I did put my not-really-efficient disclaimer on my post, so yes, Dave's right - less i/o cpu if you keep it all in SSIS and temp files until you get...
December 13, 2007 at 9:54 am
I'm confused - are you dealing with one table or several? And if several, are you trying to not duplicate PK or the whole record? Just need more...
December 13, 2007 at 9:14 am
Should be able to use ODBC, although I've never tried....
1. Set up ODBC data source in windows control panel
2. Inside SSIS/visual Studio package, right click inside connection manager...
December 13, 2007 at 9:01 am
*****Sorry for the quick trigger on the last post - hit the wrong button in the WYSIWYG editor**********
Certainly not the most efficient way to accomplish what you need, but possibly...
December 13, 2007 at 8:36 am
Not the most efficient way to accomplish what you need, but possibly the easiest if you want to avoid scripting.....
Create a package w/ a data flow task, then execute sql...
December 13, 2007 at 8:32 am
In SQL 2005, you can use DDL triggers to keep audit trails of object changes as well.....something like.....
CREATE TABLE [dbo].[DDLAuditLog](
[EventType] [nvarchar](100) NULL,
[XMLCommand] [xml] NULL,
[PostTime] [datetime] NULL,
[HostName] [nvarchar](100) NULL,
[LoginName] [nvarchar](100) NULL
)
GO
CREATE...
April 5, 2007 at 5:48 am
There are some third party tools that allow for table level restore, such as SQL Litespeed from Quest.
April 5, 2007 at 5:43 am
Sounds like a scenario that would work - we do that all the time - move a database from A to B (clustered or not) and change the DNS entry....
April 5, 2007 at 5:42 am
That's odd - I haven't checked in with Yahoo Maps API lately, so I'm wondering if they changed any of their web service calls? Is the tutorial working out...
February 21, 2007 at 11:37 am
alzdba - This is exactly what we do on our production system. We have another table where a bit gets set on or off based on business rules, and...
February 9, 2007 at 6:59 am
Theoretically.....we'll see. Give it a try.
May 3, 2006 at 7:54 am
Viewing 15 posts - 16 through 30 (of 47 total)