Viewing 15 posts - 11,866 through 11,880 (of 13,838 total)
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
da-zero (8/20/2010)
Phil Parkin (8/20/2010)
da-zero (8/20/2010)
Raunak Jhawar (8/20/2010)
I'm loving it...:-D:-D:-DYou're just being sponsored by McDonalds 😛
---
(So much learning for a Friday...)
Yeah, you're right - that's me done for the day now...
August 20, 2010 at 3:06 am
Viewing 15 posts - 11,866 through 11,880 (of 13,838 total)