Viewing 15 posts - 61 through 75 (of 128 total)
Sandy,
Jeff point is important, my workstation has Office 2003 and 2010 installed, so the ACE driver was available, you may need to download the driver from Microsoft if you don't...
Hope this helps,
Rock from VbCity
June 18, 2012 at 10:56 pm
Hi Sandy,
Sorry for the late answer, there is a time difference, I was able to duplicate the error message you received
Error: 0xC0202009 at DFT Derived Column, Excel Source [1]: SSIS...
Hope this helps,
Rock from VbCity
June 18, 2012 at 8:14 pm
Ok, let's suggest some debugging:
a. Your Excel file location is a package's parameter; Does it have spaces? All my tests involved file names without 'spaces' and I always avoid them.
b....
Hope this helps,
Rock from VbCity
June 18, 2012 at 9:08 am
Hi Sandy
You may try the following approach; create a package level variable, its name could be User::FileName; this is the variable that will contain your dynamic excel file, you may...
Hope this helps,
Rock from VbCity
June 16, 2012 at 8:22 am
Hi Swathu9
These steps should help you to handle the invalid date field in your flat file; you need to add two components after your flat file source loading the text...
Hope this helps,
Rock from VbCity
June 16, 2012 at 5:41 am
cafescott (6/15/2012)
I didn't see it; but there was another variable named "Package_ID" in my list. I removed...
Hope this helps,
Rock from VbCity
June 15, 2012 at 8:07 am
Hi CafeScott,
Did you check my previous post?, it seems you are having a variable scope issue, the behavior described sounds like you created the variable User::PackageID twice, the first time...
Hope this helps,
Rock from VbCity
June 15, 2012 at 8:02 am
Well, I tried with a package level integer variable with a default 123 value, it worked, in both: the first script task and on the second ST inside a sequence...
Hope this helps,
Rock from VbCity
June 15, 2012 at 7:51 am
Hi CafeScott
I did a quick test using Visual Basic (I work with C#), so it was very simple, I created 3 package level variables, User::TestVariable; User::WriteVariable and User::PackageID; assigned the...
Hope this helps,
Rock from VbCity
June 14, 2012 at 4:53 pm
The SSIS Problem Design Solution is a great book, I set its framework as a Visual Studio template, and it is a great idea to have one.
Based on the issues...
Hope this helps,
Rock from VbCity
June 13, 2012 at 5:47 pm
My approach was similar to the one described by Tim, here is a summay:
A control table tracking monthly records count for the most critical tables in the environment; this table...
Hope this helps,
Rock from VbCity
June 13, 2012 at 12:59 am
the missing image.
Hope this helps,
Rock from VbCity
June 12, 2012 at 6:22 pm
Well, I don't like the folder structure you are implementing, but I am sure it was agreed to be done that way 🙂
This is a proposed solution, I tested it...
Hope this helps,
Rock from VbCity
June 12, 2012 at 5:59 pm
aarionsql (6/11/2012)
I have built a package which:
1. searches for flat files through a Folder structure on the test server
2. moves the files to an active folder
3. Then to...
Hope this helps,
Rock from VbCity
June 12, 2012 at 7:45 am
THE-FHA (6/12/2012)
Hope this helps,
Rock from VbCity
June 12, 2012 at 6:45 am
Viewing 15 posts - 61 through 75 (of 128 total)