Viewing 10 posts - 5,101 through 5,111 (of 5,111 total)
happycat59 (10/7/2015)
Try updating the connection string to include "IMEX=1" - this should tell the OLEDB provider to treat all cells as text. FOr more info - see https://www.connectionstrings.com/excel/
Thanks Happy.
I...
October 8, 2015 at 2:00 am
Apparently SSIS, and my PC needed a restart. I shutdown at the end of the day last night, and booted up this morning, to find it quite happy to find...
July 9, 2015 at 7:26 am
Joie Andrew (7/8/2015)
Is the project running in 64-bit mode? For some reason I thought Excel support only worked in 32-bit mode.
32bit. i have a feeling that the error for running...
July 9, 2015 at 1:52 am
Mohamed IDTTALBE (7/8/2015)
hidid you check if a sheet is hidden on your excel file ?
None of them are hidden.
July 8, 2015 at 10:15 am
I got around this in the end, by setting the task to run in as an Agent Job. This isn't really the solution I wanted, as it's now on a...
June 4, 2015 at 3:32 am
What does the execution log tell you? It'll give both the taskthat the error occured on, and the error that was returned.
To view the log, expand the Integration Services Catalogs...
May 26, 2015 at 8:29 am
Eirikur Eiriksson (5/23/2015)
Quick question, are you using absolute or relative path?😎
I'm defining the full address, with the server name, and directors, rather than the shared directory name.
I'm already running SSMS...
May 26, 2015 at 1:54 am
Jack Corbett (5/22/2015)
May 22, 2015 at 8:41 am
There's not on Standard, no.
I execute a stored procedure prior to the RS Execution, which another one of the DBAs we have made, which is as follows:
Create Proc [dbo].[UpdateRSOutputFile_sp]...
May 20, 2015 at 9:58 am
That's great, thanks.
Having a further fiddle with your code, showed me that the literal string after the then is always returned as a varchar, regardless as to what the variable...
April 14, 2015 at 3:44 am
Viewing 10 posts - 5,101 through 5,111 (of 5,111 total)