Viewing 15 posts - 1 through 15 (of 18 total)
I can't thank you both enough! They work. @Ed B I just had to change it to 18 instead of 01 but that's exactly what I needed.
September 20, 2013 at 3:59 pm
Thank you both for your feedback. I'll try to explain it more clearly. @hisakimatama, Sorry, I forgot to mention one thing. I can ignore the dependents (records...
September 20, 2013 at 12:45 pm
Thank you Nevyn! That worked perfectly.
June 19, 2013 at 7:31 am
Yes, thank you again!
May 2, 2013 at 1:30 pm
Thank you all for your help! Sorry for the data issue.
April 30, 2013 at 3:55 pm
Nevermind, I had --acct_dt = prod_dt commented out in the statement, which runs in PL/SQL but not SSIS.
March 8, 2013 at 7:01 pm
Skur,
My solution was to log into SQL Server Management Studio, select Integration Services as the Server type then right click on the folder you want to import to. Right...
March 8, 2013 at 10:28 am
I'm not sure to be honest. I looked up something on my computer that says oracle.odac.server 11.2.0.3 if that means anything. :ermm:
I'm pretty sure I have to use the...
March 6, 2013 at 6:29 am
And thanks Lynn Pettis! Just saw your post.
March 4, 2013 at 1:54 pm
Thanks Evil Kraig F! Exactly what I needed.
March 4, 2013 at 1:53 pm
Nevermind, I fixed the problem. I didn't realize that changing the database name doesn't actually change the Database ID.
So I had to drop the SSAS db and deploy...
February 21, 2013 at 9:57 am
That makes sense, sorry for the lack of details. Thanks!
January 23, 2013 at 6:08 pm
I have an individual Master_DimUnitOfMeasure package that is called in the larger master package in the job that keeps failing on me.
When I run the Master_DimUnitOfMeasure from my computer in...
January 4, 2013 at 10:40 am
I just ran the package again, this time not as an admin, and received the following error:
"Source: Extract_DimUnitOfMeasure_TIPS... Description: Error 0x80070002 while preparing to load...
January 4, 2013 at 9:56 am
After I ran the ALTER and then the job, it no longer came up with the error:
"Source: Truncate RAW Table Execute SQL Task Description: Executing the...
January 4, 2013 at 9:27 am
Viewing 15 posts - 1 through 15 (of 18 total)