<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>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<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
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Stewart Campbell
»
Data Import
20 posts, Page 1 of 2
1
2
»»
Data Import
Rate Topic
Display Mode
Topic Options
Author
Message
Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
Posted Wednesday, November 11, 2009 10:37 PM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 8:26 AM
Points: 3,164,
Visits: 4,344
Comments posted to this topic are about the item
Data Import
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #817609
EdVassie
EdVassie
Posted Thursday, November 12, 2009 5:07 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 5:46 AM
Points: 2,636,
Visits: 2,788
I would be interested in knowing what the so-called JCL limitation is. With over 20 years mainframe experience it would be a new one for me (unless it is a limitation in the user's knowledge of JCL, I have seen that one before...).
Author:
SQL Server FineBuild
1-click install and best practice configuration of SQL Server 2012, 2008 R2, 2008 and 2005.
4 June 2013
: now over 24,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #817729
inus.dupreez
inus.dupreez
Posted Thursday, November 12, 2009 5:33 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, October 09, 2012 2:13 AM
Points: 162,
Visits: 76
good q
Post #817742
Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
Posted Thursday, November 12, 2009 6:10 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 8:26 AM
Points: 3,164,
Visits: 4,344
I too have well over 10 years experience on mainframe, mainly cobol and db2 on z/os. limitations could be put in place for numerous reasons, including, inter alia, the transport mechanism used to move the files (e.g. x'com), network restrictions and, as stated, user (lack of) knowledge.
however, the mention of "jcl limitations" is just incidental to the actual question, i.e. the most effective and efficient way to import the data and populate an SSAS cube.
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #817761
EdVassie
EdVassie
Posted Thursday, November 12, 2009 6:14 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 5:46 AM
Points: 2,636,
Visits: 2,788
Agreed. The main point of the question is about how to import a number of files.
Author:
SQL Server FineBuild
1-click install and best practice configuration of SQL Server 2012, 2008 R2, 2008 and 2005.
4 June 2013
: now over 24,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #817765
Rob Goddard
Rob Goddard
Posted Thursday, November 12, 2009 6:15 AM
SSChasing Mays
Group: General Forum Members
Last Login: Friday, May 24, 2013 5:20 AM
Points: 660,
Visits: 558
Excellent question, stewartc, thank you!
I wish you had set this question a long time ago, this could have saved some people some work... How did this slip under my radar?
--------
I love deadlines. I like the whooshing sound they make as they fly by.
-Douglas Adams
Post #817767
Mark Harr
Mark Harr
Posted Thursday, November 12, 2009 6:15 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, March 22, 2013 6:48 AM
Points: 1,297,
Visits: 138
I second Ed Vassie's question on the supposed JCL limitation.
I got the answer right, only because the category was SSIS and I figured that one of those two answers must be the one being driven for. However, SSIS is
NEVER
the most
"efficient"
solution. I'm sure there is a much more efficient solution using BCP or Bulk Insert (not with a cursor, that was an obvious bad answer), perhaps using CLR stored procedure, or perhaps concatenating the files before the BCP operation.
Mark
Post #817768
dgabele
dgabele
Posted Thursday, November 12, 2009 6:29 AM
SSCrazy
Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:56 AM
Points: 2,405,
Visits: 426
Nice question! I didn't know a connections such as MULTIFLATFILE existed. I typically did what was suggested in the second answer. Thanks!
Post #817774
Cliff Jones
Cliff Jones
Posted Thursday, November 12, 2009 8:31 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 2:05 PM
Points: 3,423,
Visits: 3,439
I agree, nice question. I learned something new today and that is the point.
Post #817884
AlexSQLForums
AlexSQLForums
Posted Thursday, November 12, 2009 8:42 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 2:41 PM
Points: 1,228,
Visits: 1,726
WOW i always used the for each loop to process files and never knew about multiflatfile feature.
Good one.
Thank you
Alex S
Post #817895
« Prev Topic
|
Next Topic »
20 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
