Hello,
This is from another issue I was dealing with, but Phil help fix this, but now I am running into a new issue, wondering if anyone has seen this before, where the SSIS package I deployed onto SSISDB, which is on a SQL Server 2017 Developer edition, the SSIS package loops all worksheets/tabs (total of 3 tabs each tab has 20k rows), and using the excel source on SSIS, imports into the SQL server table (3 tabs into 1 sql table), and it imports successfully, however it fails, and the error message is unclear why... if anyone has encountered this before?
I attached the log file I got when I have the SSIS package run, it creates a log of the execution process... hopefully anyone can shed some light on this, the weird thing is, its random, it will fail, and import the data fine, and sometimes it will succeed and import the data fine... I am also using a shared folder on another server that is on the same node on a VM, I pinged and no drop pings that I encountered... so far, and gave the folder full read/write access, again but its able to import the data, its weird that its erroring out on the SQL agent job.
any thoughts on this? again attached is the log file in txt.
thanks in advance
May 13, 2020 at 7:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
hello, so I never got the excel to work properly, however what I did instead was change from xlsx to csv, and it works consistently and fine. work around I guess, though cant use tabs but at least it works.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply