Viewing 7 posts - 2,686 through 2,693 (of 2,693 total)
mylenechalut (4/16/2016)
Unfortunatly, I work for the federal government. We cannot use whatever software of version we want here 🙁
That does not invalidate the fact that you should use it...
April 16, 2016 at 10:21 am
First off you should look into using the Microsoft ACE (Microsoft Access Database Engine 2010 (or 2013) Redistributable) for reading the excel files as it does allow for a...
April 15, 2016 at 2:30 am
are you executing the package on the file system or on Sql Server? and if on Sql Server are you setting it to run asynchronously or synchronously?
if running asynchronously...
April 14, 2016 at 6:27 pm
In my opinion it all depends on how big your SSIS process is going to be and if the existing servers have a window where the SSIS jobs can run...
April 14, 2016 at 6:16 pm
These would be my toasters
Agent Ransack - searching for files is a must.
Vim ... (unix guy here so a must)
7zip
October 24, 2014 at 2:21 am
works only partially - does not take in consideration that fact that some countries do have Accented alphas so the code as is removes them.
Select dbo.fnTrimNonAlphaCharacters('âáÉéôô') will just return an...
July 11, 2014 at 5:30 am
nice post.
I have just one question which may help others also.
Does the fact that you are referencing the Excel object on SSIS require a Excel install on the server?
October 28, 2010 at 2:20 am
Viewing 7 posts - 2,686 through 2,693 (of 2,693 total)