How 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
There seems to be a BUG in BIDS when developing SSIS packages using the Import/Export Data wizard.
If you use the wizard to import a large number of tables, and then select all the tables, and then choose to delete exisiting data in each table, the PrologueSQL file does NOT get built correctly. Instead of having a
TRUNCATE tablename Go
for each table, it just has a bunch of "Go"s with nothing between them. In the step immediately prior, where you confirm what the wizard will do, it tells you, after each table, that it will delete any existing data...but it doesn't do this.
If, during the wizard, I select each individual table one at a time and tell it to delete existing data, then it will get built correctly, but not if I select them all at once...YET, if I do select the whole block, choose delete existing data, and then select any single table, it shows that table as being set up to delete existing rows.
This is very frustrating when trying to import large numbers of tables.
Am I missing something? or is this really a bug?
Thanks, Jeff
Hi,
I am surprised to see that in Business Inteligence Studio debugging mode, my packages take shorter. And when I run it through Agent on the SQL Server where data actually resides, it take around 70% longer time.
The package is now very closed to data and database engine itself, in BIDS it wasnt.
Anybody knows why this happen ? Do I need to tune up something ?
Any input in this will sincerely be appreciated.
BIDS hangs when I open any SSIS packages. "Microsoft Visual Studio Is Busy" message displays in the system tray. It indicates that Microsoft Visual Studio is waiting for an internal operation to complete; however, it never seems to complete. I have recycled the server hoping to break it loose, however nothing seems to free it up. I have not had this situation before and I cannot figure out why it is having problems. BIDS shows it is "Validating Data Flow Task". Has anyone encountered this problem before?
Would it be a true statement that whenever you use BIDS to alter a SSIS package the source has to be available because verification and validation is always done on the source and destination? If the source were not available could that cause the hang in BIDS???
I have a bunch of packages in msdb. Is there any easier way to move those packages from msdb to DataTools/BIDS, instead of adding one package at a time using ADD option.
View 9 Replies View RelatedHi All,
I am not able to open the package in BIDS. When I open the package I am seeing only the XML. Below I had given what I have done.
First I have installed Visual studio 2008 Professional and next I installed SQL Server 2005 with Integration services, database services, workflow components.
I am able to see the BIDS in Start --> All Programes --> Microsoft SQL Server 2005 --> "SQL Server Business Intelligence Development Studio"
Any help would be appreciated.
Thanks in Advance.
Hi I have completed my first SSIS master package which runs a whole lot of child packages depending on value of expressions on workflow. (refer http://www.sqlis.com/306-3.aspx)
Each of my child packages is .dtsx file location and each Excute Package task uses the file connection.
The master parent package is also a dtsx file location which will be run by a SQL Server 2005 Agent
All good--problem is testing from BIDs--each time a Excecute package task is run--turns yellow a new tab appears apears in the design window --showing you that particular .dtsx file control flow detail. DTS never had this behaviour --can I turn this off in the BIDS ie as I have dozens of new tabs at run time which makes it very hard to keep track of the master package. All I want is the master package running from BIDs, and no new tabs appearing at run time???
Thanks kindly
Dave
Howdie y'all,
Im adding rows to my database like this:
GroupID = IdentityGroupUser = UserIdGroupColumn = 1 GroupPosition = Count (*) where UserId = UserId AND Column = 1
Int this way my table looks like this on a certain moment:
1 ; 1 ; 1 ; 02 ; 1 ; 1 ; 13 ; 1 ; 1 ; 24 ; 1 ; 1 ; 3
But then i would, for example, like to delete the 3rd row and i like to renumber the last column so form this:1 ; 1 ; 1 ; 02 ; 1 ; 1 ; 14 ; 1 ; 1 ; 3 <- this is my problem
to this:1 ; 1 ; 1 ; 02 ; 1 ; 1 ; 14 ; 1 ; 1 ; 2 <- here it is solved
Whats the simplest sql stored procedure to perform this reordering task???
Thanks,
Wes
I have a SqlDataReader object that has some records:
1 hello12 hello23 hello3
Is there a fast/easy way to reorder them?
3 hello32 hello21 hello1
So far I'm able to populate an ajax control toolkit reorder list with an SQL table, but I can't get it to reorder through the database.The SQL table is something like this-int ListID, varchar Title, int SortingOrder (SortingOrder always goes 1-n, there are no duplicates and no gaps) When the user changes the position of an entry, I need the reorder list to update the SortingOrder of all the pages between the starting and ending place of the reordered entry. I already have that function written, ReorderListEntries (int OldSortingOrder, int NewSortingOrder), but how and where do I call it?Basically, when the user reorders the list, I need it to-1. get the old and new positions of the reordered entry.2. pass this information back to the server3. call ReorderListEntries (old,new)4. partial page refresh the listHelp with this one will be greatly appreciated.
View 1 Replies View Related
The business operation is this:
The data is stored and accessed by Invoice Number and Line Number. If there are 4 lines, 1,2,3,4 and number 2 is deleted the users want lines 3 and 4 reordered to be 2 and 3.
The existing code does things the following way, but I have my suspicions about how bulletproof it is:
Existing Data:
123,1
123,2
123,3
123,4
Begin Transaction
Delete where InvoiceNumber = 123 and LineNumber = 2.
Update set LineNumber=2 where InvoiceNumber=123 and LineNumber=3
Update set LineNumber=3 where InvoiceNumber=123 and LineNumber=4
Commit Transaction
Is there a better way of doing this?
Thanks.
Quote: Originally Posted by mrtwice99 Yes, but how would you figure out which row was "before" it?
Code:
SELECT id, sortOrder, name FROM daTable
WHERE id = 937 OR sortorder =
( select max(sortorder) from daTable
where sortorder < ( select sortorder from daTable where id = 937) )
Use the Northwind database Products table as an example.Purchasing dept gets a report showing when inventory items on hand qty arebelow the reorder level.easy enough:Select ProductID, ProductName, SupplierID, UnitsInStock, ReorderLevelfrom Productswhere (UnitsInStock < ReorderLevel)Results:ProductID ProductName SupplierID UnitsInStock ReorderLevel2 Chang 1 17253 Aniseed Syrup 1 1325It would be nice to know what other products are purchased from this samevendor in case other items are close to their reorder level.All products for Supplier ID 1Select ProductID, ProductName, SupplierID, UnitsInStock, ReorderLevelfrom Productswhere SupplierID = 1Results:ProductID ProductName SupplierID UnitsInStock ReorderLevel1 Chai 1 39102 Chang 1 17253 Aniseed Syrup 1 1325This shows there is 1 more product (Chai) that also comes from Supplier 1.Is there a way to show all items from a vendor when some of the items arebelow the reorder level without needing a separate query for each vendor?Thanks
View 4 Replies View RelatedHi,Is it possible to reorder the table definition in a SQL 2005 table?Example : i want to put to table definition in alphabetical order.Thanks in advance
View 8 Replies View RelatedI've run into a problem with SSIS packages wherein tasks that write or copy files, or create or delete directories, quit execution without any hint of an error nor a failure message, when called from an ASP.NET 2.0 application running on any other machine than the one where the package was created from. By all indications it appeared to be an identity/permissions problem.
Our application involves a separate web server and database server. Both have SQL Server 2005 installed, but the application server originally only had Integration services. The packages are file system-deployed on the application server, and are called using Microsoft.SqlServer.Dts.Runtime methods. For all packages that involve file system tasks, the above problem occurs.
When the above packages are run using the command prompt (either DTEXEC or DTEXECUI) the packages execute just fine. This is expected since we are using an administrative account. However when a ShellExecute of the same command is called from ASP.NET, the same problem occurs.
I've tried giving administrative permissions to the ASPNET worker process user to no avail.
I have likewise attempted to use the SQL Server Agent job approach but that approach might not be acceptable for our clients since it means installing SQL Server 2005 Database services on the application server.
I have read the relevant threads in this forum, namely http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1044739&SiteID=1 and http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=927084&SiteID=1 but failed to find any solution appropriate for our set up.
Anybody got any idea on how to go about this?
We manage some SSIS servers, which has only SSIS and SSIS tools installed on them and not the sql server DB.
SSIS packages and configuration files are deployed on a NAS. We run the SSIS packages through DTEXEC by logging in to the server.
We want to allow developers to run their packages on their own on the server, but at the same time we dont want to give them physical access on the server i.e we do not want to add them into RDP users list on server properties. We want them to allow running their packages remotely on the server.
One way We could think of is by using powershell remoting and we are working on that. But is there any other way or any tool already present for the same.
Hi all
Our data management system currently runs DTS packages using DTSPKG.dll.
I am currently looking at the possibliity of replacing the DTS packages and SQL 2000 with DTSX packages using SSIS in SQL 2005.
Do I need a new dll? or will the current dtspkg.dll handle the new DTSX packages?
Many thanks in advance!
I 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
Can 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
i 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...
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
All 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
I 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 Related
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?
On 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
Hello,
Can you debug code for a script transformation in BIDS?Thanks.
How come Undo button does not work? Thanks.
View 2 Replies View RelatedHi 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
Hi 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!
I 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?
In 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 ?
Can 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 RelatedI'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!!!!!