Pull "unformatted" data into existing table structure via SSIS?

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Pull "unformatted" data into existing table...

Add to briefcase

12 posts, Page 2 of 2

««1 2

Pull "unformatted" data into existing table structure via SSIS?

Expand / Collapse

Author

Message

Posted Thursday, March 14, 2013 11:24 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:06 PM
Points: 32,930, Visits: 26,816

BWAAA-HAAA!!!! opc.three and a lot of others are going to hate me for this.

This is an easy task in T-SQL using xp_CmdShell, dynamic SQL to build "BCP out" commands to build a format file for each table programmatically. Then you don't even need SSIS because you can then use BULK INSERT right from T-SQL using the format files. In fact, even the BULK INSERT commands can be built programmatically with just a smidgin of forethought and planning. It only needs to be done once so hopefully no one gets too cranky about using the wonderful tool known as "xp_CmdShell". Wink

Wink

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1431359

Posted Friday, March 15, 2013 9:41 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 8:26 AM
Points: 6,737, Visits: 11,791

Barkingdog (3/14/2013)

Thank you very much!

edm2

You're quite welcome!

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1431599

« Prev Topic | Next Topic »

Add to briefcase

12 posts, Page 2 of 2

««1 2

Permissions

Expand / Collapse