Viewing 15 posts - 11,881 through 11,895 (of 13,849 total)
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
da-zero (8/20/2010)
Raunak Jhawar (8/20/2010)
I'm loving it...:-D:-D:-DYou're just being sponsored by McDonalds 😛
Maybe that should be
U wordt enkel gesponsord door McDonalds
August 20, 2010 at 2:45 am
da-zero (8/19/2010)
river22_34 (8/19/2010)
Please provide me the complete solution.
Sorry if this sounds rude:
if you want the complete solution, hire a consultant.
Phil and I have given you enough hints so that you...
August 19, 2010 at 7:29 am
da-zero (8/19/2010)
http://www.google.com/search?source=ig&hl=nl&rlz=1G1GGLQ_NLBE331&q=ssis+ebook&aq=f&aqi=g1&aql=&oq=&gs_rfai=
Now who would have thought of doing that? 🙂 In Dutch too.
August 19, 2010 at 6:21 am
Maybe you should read about configuration files - they might give you the flexibility that you need.
August 19, 2010 at 6:03 am
Viewing 15 posts - 11,881 through 11,895 (of 13,849 total)