hi all
i using SSIS to import flat files and i need support
how can i import flat file from folder inculed many files and when finish start to next and next .....
if can i select from flat files to add condition
like Select * from.....where ......
thanks
Hosam Abd EL-Wahab wrote: hi all
i using SSIS to import flat files and i need support
how can i import flat file from folder inculed many files and when finish start to next and next .....
if can i select from flat files to add condition
like Select * from.....where ......
thanks
You can run a foreach loop in your control flow to loop over every file...
No, you can't do a select * from flatfile where.... However, you can chose which columns to import and then you can use conditional splits to enforce your logic.|||
but if i want to some rows from files , the file include all territorys but i need to import only some .
how can i condition befor import to import only territory i want
thanks
|||
Hosam Abd EL-Wahab wrote: but if i want to some rows from files , the file include all territorys but i need to import only some .
how can i condition befor import to import only territory i want
thanks
You can't. Not with a flat file source. Sorry.|||
You can Reading Values from a Text File Using FileSystemObject
you can use that so usefull
http://msdn2.microsoft.com/zh-cn/library/aa933459(SQL.80).aspx
|||Hosam Abd EL-Wahab wrote: You can Reading Values from a Text File Using FileSystemObject
you can use that so usefull
http://msdn2.microsoft.com/zh-cn/library/aa933459(SQL.80).aspx
Right, if you want to code your own script. And FYI, that link is for DTS, not SSIS.
I would argue that simply loading a flat file and using a conditional split in the data flow will be extremely fast, almost such that trying to code something to exclude records up front would not be warranted.sql
No comments:
Post a Comment