Interview Question in SQL Server Integration Services
Interview Question :: SQL Server 2005 SSIS capabilities
I have never really worked with SSIS but I have a situation and I am wondering if a SSIS project could take care of it for me. SAP is going to be dumping flat text files (not IDOCS) into a folder, I want to grab those files, parse out the data that I need, and store the data into the SQL Server 2005 DB. Is it possible to write a program that can do this using SSIS. A SSIS project that will grab files every X seconds, parse that data, then run SP's to insert the SAP data into the correct SQL tables in my database? I know I can write a C# application to do this but I was wondering if this can be accomplished through SSIS?
Loading ...