Viewing 15 posts - 11,896 through 11,910 (of 13,876 total)
Great - and the answer to the first question?
August 30, 2010 at 8:20 am
Please excuse the obvious question, but is there a worksheet called Sheet1 in the workbook being accessed?
What version of Excel are you using?
Are you working in a 32- or 64-bit...
August 30, 2010 at 8:01 am
Please post the full text of the error message.
August 30, 2010 at 7:50 am
What problems are you having?
Is the format of all the worksheets the same (column order, datatype etc)?
August 30, 2010 at 7:39 am
An easy way round this to set a package variable within your script task and then use precedence constraints to direct the flow afterwards based on the contents of the...
August 30, 2010 at 4:46 am
That sounds overly complex to me. If a package is scheduled to run every x minutes, can't it just calculate the time between the last log entry and 'now' and,...
August 27, 2010 at 1:16 pm
I was thinking along similar lines, but with a different slant: automate Excel to output the data to CSV and then use that CSV as the SSIS data source.
August 27, 2010 at 9:14 am
OK, maybe I understand your problem. You want to know how to get just the time bit into a datetime variable?
You can't do that, but you could put a dummy...
August 25, 2010 at 9:22 am
SQL trance files eh? Whatever would Freud say? 🙂
See my reply post to another thread of yours regarding time comparisons - no trouble really.
August 25, 2010 at 8:43 am
It's a puzzle that would probably be sorted out within five minutes if an experienced SSIS user had direct access to the package. I have nothing specific to add that...
August 25, 2010 at 7:31 am
Raunak Jhawar (8/25/2010)
Alvin,If the package is just reading the a single file then definately the remaining files must be in a folder structure.
The original post contains the following:
I Configured a...
August 25, 2010 at 7:21 am
Ball-and-socket works for me every time.
Oh hang on, I'm wrong, that's a joint. Which is what you lot have been smoking, by the looks of things 🙂
August 25, 2010 at 6:14 am
Interesting thread guys, thanks for all the info.
August 25, 2010 at 5:14 am
AndrewSQLDBA (8/24/2010)
What about instead of the file timestamp of a date and time, I want to use only the time. Is there a way to strip off the date and...
August 25, 2010 at 12:57 am
AndrewSQLDBA (8/24/2010)
The file names change daily.
I want to copy only the files that are created between a certain time of day. Say between 1:30 PM and 2:00 PM
No...
August 25, 2010 at 12:33 am
Viewing 15 posts - 11,896 through 11,910 (of 13,876 total)