I have a number of flat files(say 1000) at a shared folder. I want to read the file and insert a line of file into row of table. also I want the above thing to done at a particular time. I would like to know whether SSIS does supports this kind of requirement? Thanks, Bharathi

I want the above thing to done at a particular time That can be done by scheduling the package(s) with for example SQL Server Agent or by creating a batch file and use Windows Scheduling. What do you mean by "I want to read the file and insert a line of file into row of table."? If all file have the same format, you can use the foreach loop to process all filesPlease mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

you can use a data flow task with flat file source pointing to one of files, and oledb destination pointing to destination db table. then you can put this data flow task inside a foreach loop container with file enumerator to loops through files and do data flow for each file. and in last step you can deploy the package, and schedule it as a sql server job. this was whole schema and lots of details exists here, if you need more detailed solution , provide more detailed information of what you trying to do exactly, for example; are destination database table same or different ? are all flat files same or with different structure?...?http://www.rad.pasfu.com

I have a number of flat files(say 1000) at a shared folder. I want to read the file and insert a line of file into row of table. also I want the above thing to done at a particular time. I would like to know whether SSIS does supports this kind of requirement? Thanks, Bharathi

Yea this can be achived through SSIS, The easiest way is to use Management Studio, right click on the database you want to import into, under Tasks, select Import data. This kicks off a wizard which is quite straight forward. At the end of the wizard, you have the option to save the package to the server or to a file. If you save it to a file, you can then create a job and set the step type to be Sql Server Integration Services Package. You can then configure the parts of your package and schedule the job as normal. -Please mark it as answer if you are satisfied with the resolution.Thanks, Deepesh

Please check the following link this may be helpful too: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/730ceb63-6fb8-4bc8-970a-d4f3daf3a0e7/ http://sqlserverdownanddirty.blogspot.com/2011/04/including-current-date-in-flat-file.htmlThanks, Deepesh

Destination database table is same. Flat file structure is different(3 types). The only difference in structure: space delimited Type1 1000 abcd alpha Type2 1239344444444 Type3 1239344423433 Also, there can be thousands of files with varying size.(can sql server job can handle these requirement?) What is "I want to read the file and insert a line of file into row of table."? Destination Table contains one only column for data. for ex. if the flat file contains data like below: 1000230220202 1239344444444 it should be inserted into table Table: Primarykey Foriegnkey Record_column 1 345 1000230220202 2 345 1239344444444 Thanks, Bharathi

DOUBLE POST? http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/979be648-60d7-40cd-b680-956f7e8ba866/#979be648-60d7-40cd-b680-956f7e8ba866 Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Can a moderator of this forum please merge this thread into http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/24009326-f2fa-43a8-95ad-43ab18a71319. Or move the thread into the Integration Services forum where I can perform the merge. Thx. Talk to me now on