55 XML Configuration in SSIS

[@mohiuddinansari9356]

Worth spending time here, to the point and accurate. Thanks

[@learnssis]

Thank you Sir.

[@dharamrajput5884]

Hello Aqil Ahmed Sir, Thank you so much for whole SSIS tutorial series. This is really helping me alot. Every time I watch the same video or different I learn new things out of it.

[@learnssis]

Good to know that you liked the videos. Thank you.

[@Teja0709]

So I have a question I have configured dts config file with connection string and package 1 variables. Now I have 3 ssis packages where they use same connection string. Can I use same dtsconfig file for all the 3 packages or change them as the variables defined in dtsconfig used by package1 is not defined in other 2 packages but have same connection string. Whats your go on this?

[@learnssis]

Every ssis package should have its own dts config file. I have used dts config file very rarely, just for the demos. Normally I use Project deployment method as same project parameter can be used across all ssis packages.

[@shobhitsaxena4055]

Thank you so much for your outstanding content. I found it truly helpful.

[@learnssis]

Good to know that it helped you. Thanks.

[@nomadickeshav4760]

Hi, Aqil i m unable to deploy the package in sql server After cliclikg on deploying option i m facing this issue TITLE: SQL Server Integration Services ------------------------------ An Integration Services catalog (SSISDB) was not found on this server instance ("LAPTOP-9ELQVVUN\SQLEVAULUATION"). To deploy a project to this server, you must create the SSISDB catalog. Open the Create Catalog dialog box from the Integration Services Catalogs node. plase help me with this i m facing this issue since so long.

[@learnssis]

If you look at this video specially from 5:37 then I have shown how to create ssis db catalog. kzbin.info/www/bejne/n17TqJiLp7uLj9k

[@abdelbakizebiri3177]

Thank you so much helped me a lot. could you make another video doing the same thing with SQL Server and fixing the following problem : "could not leave the wizard page". thank you

[@learnssis]

Here is the video on sql server configuration. kzbin.info/www/bejne/npTSkId8jN-Xerc

[@venkatasureshkakumani8285]

Good explanation I have one doubt ..If I have two xml config file ..I want to use first one or second one ..when I can specify this in package properties

[@learnssis]

I don't think you can use 2 xml configuration file in an ssis package. If you right click on the control flow, and go to package configurations, and select xml configuration as shown in the video, in the end you can find the path of the xml configuration file.

[@kranthika]

Sir We have 30 rows in testData1, Y testData2 file loading only 20 records?

[@learnssis]

Sorry I don't know what is testData1 and testData2.

[@kranthika]

@@learnssis the file name(testData_1 ) u changes in Path

[@gauravpratap4482]

can we please have a video for configuration in SSIS where Configuration Type = SQL Server and configuration location stored in environmental variable

[@learnssis]

Hi Gaurav, I have a video on SQL server configuration, but the value is not stored in an environment variable. Maybe in future, I can think of making any such video. kzbin.info/www/bejne/npTSkId8jN-Xerc

[@vamsi8669]

Thank you, You saved my Day

[@learnssis]

Very nice to hear that it helped you.

[@palaparthisobha1214]

For this, While creating a connection manager, what is the property we should associate the variable with? I mean Connection string or name?

[@learnssis]

You can use connection string property. Thanks.

[@okeyokafor648]

This was a great video. Thanks.

[@learnssis]

Good to know that you liked the video. Thanks.

[@v3ridersiva]

for me it is not showing package Configuration option in my system

[@learnssis]

Change the Project deployment model to Package deployment model and then you should be able to see the XML configuration options. Thanks.

[@baddulahariprasad]

Hello Aqil, Thanks for the vedio. Can you show us how to configure SQL server specific port in XML configuration of SSIS

[@saikiranp.r6966]

Hello. Great video, thanks for that. I have a question, what if I have a For each loop and I have to configure it

[@learnssis]

Thanks for your comment. What kind of information you want to pass to For each loop container. For example if you want to pass DirectoryPath, then you can create an SSIS String Variable and assign DirectoryPath to it, and then during XML configuration you can pass a different value to DirectoryPath String variable. Thanks.

[@saikiranp.r6966]

@@learnssis Thank you very much . I would try and let you know about it 😃

[@haatpraat2993]

I have followed this video several times and could not get my example to work. Will try another one. ..... Found out to get this example to work there is no need to set up a seperate variable. Just go into the configuration select the connection manager and its associated property, ConnectionString. Save. Then whenever you want to change the source of the file, simply edit the Configuration file XML and change from say file1 to file2. The FilePath variable on this video is irrelevant.

[@Gudsan]

Dear Respected sir please tell that how to export xml data from sql server to excel sheet please sir help me sir i am trying to in SSIS Getting xml Data From SQL Table To Excel Files you can refer SELECT [AdditionalContactInfo],[Demographics] FROM [AdventureWorks2019].[Person].[Person] these two columns are not comming in excel

[@learnssis]

Hi, I spend some time on it but you are correct, there are some issues while exporting the data to excel if the source type is text text or XML. Frankly speaking writing to excel is always been a pain, that's why most of the times we prefer to write to CSV. For large data set we always write to text files, as excel does not handle very large data sets. Sorry I did not find the solution for this problem.

[@Gudsan]

@@learnssis आदरणीय सर आपने हमारे लिए इतनी मेहनत की यह हमारे लिए काफी है बहुत-बहुत धन्यवाद आपका l सर जी यदि फ्यूचर में इसका जवाब आपको मिले तो प्लीज हमको इन्फॉर्म कर देना

[@learnssis]

@@Gudsan Sure Saneep.

[@kunchamchakri]

i did not get understanding , can you explain this again in a easy way

[@learnssis]

This was a old way of deploying ssis package which is not used these days, I would recommend on project deployment method now which is shown in this video kzbin.info/www/bejne/jJPbloBngJ1_d7c

[@anilkumarraju8839]

Can you please tell me the exam code: for SSIS, SSRS please sir i am confusing with this please help me sir

[@learnssis]

Sorry Anil, I am not sure about the exam code as well.

[@akhilkumar2832]

Good video, Thanks

[@learnssis]

Glad you liked the video.

[@BiniComTraining]

please help me

[@viswanathp6305]

background music is good

[@learnssis]

ha ha. Yeah TV was on at that time.

[@BiniComTraining]

Create a package Load_Prospects_Master.dtsx that will call all the three packages in the correct order. Configure package Load_Prospects_Staging.dtsx to read values from XML configuration file during execution. Configure package Load_Prospects_Dictionaries.dtsx and Load_Prospects.dtsx to read values from SQL Server during execution Create a SQL Server Agent job to schedule your package to run once daily

[@learnssis]

I have created video on each topic mentioned by you, you would need to test each package separately, you can find video on each part of this package.

[@mohammedmashaquddin9456]

Shiiwv esyioeie. Jusuus guusuiie