Viewing 15 posts - 7,366 through 7,380 (of 9,715 total)
If you don't need dynamic destinations (like the above post points you to), just create an OLE DB Connection Manager for your Excel sheet using the Jet 4.0 connection and...
September 28, 2010 at 7:15 am
How's this for a motivational poster?
http://icanhascheezburger.com/2010/09/27/funny-pictures-teamwork-pandas/%5B/url%5D
September 28, 2010 at 6:00 am
Okay, so is the dynamically generated table a temp table or a "real" table?
You shouldn't have to use OpenDataSource in SSIS. I've been able to direct "traffic" to specific worksheets...
September 28, 2010 at 4:42 am
Chris Morris-439714 (9/28/2010)
Brandie Tarvin (9/27/2010)
Kit G (9/27/2010)
September 28, 2010 at 4:36 am
Kit G (9/27/2010)
Of course, now that I have it working, I get told, "...not all the data will be available..."
The worst thing a DBA can be told is "not all...
September 28, 2010 at 4:32 am
GilaMonster (9/28/2010)
Stefan Krzywicki (9/27/2010)
GilaMonster (9/27/2010)
Tom.Thomson (9/27/2010)
September 28, 2010 at 4:28 am
Have you looked into DDL triggers yet?
You can use them to rollback transactions (in this case for INSERT statements). The only caveat is that I can't remember whether they...
September 28, 2010 at 4:26 am
It's not a domain issue. This was entirely local to the server. See my last post.
September 28, 2010 at 4:09 am
You're posting in the wrong forum group. This is the 2005 group and your BOL reference refers to 2008. Try posting there.
September 27, 2010 at 12:04 pm
It sounds like your user is possibly confused. But here's a quick Replication primer that might help you speak to him about his needs.
In every version of replication (Merge, Transactional,...
September 27, 2010 at 11:53 am
So far as I know, Management Studio does not have a debug tool.
Could you rephrase your question?
September 27, 2010 at 11:44 am
Wait. I'm confused. Are you selecting from an Excel spreadsheet or from a SQL Server table (dynamically generated)?
I know you're inserting INTO an Excel spreadsheet. I just don't understand the...
September 27, 2010 at 11:39 am
CirquedeSQLeil (9/27/2010)
Brandie Tarvin (9/27/2010)
Anybody know of a way to track readers on LJ?What is LJ?
LiveJournal.
September 27, 2010 at 11:36 am
CirquedeSQLeil (9/27/2010)
Brandie Tarvin (9/27/2010)
Because he can't afford all the others. @=) It's not just the dentist he has to pay, you know. Daughters expect kickbacks whilst they slumber.
A mouth full...
September 27, 2010 at 11:35 am
Viewing 15 posts - 7,366 through 7,380 (of 9,715 total)