Forum Discussion

Copper Contributor

Nov 02, 2022

SQL SSIS Package Scheduling

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 successful...

olafhelper

Bronze Contributor

Nov 02, 2022

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

kulkarnipriya8792
Copper Contributor
Nov 03, 2022
olafhelper

Thanks a lot.
Issue resolved.

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