Forum Discussion

kulkarnipriya8792's avatar
kulkarnipriya8792
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 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.

Resources