Viewing 15 posts - 9,361 through 9,375 (of 11,678 total)
Glad that you could solve your issue and thanks for posting the solution!
May 27, 2011 at 12:19 am
darth_vodka (5/26/2011)
use "localhost" in your connection🙂
Let's hope they do not work with named instances 😉
May 27, 2011 at 12:19 am
I think the most important thing to realize for your requirement is that if those 3 flat files have different structures, you must use 3 different data flows.
If they all...
May 27, 2011 at 12:17 am
Nice question, but just one small problem:
"In prefix compression, does the entire prefix stored in the header need to match the data to be used?"
--> requires the answer NO to...
May 27, 2011 at 12:06 am
What is the datatype exactly in the destination?
May 26, 2011 at 11:44 pm
Gianluca Sartori (5/26/2011)
5) No 401k free money
I don't know what this is. Can you explain?
You don't get free money??? :w00t: :hehe:
After all, be lucky you are not freelancing in Belgium,...
May 26, 2011 at 7:14 am
My personal preference is to make a package for each file.
That way everything is neatly modulare and seperated (especially the logging).
But as Elliot said: It depends 😀
May 26, 2011 at 6:18 am
Normally this isn't an issue with your drivers, but with the protection level of your package.
Can you check which setting it has? (It is a package property).
May 26, 2011 at 6:15 am
Are you using a stored procedure?
May 26, 2011 at 6:13 am
Another option is to point to the child packages location in the SSIS server folder (if you deployed them to the MSDB database).
If you have the same folder structure set-up...
May 26, 2011 at 6:11 am
ma-516002 (5/25/2011)
Actually none of the proposed answers is correct, since the question states "...and at 10:00am on 2011/05/01...". None of the answers has the year 2011 in them...:w00t:
That is true,...
May 26, 2011 at 12:06 am
Greg Charles (5/25/2011)
Elliott Whitlow (5/25/2011)
You might have to work a little "magic" to elevate the rights.
I've done this by creating a SQL Agent proxy for SSIS package execution and using...
May 25, 2011 at 1:32 pm
I've seen it once, but that was a TSQL puzzle on how to write a left outer join as a right outer join (or something like that).
So no, I haven't...
May 24, 2011 at 12:38 pm
Phil Parkin (5/24/2011)
Those people will be paid to help you - we are not.
You're not? Didn't you get the memo from Steve Jones? 😛 :hehe:
May 24, 2011 at 12:03 pm
Viewing 15 posts - 9,361 through 9,375 (of 11,678 total)