SQL SSIS Package Scheduling

Copper Contributor

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.

2 Replies

@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




Thanks a lot.
Issue resolved.

An issue found in SSIS execution while writing Drop and Create query.