12 SSIS interview questions and answers

[@deepakj6717]

Keep posting. Learning so much from your channel. Thanks.

[@learnssis]

Thank you for your support.

[@Shubhamkumar-ir5ox]

Thanks for your videos. I have recently asked one question like - "Suppose there is a very large table with millions of record and we want to filter the data on any condition (ex: city wise ). We want data to be in relevant table(For ex. city- delhi data should be in delhi Table). Our data has wide variety of such distinct city. What will be the effective way to split the data in different table in an optimized way."

[@learnssis]

We can do this using a foreach loop container with ADO enumerator. In the execute sql task we can select distinct city from the large table, and then in the foreach loop container we can configure it for ado enumerator and can create 2 ssis variables, one variable of object type and second variable CityName of String type, now in the foreach loop iteration CityName variable will hold the value of one city at a time. Now we can use a data flow task and in the data flow task we can take an OLE DB source and we can write a select query there like select * from largetable where city = ? and we can map the CityName SSIS variable there, now we can take an OLE DB Destination and we can use TableorViewName variable fast option in the OLE DB destination and can map the columns, this way we can easily insert data from one large table to different tables for each city.

[@Shubhamkumar-ir5ox]

@@learnssis Thank you very much for the detailed explanation

[@dailytenminutes3588]

hi bro i have an issue to select nth row as header of excel as source and destination is ole db sql server in ssis

[@learnssis]

Sorry I did not get your question, Do you want to import the data from excel into sql server ? And it should start importing from nth row ?

[@dailytenminutes3588]

hi bro i have an issue to select nth row as header of excel as source in ssis ole db is destination

[@dailytenminutes3588]

@@learnssis bro I am having DFT in ssis to export data into ole db. in that Excel is source i have header column in 12th row how can I select that and export into sql Server.

[@learnssis]

​@@dailytenminutes3588 Yeah you won't be able to do this using Excel source, you would need to write the code in C# to select the nth row. May be write the code in C# console app and test it there and once that works for you, move the code to the script task in SSIS.

[@dailytenminutes3588]

@@learnssis can you we connect via mail or whatsapp or telegram I don't know about c#