Creating Dynamic Outputs in SSIS to an SQL Database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Dave Lumley » Creating Dynamic Outputs in SSIS to an SQL...

29 posts, Page 2 of 3

««1 2 3 »»

Creating Dynamic Outputs in SSIS to an SQL Database

Rate Topic

Display Mode

Topic Options

Author

Message

dave-dj

Posted Wednesday, November 10, 2010 6:41 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, June 13, 2013 5:09 AM
Points: 380, Visits: 1,020

images are hosted on flickr - but they should be fine.

_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)

Post #1018553

tferguson

Posted Wednesday, November 10, 2010 7:27 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 9:19 AM
Points: 11, Visits: 268

The images are also not showing up for me, either. When I hover, it says 'screenshot' or 'query extract', but a lot of blank spaces in this article.

Post #1018598

dave-dj

Posted Wednesday, November 10, 2010 7:46 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, June 13, 2013 5:09 AM
Points: 380, Visits: 1,020

Here is a PDF copy of the article with images for those that can't see them. ( I can only guess it's because you can't access the flickr server they are on)

_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)

Post Attachments

Creating Dynamic Outputs in SSIS to an SQL Database.pdf (12 views, 786.78 KB)

Post #1018619

Samuel Vella

Posted Wednesday, November 10, 2010 7:51 AM

Old Hand

Group: General Forum Members
Last Login: Saturday, June 15, 2013 10:38 AM
Points: 329, Visits: 1,869

fszendzielarz (11/10/2010)

Oh yes. I forgot about that.

Doesn't it seem ridiculous that functionality that is already implemented is disabled for those who cannot pay for it? The irony is that MS aim to support SME and break into this sphere, so why support enterprises by denying features to smaller organisations?

Thats how software pricing works for almost every software company out there.
You want more features, then you have to pay.

SME's typically have much smaller data sets, infact even in some of the large multi national organisations I've worked for none of the enterprise features they paid for were used, even with many millions of rows, a non partitioned table structure can be made to behave.

Where there is a need for some enterprise features, SME's then just have to evaluate the cost benefit. Is paying for the extra features in Enterprise edition cheaper or more expensive than paying someone to code round the issue?

Post #1018627

tferguson

Posted Wednesday, November 10, 2010 8:06 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 9:19 AM
Points: 11, Visits: 268

Now I can see them - I'm further enlightened now. Thanks.

Post #1018643

sknox

Posted Wednesday, November 10, 2010 8:18 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 7:32 AM
Points: 1,059, Visits: 1,396

Samuel Vella (11/10/2010)

fszendzielarz (11/10/2010)

Thats how software pricing works for almost every software company out there.

Not just software. Ever look at the electronic board for a low-end product from a company which offers a higher-end product? 9 times out of 10 it's the same board with a different firmware and some (usually quite inexpensive) key components not included. Think of all the different versions of the same model car; the only difference (besides cost) is features. How about cable/satellite television? All of the channels are being transmitted regardless of which ones you paid for, so the receiver has to "disable" (i.e, not decode) the ones you haven't paid for.

Post #1018652

bigcraiginjax

Posted Wednesday, November 10, 2010 2:40 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 28, 2013 5:17 AM
Points: 6, Visits: 63

Very cool exercise. I needed to revise the create table T-SQL to the code below in order for it to work for me.

-- Check if destination table already exists, If it does not, execute the create table statement
IF NOT EXISTS (SELECT * FROM sys.objects WHERE [object_id] = OBJECT_ID(@TableName) AND type in (N'U'))
begin
EXEC (@TableCreateCmd)
end

I was using SQL 2005.

Thanks!

bigcraiginjax

Post #1018967

Edward W. Stanley

Posted Wednesday, November 10, 2010 2:42 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, December 11, 2012 3:50 PM
Points: 544, Visits: 43

Some additional steps: some code to also have a table of unknown records , in case there's a typo, id10t error or addition to the types of records... otherwise you will skip rows.

I've done the same thing previously but handcrafted the tables upon various output results. with replacement tables cycling through table.1 - table.x to so have record of the previous events for review or edit.

Post #1018968

fszendzielarz

Posted Wednesday, November 10, 2010 3:08 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 6:59 AM
Points: 3, Visits: 13

Some claim the idea of segmented pricing for software and similar products is debunked (eg: Joel Spolsky). Some say that ultimately it's he who simply offers the lowest price that should win. I wonder....

Post #1018986

mishaluba

Posted Wednesday, November 10, 2010 10:34 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Saturday, June 15, 2013 2:08 PM
Points: 525, Visits: 624

Love the detailed instructions. Worked for me "out of the box". Thank you!

Post #1019060

« Prev Topic | Next Topic »

29 posts, Page 2 of 3

««1 2 3 »»

Permissions