February 19, 2009 at 2:08 pm
So I have a task that requires us to pull an excel file from a third party ftp site maintained by one of our clients and then upload it into my DB. I’d like to be able to do this all with SSIS, but the issue is, we have security concerns that the excel files could potentially have malicious code in them. So what exactly happens when SSIS reads an excel file? Could any macros in it fire upon opening and cause issues?
I’m going to request that the file be converted to a csv so I don’t think I’ll have any issues there, I’m just wondering if opening unknown excel files with SSIS is a good idea…
February 20, 2009 at 1:04 pm
Hi,
I remember working with Excel files with macros in SQL Server 2000, I didnot had any issue loading this file to SQL. But I used Activex script for loading. I have not tried with SQL Server 2005. Your Idea of getting files in CSV would be better, because CSV file has no limitation and you can be sure there wont be any Macros in it 😉
Raj
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply