flat file help
-
our client will give flat file with file extension like .ks , .ca , .ny,.la in a Zip folder.
the filename will be like tt20080904.ks,tt20080904.ca,tt20080904.ny,tt20080904.la
I have to develop a ssis package in a such way that do import for .ks in KS table ,.ca in a CA table and same for all....
how to achieve this?
-
use zipstream to unzip in a scrip task then I would use for each loop and enumerate with a file wildcard like tt*.*
Use a varaible where i put the ?? so you don't have to hard code the directory.
-
but how .ks file will go in KS table?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply