Running SSIS package in a database scheduler

Copy excel file/ csv file into the table daily repetitiously.

Below is the guide to set the SSIS and use the generate package file in the job scheduler in MSSQL.

SSIS Setup

  •  Tasks -> Import data

s1

  • client ‘Next’

s2

  • select ‘Flat file source’

s3

  • Select the file, change text qualifier to ‘ ” ‘, uncheck the check box if first row is data

s4

  • click ‘Next’

s5

  • Specify the database server name, type of authentication and database name

s6

  • assign the destination table where data copy into. Click ‘Edit Mapping’ to set the mapping column

s7.png

  • map the column in csv with the column in the table

s8

  • check and click ‘Next’

s12

  • Only Enterprise version allow to save package (Express version cannot). check the Save SSIS package.

s9

  • click ‘Next’

s10

  • specify the package name and click ‘Next’

s11

  • click ‘Finish’

s13

Database Job Scheduler

  • Create a new job under SQL Server Agent

s14

  • Set the step to execute the package

s15

  • set the package file to be executed

s16

  • set the scheduler time

s17

Job done!! you can test it before leave it for everyday process.

One thought on “Running SSIS package in a database scheduler

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s