Viewing 15 posts - 9,046 through 9,060 (of 13,876 total)
Does the account executing the package have access (and permission) to the Excel file?
If it's on a local drive on the server, I would not expect it to be...
October 2, 2014 at 3:20 am
Vic Rauch-303403 (10/2/2014)
You need to get yourself a good contact in IT who has the power to work through this with you!
I agree with that 100% Problem is...
October 2, 2014 at 1:10 am
No problem and good luck. 'Remote' troubleshooting is never fun. You need to get yourself a good contact in IT who has the power to work through this with you!
October 2, 2014 at 12:53 am
Vic Rauch-303403 (10/1/2014)
October 2, 2014 at 12:38 am
Are you using two separate data flows to do the imports? (Rather than a fancy Foreach container.)
How are you setting the run-time values of things like file name and file...
October 1, 2014 at 1:13 pm
Is the spreadsheet located on a local drive on the server?
If not, can you try putting the spreadsheet there and seeing whether it works? If it does, this is likely...
October 1, 2014 at 12:29 pm
ishitvora1122 (9/30/2014)
I believe the CASE function with INSERT & UPDATE will still meet the OP's requirements..Cheers
From the initial post:
I have a Nullable columns. I want the value to be zero...
October 1, 2014 at 2:00 am
Most people on this forum speak English. If you can translate your question, you will probably get a better response.
September 30, 2014 at 8:12 am
Unless you are correcting data as it moves from Excel to Access, I cannot think of any reason why you could not use SSIS to import the data from Excel....
September 30, 2014 at 5:19 am
antonela (9/29/2014)
But I think that...
September 29, 2014 at 11:11 am
Koen Verbeeck (9/29/2014)
The YEAR function (and MONTH and DAY) only work on date data types, not on strings.You'll get these errors when your input column is a string data type.
They...
September 29, 2014 at 3:56 am
If your input data is in a string, you cannot use date functions on it.
Use substring to extract the parts of the string you are interested in and do...
September 29, 2014 at 3:55 am
ronan.healy (9/29/2014)
21/03/2018
I keep getting an error. do I have to convert it I tried the following code to try and convert it but...
September 29, 2014 at 3:34 am
antonela (9/26/2014)
September 26, 2014 at 8:22 am
Not relevant to your question, but I would also be interested to know why you are using a global temp table (##) rather than a local one (#)?
September 26, 2014 at 7:15 am
Viewing 15 posts - 9,046 through 9,060 (of 13,876 total)