I really appreciate your work. Yours videos have been very helpful to me. I had one query though, I want to dynamically map my source table and destination table if the after creating the package which is taking my ouput query from sql config table and loading it into destination, i change my query again in config query with less columns or more columns now. So i want to dynamically map them with my destination table which is also sql as well. Can you plse help me with it.
can we use foreach loop plus excel sources dynamically load excel sheet one by one to replace to use script task if we can't write C# for new situation ?
Hi i have one dought in excel i have data in one column like this " 123-abc-12-12" something like this while i am extracting to sql server it is taking as null values Please help me how to load same data to sql server from destination
Hi. This is really amazing content and thank you so much for the same. Although, I am getting "Compilation errors" while executing the code even after going through with it thrice. Please assist with any idea on how to resolve it.
When closing the Script Task Editor: "Script Error: Scripts contained in the package have compilation errors. Do you want to save changes?" is what comes.
Hi, Check the excel part on this link. I have created many scenarios and you will find yours too www.techbrothersit.com/search/label/SSIS%20Video%20Tutorial