Viewing 11 posts - 16 through 26 (of 26 total)
October 3, 2008 at 2:05 pm
EUREKA!! Just run BIDS as Administrator on Vista and all works fine! :w00t:
October 3, 2008 at 6:12 am
Take a look at the Execute T-SQL Statement Task. In the editor you can see the 'Result set' link, and there you can set 0 as Result Set Name and...
October 2, 2008 at 4:32 am
I mean the output columns. The data type combo box is all black, I can't see its items. If I click on it, the window is closed...
October 1, 2008 at 2:40 pm
Aaargh!! :angry: So I have to install SQL Server 2005 BI Development Studio again! Bye bye C# scripting... :crying:
September 26, 2008 at 5:15 am
You can find the solution HERE.
Enjoy!! 😀
September 15, 2008 at 5:30 am
This oily work around is amazing!! :w00t: But why Microsoft wants to drive us mad???? :angry:
By the way, thanks for your trick Alexander!! :kiss: 😀
September 15, 2008 at 5:22 am
I got the solution!! :w00t:
Simply, at the top of the OLE DB Source SQL statement and before the EXEC MySP line, I added the following: SET FMTONLY OFF !!
It seems...
June 4, 2008 at 7:57 am
We have SQL Server 2005 installed 1 week ago and now I'm practicing with SSIS. I developed a lot of Stored Procedures in the previous SQL Server 2000 and now...
May 24, 2008 at 3:24 am
No temp tables and only one resultset... The strange think is that the "Preview..." works fine, but it isn't so for the columns selection 🙁
May 21, 2008 at 2:09 pm
crever (5/21/2008)
I've had good luck with simple SPs, but with complicated SPs that had a lot of selects, I don't think it handles that very well.
Yes! It has a lot...
May 21, 2008 at 2:07 pm
Viewing 11 posts - 16 through 26 (of 26 total)