I can't create a SSIS package from SQL Server Import and Export Wizard.
I get to the very last screen "Run Package" and only have the option to "Run Immediately" . At the bottom of said window I get a paragraph stating:
In SQL Server Express, Web, or Workgroup, you can run the package that the Import and Export Wizard creates, but cannot save it. To save packages that the wizard creates, you must upgrade to SQL Server Standard, Enterprise, Developer or Evaluation.
I have several CSV files located on a client system that I want to load into a remote system hosting the SQL Server instance.
The Wizard is being run on the client system.
"Run Package " of the wizard DOES work and data loading is possible.
System permissions are such that the file system of client and host are invisible to each other. I would have
BULK INSERT'ed otherwise.
Microsoft SQL Server Management Studio 10.50.4000.0 Microsoft Data Access Components (MDAC) 6.1.7601.17514 Microsoft MSXML 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 9.11.9600.18665 Microsoft .NET Framework 2.0.50727.8669 Operating System 6.1.7601
[Microsoft SQL Server 2008 R2 (SP1) - 10.50.2811.0 (X64) Apr 6 2012 01:59:29 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)