Debug BIDS Code?
Jun 7, 2005Hello,
Can you debug code for a script transformation in BIDS?Thanks.
ADVERTISEMENT
BIDS Debug Fails With Login Failed For User Error
Mar 17, 2008Hi all
I configured my packages to user package configurations, but when i try to debug a package in BIDS in get the following error in the execution results tab :
[Connection manager "XXXXXXXXXX"] Error: An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Login failed for user 'XXXXXXX'.".
Edit.
Now the degub works but after i deply the package to the sql server the package execution fails and the following is written into sql server errorlog
2008-03-17 15:56:31.71 Logon Error: 18456, Severity: 14, State: 8.
2008-03-17 15:56:31.71 Logon Login failed for user 'XXXXXXX'. [CLIENT: <local machine>]
The state 8 indicates bad password, but it isnt... because logging into sql server with that user and password works.
How To Debug Tsql Code?
Oct 6, 2007Hi everybody
Could anyone tell me how i can Trace or debug my TSQL Script
like High level Programming Languages line by line? is there any way to do that at all?
Kind Regards.
Debug (step Into) Sql Stored Proc From Managed Code
Aug 22, 2004I am trying to debug sql2000 sp from managed code app with VS.Net 2003 archetect Ed..
It did not stop at the break point within the sql sp.
I did granted execute permission for sp_sdidebug.
Do I need to attach any process?
Is there anything left off by the article?
I referenced msdn article option 2: http://support.microsoft.com/default.aspx?kbid=316549
Thanks.
RE : BIDS
Dec 18, 2007I installed Visual Studio'05 on my sys.
But it has no BIDS in its pop-up menu and also has no BI project templates.
I am trying to build cubes in SSAS.
Can anyone help me out.
Thanks
Licensing For BIDS
Feb 13, 2008Can we install BIDS client (no server components) on a separate workstation using a download of SQL Server 2005 Developer edition and not require a separate license for the workstation?
Tammy
Got BIDS Working, Was There Another Way?
Sep 20, 2006i re-installed the SQLEXPR_TOOLKIT.EXE several times(4) trying to get the BIDS part to work. Each time i had the issue of it looking for the devenev.exe as others have mentioned. I gave up on a 5th install and went for the unsupported option of running vs_setup , after the toolkit.exe dumped all the install files to its temporary directory i went in there and ran it sperately...but essentially i did it the same way as this method...
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=368549&SiteID=1
while this did work, it seems to be the unsupported way.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=665067&SiteID=1
Im not opposed to going back and doing it right, but was there ever a conclusion as to why the BIDS program sometimes doesnt install? im using 2k5 express products on this machine...
Not Able To Install BIDS
May 2, 2008
Hi all,
I have installed Sql server 2005 enterprise edition with the All the BI services (SSIS,SSAS,SSRS) . when i try to Install the Tools Like BIDS,documentation,sample databses. I am getting the error that foolowing compentes are already installed on the machine though they are not installed
Error message :None of the selected features can be installed or upgraded.Setup cannot Proceed since no effective change
is made to the machine.To continue,Click Back And then select features to install.To Exit SQL Server Setup,click cancel
I have installed vs2008 on my system
Kindly help
BIDS Keeps Crashing
Feb 1, 2007All of a sudden one of my projects/packages seems to have encountered a strange problem. First I tried to remove a data viewer which caused BIDS to crash and tell me that VS has encountered a problem and needs to close. This is repeatable every time I try to remove the data viewer or the link or the transforms or the entire data flow. How do I get around this besides starting from scratch and how do I figure out why this is happening and is there some fix?
thanks
John
MDX Disappears In BIDS...
May 9, 2007I have SQL Server 2005 SP1 installed and none of my datasets will retain the mdx expressions but the report will still run
View 2 Replies View RelatedAnnoying BIDS Bug
Feb 24, 2008
Well all bugs are annoying, but this one is particularly annoying because it kills the BIDS session with consequent loss of all changes made since the last save.
Click on a control flow task. Position the cursor so that it changes to the 4-way pointer. Drag the task a little bit. The UI locks up, and then BIDS disappears.
I can't repro this on demand, but it has happened about 6 times in the past month. Anyone else seen this one?
BIDS Abort
Aug 1, 2007On several occasions I have experienced crashes while running an SSIS package in debug mode. It happens when I start process on Control Flow table and click on Data Flow tab to monitor progress. I have forwarded the error reports and have searched the boards for similar references. Is this problem going to be fixed?
SSIS Data Sources
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
----------------------
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)
Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Visiual Studio 2005 Professional SP1 SP.050727-7600
.NET Framework 2.0.50727
Help With Converting Code: VB Code In SQL Server 2000-&&>Visual Studio BI 2005
Jul 27, 2006Hi all--I'm trying to convert a function which I inherited from a SQL Server 2000 DTS package to something usable in an SSIS package in SQL Server 2005. Given the original code here:
Function Main()
on error resume next
dim cn, i, rs, sSQL
Set cn = CreateObject("ADODB.Connection")
cn.Open "Provider=sqloledb;Server=<server_name>;Database=<db_name>;User ID=<sysadmin_user>;Password=<password>"
set rs = CreateObject("ADODB.Recordset")
set rs = DTSGlobalVariables("SQLstring").value
for i = 1 to rs.RecordCount
sSQL = rs.Fields(0).value
cn.Execute sSQL, , 128 'adExecuteNoRecords option for faster execution
rs.MoveNext
Next
Main = DTSTaskExecResult_Success
End Function
This code was originally programmed in the SQL Server ActiveX Task type in a DTS package designed to take an open-ended number of SQL statements generated by another task as input, then execute each SQL statement sequentially. Upon this code's success, move on to the next step. (Of course, there was no additional documentation with this code. :-)
Based on other postings, I attempted to push this code into a Visual Studio BI 2005 Script Task with the following change:
public Sub Main()
...
Dts.TaskResult = Dts.Results.Success
End Class
I get the following error when I attempt to compile this:
Error 30209: Option Strict On requires all variable declarations to have an 'As' clause.
I am new to Visual Basic, so I'm on a learning curve here. From what I know of this script:
- The variables here violate the new Option Strict On requirement in VS 2005 to declare what type of object your variable is supposed to use.
- I need to explicitly declare each object, unless I turn off the Option Strict On (which didn't seem recommended, based on what I read).
Given this statement:
dim cn, i, rs, sSQL
I'm looking at "i" as type Integer; rs and sSQL are open-ended arrays, but can't quite figure out how to read the code here:
Set cn = CreateObject("ADODB.Connection")
cn.Open "Provider=sqloledb;Server=<server_name>;Database=<db_name>;User ID=<sysadmin_user>;Password=<password>"
set rs = CreateObject("ADODB.Recordset")
This code seems to create an instance of a COM component, then pass provider information and create the recordset being passed in by the previous task, but am not sure whether this syntax is correct for VS 2005 or what data type declaration to make here. Any ideas/help on how to rewrite this code would be greatly appreciated!
How To Show Description In Report Instead Of Code (Desc For Code Is In Master Table)
Mar 28, 2007Dear Friends,
I am having 2 Tables.
Table 1: AddressBook
Fields --> User Name, Address, CountryCode
Table 2: Country
Fields --> Country Code, Country Name
Step 1 : I have created a Cube with these two tables using SSAS.
Step 2 : I have created a report in SSRS showing Address list.
The Column in the report are User Name, Address, Country Name
But I have no idea, how to convert this Country Code to Country name.
I am generating the report using the Layout tab. ( Data | Layout | Preview ) Report1.rdl [Design]
Anyone help me to solve this issue. Because, in our project most of the transaction tables have Code and Code description in master table. I need to convert all code into corresponding description in all my reports.
Thanks in advance.
Regards
Ramakrishnan
Singapore
28 March 2007
Sql Debug Help
Apr 5, 2007how can it be that
when I do the query
select * from rep where batch=133 it returns 730 and
select* from rep left JOIN Information ON rep.site = Information.Sitecode where batch=133 returns more then 730
I want it to return the same records as the first query but with the additional information from the information table --
what am i doing wrong?
T-SQL Debug
Jan 23, 2004Hello, everyone:
How to debug T-SQL codes? Can QA do that? Are there the special tools?
Thanks.
YTZ
Need To Debug SP's....
Jun 14, 2008Hi,
I need to debug my Store Procedures with diff parameters at regaular intervals which shows me memory usage, CPU usage and other usage.
Is there any way to do this?
-- Regards
Prashant Hirani
How Can We Debug An SP
Sep 25, 2006Is there a way like we do in programming or even bettre. Is there any better practice for this.
Thanks
Can U Help Me Debug This!!!!
Aug 23, 2007to all the experts can u help me about my codes Truncated incorrect DOUBLE value: 'NoOfPositives'
here's my code
select
ref_region.regionName,
ref_facility.facilityName,
ref_facility.adr,
ref_facility.facilityNo,
(select count(*)
from dto_initial_screening
where (dto_initial_screening.facilityNo = ref_facility.facilityNo and
dto_initial_screening.testDt between '2007-01-01' and '2008-01-01')) as 'TotalScreened',
(select count(*)
from dto_initial_screening
where (dto_initial_screening.testResult = 'POS' and
dto_initial_screening.facilityNo = ref_facility.facilityNo and
dto_initial_screening.testDt between '2007-01-01' and '2008-01-01')) as 'NoOfPositives'
from dto_initial_screening
left join ref_facility on dto_initial_screening.facilityNo = ref_facility.facilityNo
left join ref_region on ref_facility.adrRegionCd = ref_region.regionCd
where
('NoOfPositives') < (select Cast(paramVal as UNSIGNED) from ref_param where paramCd = 'minPositives')
How To Debug A Sp?
Mar 18, 2008How to debug a sp in sql server 2005?
View 1 Replies View RelatedJIT Debug HELP
Feb 24, 2007See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at HP.CUE.Video.PlaybackControl.UpdateProgressBar()
at HP.CUE.Video.PlaybackControl._ProgressTimer_Tick(Object sender, EventArgs e)
at System.Windows.Forms.Timer.OnTick(EventArgs e)
at System.Windows.Forms.Timer.Callback(IntPtr hWnd, Int32 msg, IntPtr idEvent, IntPtr dwTime)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase: file:///c:/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll
----------------------------------------
hpqimzone
Assembly Version: 3.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///C:/Program%20Files/HP/Digital%20Imaging/bin/hpqimzone.exe
----------------------------------------
hpqiface
Assembly Version: 4.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqiface/4.0.0.0__a53cf5803f4c3827/hpqiface.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase: file:///c:/windows/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll
----------------------------------------
System.Drawing
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase: file:///c:/windows/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll
----------------------------------------
System
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase: file:///c:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll
----------------------------------------
hpqcc2
Assembly Version: 3.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqcc2/3.0.0.0__a53cf5803f4c3827/hpqcc2.dll
----------------------------------------
hpqutils
Assembly Version: 4.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqutils/4.0.0.0__a53cf5803f4c3827/hpqutils.dll
----------------------------------------
hpqfmrsc
Assembly Version: 4.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqfmrsc/4.0.0.0__a53cf5803f4c3827/hpqfmrsc.dll
----------------------------------------
hpqtray
Assembly Version: 4.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqtray/4.0.0.0__a53cf5803f4c3827/hpqtray.dll
----------------------------------------
hpqovskn
Assembly Version: 3.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqovskn/3.0.0.0__a53cf5803f4c3827/hpqovskn.dll
----------------------------------------
hpqimvlt
Assembly Version: 3.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqimvlt/3.0.0.0__a53cf5803f4c3827/hpqimvlt.dll
----------------------------------------
hpqimgrc
Assembly Version: 4.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqimgrc/4.0.0.0__a53cf5803f4c3827/hpqimgrc.dll
----------------------------------------
hpqntrop
Assembly Version: 4.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqntrop/4.0.0.0__a53cf5803f4c3827/hpqntrop.dll
----------------------------------------
Interop.hpqcxm08
Assembly Version: 3.0.0.0
Win32 Version: 53.0.13.000
CodeBase: file:///c:/windows/assembly/gac/interop.hpqcxm08/3.0.0.0__a53cf5803f4c3827/interop.hpqcxm08.dll
----------------------------------------
System.Xml
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase: file:///c:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll
----------------------------------------
LEAD
Assembly Version: 13.0.0.113
Win32 Version: 13.0.0.113
CodeBase: file:///c:/windows/assembly/gac/lead/13.0.0.113__9cf889f53ea9b907/lead.dll
----------------------------------------
LEAD.Wrapper
Assembly Version: 13.0.0.113
Win32 Version: 13.0.0.113
CodeBase: file:///c:/windows/assembly/gac/lead.wrapper/13.0.0.113__9cf889f53ea9b907/lead.wrapper.dll
----------------------------------------
LEAD.Windows.Forms
Assembly Version: 13.0.0.113
Win32 Version: 13.0.0.113
CodeBase: file:///c:/windows/assembly/gac/lead.windows.forms/13.0.0.113__9cf889f53ea9b907/lead.windows.forms.dll
----------------------------------------
LEAD.Drawing
Assembly Version: 13.0.0.113
Win32 Version: 13.0.0.113
CodeBase: file:///c:/windows/assembly/gac/lead.drawing/13.0.0.113__9cf889f53ea9b907/lead.drawing.dll
----------------------------------------
interop.hpqimgr
Assembly Version: 3.0.0.0
Win32 Version: 53.0.13.000
CodeBase: file:///c:/windows/assembly/gac/interop.hpqimgr/3.0.0.0__a53cf5803f4c3827/interop.hpqimgr.dll
----------------------------------------
hpqthumb
Assembly Version: 3.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqthumb/3.0.0.0__a53cf5803f4c3827/hpqthumb.dll
----------------------------------------
hpqasset
Assembly Version: 4.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqasset/4.0.0.0__a53cf5803f4c3827/hpqasset.dll
----------------------------------------
hpqmirsc
Assembly Version: 3.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///C:/Program%20Files/HP/Digital%20Imaging/bin/hpqmirsc.DLL
----------------------------------------
hpqedit
Assembly Version: 3.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqedit/3.0.0.0__a53cf5803f4c3827/hpqedit.dll
----------------------------------------
hpqvideo
Assembly Version: 3.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqvideo/3.0.0.0__a53cf5803f4c3827/hpqvideo.dll
----------------------------------------
LEAD.Windows.Forms.DrawingContainer
Assembly Version: 13.0.0.113
Win32 Version: 13.0.0.113
CodeBase: file:///c:/windows/assembly/gac/lead.windows.forms.drawingcontainer/13.0.0.113__9cf889f53ea9b907/lead.windows.forms.drawingcontainer.dll
----------------------------------------
hpqmdmr
Assembly Version: 4.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqmdmr/4.0.0.0__a53cf5803f4c3827/hpqmdmr.dll
----------------------------------------
LEAD.Drawing.Imaging.ImageProcessing
Assembly Version: 13.0.0.113
Win32 Version: 13.0.0.113
CodeBase: file:///c:/windows/assembly/gac/lead.drawing.imaging.imageprocessing/13.0.0.113__9cf889f53ea9b907/lead.drawing.imaging.imageprocessing.dll
----------------------------------------
hpqimlib
Assembly Version: 3.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqimlib/3.0.0.0__a53cf5803f4c3827/hpqimlib.dll
----------------------------------------
hpqglutl
Assembly Version: 4.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqglutl/4.0.0.0__a53cf5803f4c3827/hpqglutl.dll
----------------------------------------
Interop.hpqvideo
Assembly Version: 3.0.0.0
Win32 Version: 53.0.13.000
CodeBase: file:///c:/windows/assembly/gac/interop.hpqvideo/3.0.0.0__a53cf5803f4c3827/interop.hpqvideo.dll
----------------------------------------
************** JIT Debugging **************
To enable just in time (JIT) debugging, the config file for this
application or machine (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the machine
rather than being handled by this dialog.
Debug
Jan 18, 2006
Hello guys!
I am trying to debug a sql procedure inside Server Explorer but I can seem to step into each line.
When I run the procedure it doesn't stop in the breakpoint I set.
By the way I am running in a client pc..
Please help guys!
BIDS Undo Button
Apr 9, 2008How come Undo button does not work? Thanks.
View 2 Replies View RelatedExporting To File Using BIDS
Nov 5, 2007Hi guys
I am trying to create a package in BIDS that reads data from a table and exports it into a flat file (.csv).
The file needs to have a row for the header and a row representing the column names as well as the data rows.
My problem is:
1.I need to add a value in the header row that is a count of all the data rows.
2. I need to add the year and period based on the year and period in the data rows. (the year and period will always be the same in the data rows)
below is an example of what I want the file to look like (it is a delimited file)
1;Varese;O027200702ACT;F1_V4;BATCH;2326;test company
CUSTOMER_ID;BU_ID;YEAR_ID;PERIOD_ID;ACTIVITY_ID;SCENARIO_ID;ACCOUNT_ID;DATA_UNIT_ID;DATA_VALUE
000001;ZA01000001;2007;2;01;1;70;ZAR;.04
000001;ZA01000001;2007;2;01;1;912;ZAR;6080374
000001;ZA01000001;2007;2;01;1;941;ZAR;-.16
The value in bold represent the values that i want dynamically updated...
200702 represents a concatenation of the year and period
2326 represents the number of data rows
Thanks a mill!
Mike
Silly Question About BIDS
Sep 29, 2006Hi guys,
When you get an warning from, i.e, OleDb Destination you see an exclamation mark in yellow and then, when you move the mouse over you can't see never the whole message (If long)
Is there any way to see the entire tooltiptext?
Thanks in advance and have a good weekend!
Reorder Packages In BIDS
Aug 15, 2007How or is there a way to reorder the packages in BIDS? Right now they are ordered by when they are created with the newest ones on the bottom. I'd like to organize these in more of a logical order but am unsure of how to do so.
Any advise?
Thanks,
Beac
FTP Connection Only Works In BIDS
Jun 26, 2007I have an FTP task that will only work when running in BIDS.
When trying to run as a package on the server or calling the package from a job, I get the following error in the log file:
OnError,<servername>,<user>,FTP Task,{B2F5BB68-C6F8-4EE5-ABC0-71C3636E3E4A},{B7B41A88-18DD-4AD7-8CDE-9E0C1B74DA02},6/26/2007 12:09:11 PM,6/26/2007 12:09:11 PM,-1073573489,0x,Unable to connect to FTP server using "FTP Connection Manager".
When running in BIDS it is fine.
Any know what is causing this?
BIDS FTP Task - ProtectionLevel
Apr 25, 2008In BIDS I Had created a package to receive FTP files from remote.
I had created a FTP Connection and FileConnection (As Existing folder) to receive files.
I had Changed my ProtectionLevel to Don'tSaveSensitive (Since i had my Auth details in SQL Server tables)
In the Package Configurations i have created the Configuration details and stored in my conf table.
Now, When i was executing my package, I got this error
[FTP Task] Error: File usage type of connection "FTPReceiveTest" should be "FolderExists" for operation "Receive".
Already the connection Type was set as 'Existing Folder' only.
Any ideas of where i was missed ?
Access BIDS From VS2005
Feb 20, 2007Can SOmeone help me How to get access BIDS from VS2005 . SQL server is installed in different server other than VS 2005 PC
View 1 Replies View RelatedSQL Express 2005 And BIDS
Aug 31, 2006I'm sorry but I am so frustrated from searching and trying things! I can't understand why this can't be resolved much easier.............anyway
I am trying to use BIDS on sql server express 2005 after attempting to install the tool kit a couple of times on different platforms. I have installed:
1) VS 2003 (also Visual C# Express on another machine);
2) .net 1.1 and .net 2.0;
3) SQL Server 2005 Express with Advanced services and the tool kit.
The sequence of installs is as follows
1).net 1.1 was there from the beginning
2)VS 2003
3).net 2.0
4)sql server 2005 express
5) tool kit
I see BIDS in the menu but devenv.exe does not exist. I've seen several workarrounds including finding and running vs_setup.msi but those don't work for me either. I am suspecting that the BIDS install conflicts with Visual Studio in any form! If this is true, can someone list those steps to follow to uninstall/re-install the products to get this working?
Thanks in advance!!!!!
BIDS Bug With SSIS Annotations
Jul 24, 2006I would like to report what appears to me to be a bug. I found it while researching an answer for another thread. http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=554926&SiteID=17
Since that thread has not received any further replies I thought I would start a new one to see what answer we can get from MS as well as if anyone else would care to reproduce.
The bug is not a major one and the work around is easy, but it can be annoying.
The bug is this: if I open an SSIS package in BIDS (RTM or SP1) and the only change I make is adding or modifying an annotation and then click on Save and then close BIDS does not save the new annotation or changes made to existing annotations. If I change something other than an annotation then BIDS does save the annotations with the package.
A careful observer will notice that when opening a package and then modifying or adding an annotation that BIDS does not even register that the package has been changed. This is evident by the lack of the trailing asterisk in the title bar after the package name.
In summary if I go into a package for the sole purpose of adding and/or modifying annotations they will not get saved. Workaround: modify something else in the package and then save.
Newbie BIDS Questions
Mar 17, 2006I've been learning SSIS and the BIDS for a few weeks now and there are 2 things that really annoy me. I'm hoping that there is a setting or option or something that I'm missing.
1. I place objects on the Control Flow surface, get everything arranged the way I want it, constraint lines all nice and tidy and then save it. When I open it things aren't the way they were when I closed it. Any way to make them stay the same?
2. If I select multiple objects and copy them when I paste them they are in really interesting places. Any way to have them stay in the same realitive positions?
This is one of the most helpful forums I've ever posted in so thanks to you all for the assistance.
John Colaizzi
Unable To Find BIDS
Dec 18, 2007
i installed visual studio'05 on my sys to build cubes in SSAS.But its not having BIDS in its pop-up menu,nor it has BI project templates.Can any one help me out.
Thanks