Viewing 15 posts - 151 through 165 (of 323 total)
As suggested by Koen, I deleted the columns within the "Union All" by right-clicking on the output column definitions.
February 10, 2012 at 8:18 am
I looked at removing the columns from the OLE DB Cmd output but could not find a way.
And is it not impossible to remove a column from a flow?
February 10, 2012 at 7:51 am
Damn again, I was looking on right click but I had my cursor in the wrong field and/or the column state was wrong.
Cool!
February 10, 2012 at 7:49 am
In the attached screenshot,
1) is where I use these variables
2) is where I get the warning
February 10, 2012 at 5:00 am
Actually, it complains about three columns.
One of these columns is not really used anywhere indeed so I removed it from the derived column task where I created it.
The bizarre thing...
February 10, 2012 at 4:23 am
Indeed... If I choose the executable directly rather than double clicking on the package, it works fine.
Once again, thanks a bunch! :w00t:
February 10, 2012 at 2:14 am
Damn!
What had it look even more complex was that I forgot to inherit a variable value from the master package in a sub package and that variable was then used...
February 8, 2012 at 9:22 am
I do indeed develop on BIDS 2005 for this project because the Prod target is 2005.
Everything seemed fine on my dev server (aka laptop) but not in a different environment.
As...
February 8, 2012 at 5:36 am
I am struggling a bit to define a configuration strategy because i want to cope with the following cases and it's becoming complicated...
- I may have developers working on different...
February 8, 2012 at 4:22 am
In an environment where there are both 2005 and 2008 versions on the same server.
Am I right to assume that the SSIS Runtime IS 2008 even if I schedule my...
February 8, 2012 at 4:01 am
As you'd have expected, it did the trick.
I created an XML configuration file to setup some variables in a "parent" package and derived everything else from there (via expressions).
Another thing...
February 7, 2012 at 3:17 pm
I like that!
Indeed, my problem was really BIDS.
I don't have the time just now but I'll give that a shot ASAP.
Many thanks
Eric:-D
February 3, 2012 at 2:09 am
But does not that only affect the runtime?
At design time, these connections are used "as is" to check the metadata, etc...
It's fine if everyone develops on the same server but...
February 2, 2012 at 11:03 am
Actually, my problem was very different from what I thought...
The OLE DB Cmd was producing an error and redirected the rows with 2 new columns ErrorCode and ErrorColumn.
Unfortunately, there...
February 1, 2012 at 7:45 am
Marvellous!
It worked. Many thanks
😀
November 16, 2011 at 7:33 am
Viewing 15 posts - 151 through 165 (of 323 total)