Viewing 15 posts - 11,896 through 11,910 (of 13,870 total)
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
AndrewSQLDBA (8/24/2010)
Thank you Phil-- and after walking away from this yesterday and looking at it this morning, I was able to figure it out.
--
That happens to me all the time....
August 24, 2010 at 9:52 am
You don't need 'between' when you've got C#! Nor in SQL Server, to be honest - it's just a short cut that can be achieved through other means.
In pseudo-code:
(time >=...
August 24, 2010 at 9:36 am
Why not just use the Row Count transformation?
August 24, 2010 at 2:38 am
Use an Execute SQL task. The results of the task (eg a single value) can be mapped directly to a variable (I don't have SSIS running at the moment, so...
August 23, 2010 at 12:04 pm
The way I would do this is to physically store something within a database which the package will use when it runs. Your first step when the package runs is...
August 23, 2010 at 11:45 am
What component/expression is causing the error and what is the exact error?
August 23, 2010 at 7:18 am
Viewing 15 posts - 11,896 through 11,910 (of 13,870 total)