Import and Export Excel with SQL Server

Import and Export Excel with SQL Server

Greg Anderson

4 года назад

12,039 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@ayushisahu9926
@ayushisahu9926 - 02.09.2021 05:51

Thanks the vedio was so helpful but facing few error

Ответить
@ayushisahu9926
@ayushisahu9926 - 02.09.2021 05:46

Hi could you help me in this i am getting this error in last, at time of excecution(its failing) while importing excel--->

TITLE: SQL Server Import and Export Wizard
--------------------------------------------------------------------------------------------------------
Data flow execution failed.
Error 0xc0000033: {5CCE2348-8B9F-4FD0-9AFA-9EA6D19576A7}: Integration Services evaluation period has expired.
Error 0xc0000033: {5CCE2348-8B9F-4FD0-9AFA-9EA6D19576A7}: Integration Services evaluation period has expired.
------------------------------
ADDITIONAL INFORMATION: 
Integration Services evaluation period has expired.
 ({5CCE2348-8B9F-4FD0-9AFA-9EA6D19576A7})

-----------------------------------------------------------------------------------------------------------------------------------

In Addition I have tried running following query to change evaluation period expiry date--->
-- Run the following query to retrieve the installed and expiry date on an Evaluation edition of SQL Server 2012/4 instance.
SELECT
create_date AS 'SQL Server Install Date',
DATEADD(DD, 180, create_date) AS 'SQL Server Expiry Date'
FROM sys.server_principals
WHERE name = 'NT AUTHORITY\SYSTEM'

Ответить
@Arthur-dr5kk
@Arthur-dr5kk - 16.10.2020 14:13

my problem is at choosing excel version, i am runnining on office 2016, and sql server 2008r2, now i dont have office 2016 in my dropdown list

Ответить
@donaldoriwo5104
@donaldoriwo5104 - 28.09.2020 00:34

Nice video, how do you export a table with all its dependencies?

Ответить
@Oliver-cg5ud
@Oliver-cg5ud - 07.02.2020 15:18

No u

Ответить
@IOwnYouVC
@IOwnYouVC - 01.01.2020 00:21

Nice video can you make one that you can get it to work on another application?

Ответить