08 Hindi | Export data from SQL to CSV File using ssis

Export data from SQL to CSV File using ssis
Download the file\script used in the Video from below link
drive.google.com/drive/folder...
02 Hindi how to import a csv file into sql server using ssis: • 02 Hindi | how to impo...
Export data from SQL to CSV File using ssis
How do I export data from SQL query to CSV?
How do I automatically export data from SQL Server to CSV?
How to create a CSV file in SSIS?
How to Export Data From SQL Server to Flat File in SSIS?
Export SQL Server data into a CSV file with SSIS
Happy Learning.
If you have any questions or suggestions please comment on the video or write to me at “[e-mail]”

[@izenish]

Great tutorials,
I am currently facing an issue with a SSIS package where the scenario is I have some fields assume column_x and column_y
they hold data like 00123 and 9999..999 respectively
they are then exported into a CSV file which is then exported to clients where they do some changes and send the csv file back with their updates
the issue that arrises is whenever the client opens the csv file in excel it automatically converts 00123 →123 and 9999..999->1E+136 and while we reingest the file the 1E+136 isn't accepted as well as the 00123 wont be the same how can i solve this?

[@PedroHenrique-id4bk]

Up

[@learnssis]

Yeah this is the known issue with excel that it always tries to do the formatting of data according to data stored in the file. Unfortunately at the moment I am not sure what might be solution to fix this kind of issue.

[@izenish]

@@learnssis thanks for the insight, also is there anyway to execute a deployed ssis package from a different package. The EXECUTE PACKAGE TASK cant find the deployed project? How can it be resolved?

[@learnssis]

@@izenish You can execute a deployed package from sql agent job.
Right click on deployed package, Select execute, then click on the Script option, it will generate the sql query to execute the ssis package. So you can execute the ssis package from sql query and you can also put the same sql query inside the execute sql task.

[@izenish]

@@learnssis after copying that script we insert it into a different package where we want it to run? And what if the deployed parameters need to take inputs and the package calling it needs to pass value to the deployed variable?