Viewing 15 posts - 7,366 through 7,380 (of 9,720 total)
Anyone else find it rude when someone posts a question, they get one answer, then they add a post to bump their topic back to the top of the page...
September 28, 2010 at 7:44 am
jango_41 (9/27/2010)
My clients have very experienced people, and they would be glad to use the clr triggers tat I define for their own chosen targets and events.
I do not understand...
September 28, 2010 at 7:23 am
If you used an OLE DB connection manager, use an OLE DB Destination for the Excel sheet. Not the Excel Destination.
The table or view name will be your sheet name.
September 28, 2010 at 7:21 am
The easiest way to check for the file is to embed your FTP task in a ForEach container that looks for the file. If the file doesn't exist, the container...
September 28, 2010 at 7:18 am
Please give us more information on the connection manager which points to your flat files.
Also, does the flat file have any header rows or titles?
September 28, 2010 at 7:16 am
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
Viewing 15 posts - 7,366 through 7,380 (of 9,720 total)