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?
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.
@@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?
@@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.
@@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?
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?
Up
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.
@@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?
@@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.
@@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?