Viewing 15 posts - 9,736 through 9,750 (of 11,678 total)
Chris Howarth-536003 (3/18/2011)
"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value."
Serves me...
March 18, 2011 at 2:16 am
You'll probably need a script component to add a rownumber, so that you can use a conditional split to split the data.
March 18, 2011 at 1:30 am
The FROM field that does not necessarily have to be populated with an existing email address if I'm not mistaken.
You could fill in something like:
NoReply@mySSISPackage.myServer
(or something like that, it's been...
March 18, 2011 at 1:28 am
Why would you want to do it in SQL mode?
If you just select the table name in the destination database together with the fast load option, you can just map...
March 18, 2011 at 1:23 am
Craig Farrell (3/17/2011)
pschwartzbauer (3/17/2011)
Is there a graceful way to accomplish this using SSIS data flow transformations?
No. You'll want to pretty much do this at the T-SQL level and feed...
March 18, 2011 at 1:22 am
Can you give a little more information?
What are you trying to do?
How does the package look like?
What are the inputs and what are the desired outputs?
How did you configure the...
March 18, 2011 at 1:19 am
Split --> conditional split (what's in a name?)
Regarding the lookup, that's a bit more difficult. Does the value you need to lookup exist on the same row? If yes, you...
March 18, 2011 at 1:18 am
Did you give yourself administrative rights when installing SSRS?
If you go to Report Manager, can you upload a report from there?
March 18, 2011 at 1:15 am
ProKelly (3/17/2011)
detail : i've built a comprehensive 30 ish table structure...
March 18, 2011 at 1:13 am
Well, it has backward compatibility: you can upgrade 2005 packages to 2008.
SSIS 2005 doesn't have forward compatibility: you can't design 2008 packages using BIDS 2005.
Regarding your error: you can't connect...
March 18, 2011 at 1:09 am
Why can't you just create two dimensions based on the fact table that just uses the attributes you need?
A small question: why are your dimensions in your fact table? Are...
March 18, 2011 at 1:06 am
Great question.
I guess the CREATE statement will throw a bunch of people off, as it uses a reserved keyword and it has an extra comma.
Still valid though.
March 18, 2011 at 1:03 am
No problem, glad to help.
March 18, 2011 at 12:56 am
How did you configure this jobstep?
Did you use a configuration file? Is it possible to post some screenshots? (you can add attachments to your post to upload them to this...
March 18, 2011 at 12:48 am
Viewing 15 posts - 9,736 through 9,750 (of 11,678 total)