Nov 01 2022 11:28 PM
Please help....
1.I have imported Excel file into SQL.
2.After importing, I can see all the data into SQL.
3.I have created SSIS Package for that excel file. It executed all the rows successfully.
4.Deploy the SSIS Package into SQL.
5.I have schedule a job in SQL. In that Step, I have inserted a path of that SSIS Package and schedule daily for a specific time.
The problem is after scheduling successful job, I cant see my data even after executing select query. Only Column name displays.
Nov 02 2022 07:20 AM
@kulkarnipriya8792 , Setup logging for the package to analyze after execution, what happened and where the execution may hangs.
Integration Services (SSIS) Logging - SQL Server Integration Services (SSIS) | Microsoft Learn
Olaf
Nov 02 2022 11:14 PM
@olafhelper
Thanks a lot.
Issue resolved.
An issue found in SSIS execution while writing Drop and Create query.