Exports other than bcp/Data Flow tasks

Question

Exports other than bcp/Data Flow tasks

jbm6401

Mr or Mrs. 500

Points: 513
More actions
August 8, 2013 at 6:31 am

#278458

I'm looking for other file transfers than bcp queryout and Data Flow tasks in SSIS packages. Are there other programmatical processes that are upgradable? I hear that bcp is not quite reliable, but it works for us and it will take too long to create 114 individual data flow tasks in an SSIS package. Thanks.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

jbm6401 Mr or Mrs. 500 Points: 513 More actions · Answer 1

To add more to this. I heard that the bcp is kluged. It works fast, but it is ancient technology. So I was wondering if there was something else that, when SQL Server upgrades and abandons the bcp feature, works well.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

You could try to create SSIS packages dynamically (for example with BIML), so that shortens the development time.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

jbm6401 Mr or Mrs. 500 Points: 513 More actions · Answer 3

Unfortunately, we only have 2008. I see the Stairway series for BIMS in 2012. Unless you can do something similar in 2008 that I do not know exists. Thanks for the reply.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

BIML also exists for 2008. It's included in BIDSHelper.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

jbm6401 Mr or Mrs. 500 Points: 513 More actions · Answer 5

Cool. I thought by looking at the Stairway series that this feature was added only to 2012.

jbm6401 Mr or Mrs. 500 Points: 513 More actions · Answer 6

Are there any examples out there that can export data from a query into a text file using BIML? I am searching the interweb and cannot find any specifics right now. Thanks.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 7

jbm6401 (8/8/2013)
Are there any examples out there that can export data from a query into a text file using BIML? I am searching the interweb and cannot find any specifics right now. Thanks.

I think this one can be very useful:

BIML Export to FlatFile

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP