I know this video is years old but mate, thank you. I have been fighting with SSIS for a while now and this has put the finishing touches to my project!
I was asked to implement this same type of package scenario practically in an interview... i applied for mid level role as BI developer...I have junior level experience in ssis..could not able to do it..was unsuccessful in interview...after seeing this video , I feel so dumb now...:( ...its that easy...I will have to practice all your video from now on!Thanks a lot for making the videos...
Really nice job--on all of your videos! You are a shining light in a sea of SSIS darkness. I found #28 and #29 very helpful. Never would have figured this out by reading books about SSIS or trying this on my own. Keep up the great work!
i have given some tasks in company and i learned a lot from this playlist thank you for posting this. need to learn azure data factory please make a video on it.
Best example for me! And if I have an input flat file for feeding more than one Sql table? What I have to do? (like a Masterdata file populating n tables)
Hi , This is good lesson. How to archive if we want to select in sql script multiple value like select * from table where column_name in ('a','b','c') remaining same condition.Thanks.
+Biswanath Das Hi Biswanth Das, Thanks for liking the video. Instead of using the select * From dbo.TableName, you can use the query you have provided. It should work just fine. I created a video demo on same topic by using script task, This might be helpful. www.techbrothersit.com/2016/04/how-to-export-data-to-multiple-flat.html
This works great! However, I've run into a gnarly problem which occurs when the data item fed to SQL as a parameter contains special characters. I am using Project Name as the parameter--and I have hundreds of Project Names that contain special characters (e.g. "/" and "&"). Do you know a way around this issue?
OK, please disregard. I found a complex solution--then a simple one. The complex solution involved a T-SQL function to strip out the special characters. The simple solution was to simply use another field in the WHERE clause. (I used "Project Number" instead of "Project Name"--the field which had the problematic characters.)
i have to deploy the packages under SSIS catalog sql client 2012. it accept only project level deployment. does not accept the package level in this situation how can i use for each loop container in my package because the file path variable i can not choose the parameter level variable .. it accept only local variable.. but local variable will not accepted by project deployment.. could you please help me
Hi Seth, Yes it is possible. I have many scenarios to create files dynamically for set of columns. Check the tutorial list www.techbrothersit.com/search/label/SSIS%20Video%20Tutorial
+Karthik D , In case of Excel you can't really create file on fly as we did for Flat file. Here is video link th-cam.com/video/zwUhHIpRoIA/w-d-xo.html , you create template file in advance and then copy each time as empty before loading the data.You will see I have renamed the file while moving to destination folder before loading the data. Good luck!
I know this video is years old but mate, thank you. I have been fighting with SSIS for a while now and this has put the finishing touches to my project!
Glad it helped
I was asked to implement this same type of package scenario practically in an interview... i applied for mid level role as BI developer...I have junior level experience in ssis..could not able to do it..was unsuccessful in interview...after seeing this video , I feel so dumb now...:( ...its that easy...I will have to practice all your video from now on!Thanks a lot for making the videos...
Really nice job--on all of your videos! You are a shining light in a sea of SSIS darkness. I found #28 and #29 very helpful. Never would have figured this out by reading books about SSIS or trying this on my own. Keep up the great work!
i have given some tasks in company and i learned a lot from this playlist thank you for posting this. need to learn azure data factory please make a video on it.
Thank god! This is just the video I needed to learn how to get my package working for flat file outputs with a Foreach loop container, thank you!!
Excellent example. It was just what I needed. Many thanks from Argentina
Muito obrigado por terem criado esses videos, por reservar o tempo e ajudar pessoas.
Best example for me! And if I have an input flat file for feeding more than one Sql table? What I have to do? (like a Masterdata file populating n tables)
Hi , This is good lesson. How to archive if we want to select in sql script multiple value like select * from table where column_name in ('a','b','c') remaining same condition.Thanks.
+Biswanath Das Hi Biswanth Das, Thanks for liking the video. Instead of using the select * From dbo.TableName, you can use the query you have provided. It should work just fine.
I created a video demo on same topic by using script task, This might be helpful.
www.techbrothersit.com/2016/04/how-to-export-data-to-multiple-flat.html
This works great! However, I've run into a gnarly problem which occurs when the data item fed to SQL as a parameter contains special characters. I am using Project Name as the parameter--and I have hundreds of Project Names that contain special characters (e.g. "/" and "&"). Do you know a way around this issue?
OK, please disregard. I found a complex solution--then a simple one. The complex solution involved a T-SQL function to strip out the special characters. The simple solution was to simply use another field in the WHERE clause. (I used "Project Number" instead of "Project Name"--the field which had the problematic characters.)
What if you want to loop through the RegionCD but wanted to display the RegionName in the file name?
i have to deploy the packages under SSIS catalog sql client 2012. it accept only project level deployment. does not accept the package level in this situation how can i use for each loop container in my package because the file path variable i can not choose the parameter level variable .. it accept only local variable.. but local variable will not accepted by project deployment.. could you please help me
The error circa 9:30 might have been because started to specify one of the columns phonenumber in brackets but might not have closed the bracket.
That is correct. One of the closing brackets got accidentally deleted while copypasting which caused the issue momentarily.
Is there a way to create the files with only some of the columns?
Hi Seth, Yes it is possible. I have many scenarios to create files dynamically for set of columns. Check the tutorial list
www.techbrothersit.com/search/label/SSIS%20Video%20Tutorial
hi, how do I achieve the same if I have to export to multiple excel files??
+Karthik D , In case of Excel you can't really create file on fly as we did for Flat file. Here is video link th-cam.com/video/zwUhHIpRoIA/w-d-xo.html , you create template file in advance and then copy each time as empty before loading the data.You will see I have renamed the file while moving to destination folder before loading the data. Good luck!
+TechBrothersIT , Thanks Bro. It worked :):)