The new SSIS in SQL2005/SQL2008 are oversized
Posted
by Ice
on Super User
See other posts from Super User
or by Ice
Published on 2010-04-10T22:09:27Z
Indexed on
2010/04/10
22:13 UTC
Read the original article
Hit count: 252
sql-server-2008
|sql-server-2005
I studied the new MERGE Statement and there is a nice example for importing a flatfile.
INSERT <Table>
SELECT * FROM OPENROWSET BULK <Import-Flat-File>, <Format-File>...
seems to be a good replacment for such a simple job and avoids to build a SSIS-Package.
EXEC XP_CMDSHELL bcp <Table or View> out <Flat-File> ...
is almost simpler than building an SSIS, isn't it?
(I know that the MERGE-Statement doesn't run on a SQL2005)
© Super User or respective owner