Steps on creating, saving, and running Import packages within "SQL Server Import and Export Wizard" ?

techresearch7777777 1,796 Reputation points
2024-04-19T19:10:05.3766667+00:00

Hello, using via SQL Server Management Studio "SQL Server Import and Export Wizard" can anyone provide step by steps (perhaps with screenshots?) on how to save an Import package and then create a SQL Agent job in scheduling it please?

I've tried both methods saving the SSIS package that it creates target as "SQL Server" and also tried as "File System"... created the SQL Agent job and ran both versions and get quite a few different security errors job failed.

Am kind of confused.

Also if I want to delete/clean up these stored SSIS packages where do they get saved/stored and how to remove them?

Thanks in advance.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,748 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,126 Reputation points
    2024-04-22T03:04:28.0866667+00:00

    Hi @techresearch7777777,

    Is there any error message for us to narrow down the issue? You may view the job history to check the log.

    Also make sure that the account used to run the job has full access to your source and destination.

    I run the agent job with the SQL Server Import and Export Wizard package failed when test and then gave the proxy account permission solved the issue.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.