Can i set somehow the package to have the components automaticaly updated?

SQL Server Integration Services

Index ‹ SQL Server

- Previous
  - 1
    - SQL2000 and SQL2005 named instances on same server Is it the best practise to run SQL2000EE and SQL2005EE named instances on the same server on Windows 2K3 EE Any comments Tag: Can i set somehow the package to have the components automaticaly updated?
  - 2
    - Bulk Insert Error Simple test project. Created Flat File connection, database connection (both local), and Bulk Insert Task. When running the package I get the following error: [Bulk Insert Task] Error: An error occurred with the following error message: "Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.Bulk load: An unexpected end of file was encountered in the data file.". I've tried different settings for the Flat File config, and the database connection, but still get the error. Any suggestions would be helpful. Tks. Tag: Can i set somehow the package to have the components automaticaly updated?
  - 3
    - Does file connection manager not work offline? Hi there I have a connectin manager for file( New File Connection..) along with some oledb connection managers. Now If a put SSIS work Offline as True (I need this for some reason). Connection manager for File gives error as something -- "Connection manager for File connection failed with error code-0xc0014019,Connections cannot acquire connections while work offline is true." But other connections of olddb work fine. so do we have to change some more settings with file connection or with file connection we can't work offline Thanks and Regards Rahul Kumar Tag: Can i set somehow the package to have the components automaticaly updated?
  - 4
    - run MDX query in SQL Server Agent issue Hello, We have 'Create global cube' MDX query running fine in Management studio, but it can not run in job agent, error massage: [136] Job testcube reported: Microsoft.AnalysisServices.Xmla.XmlaException: CREATE GLOBAL CUBE statement. FILENAME|C:\dw\cube\monthly\mycube.cub|DDL|<Batch xmlns=" http://schemas.microsoft.com/analysisservices/2003/engine " xmlns:xsd=" http://www.w3.org/2001/XMLSchema " xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance"><Create AllowOverwrite="true"><ObjectDefinition><Database><ID>mycube</ID> <Name>mycube</Name> <Cubes><Cube><ID>mycube</ID><Name>mycube</Name> <ScriptErrorHandlingMode>IgnoreAll</ScriptErrorHandlingMode> <MeasureGroups><MeasureGroup> <ID>Fact mycube</ID><Name>Fact mycube</Name> <Source xsi:type="MeasureGroupBinding"><DataSourceID>mycube</DataSourceID><CubeID>mycube</CubeID><MeasureGroupID>Fact mycube</MeasureGroupID><Persistence>All</Persistence></Source><IgnoreUnrelatedDimensions>true</IgnoreUnrelatedDimensions><Measures><Measure><ID>Count Orders</ID><Name>Count Orders</Name><Visible>true</Visible><AggregateFunction>Sum</Aggregat Anyone could help with any suggestions Thanks in advance. Tag: Can i set somehow the package to have the components automaticaly updated?
  - 5
    - Connection path OK on device, not on desktop This code... string Path = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase); // Create the connection fConnection = new SqlCeConnection("Data Source =\"" + Path + "\\TreeNotes.sdf\" ;Password =\"abcd1234\";"); fConnection.Open(); ...works on my device, but on my computer it gives SqlCeException with message: The database file cannot be found. Check the path to the database. [ File name = \Program Files\TreeNotes\TreeNotes.sdf ] I've tried all sorts of things, but the computer just can't find the database. I've even tried putting a copy of the database into... C:\Program Files\TreeNotes\TreeNotes.sdf ...hoping that the computer will find it there. What am I missing Tag: Can i set somehow the package to have the components automaticaly updated?
  - 6
    - Problems With OLE DB Command Transformer I am trying to use the OLE DB Command Transformation to update rows in my table. When I make the connections and select the connectionmanager I get the following error: Error at Data Flow Task [OLE DB Command [6624]]: An OLE DB error has occurred. Error code: 0x80040E0C. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E0C Description: "Command text was not set for the command object.". I cannot figure out what to do. The connection is valid. I have used it in many places in the data stream. I also see that there are no output columns available for mapping. I didn't see a place to select the table. Can anyone please help. Thanks, Lee Tag: Can i set somehow the package to have the components automaticaly updated?
  - 7
    - Print each tables in new page Options Hi All, I have a report which has four tables in it. But I have only one Dataset. Since this dataset has more then 30 fields, I have divided this into four tables to be shown in a report. This will help the user to take print of the report and place each print out side by side for view. Showing each table in a new page is just fine. It works. But when we take print out some times rows of second table are printed in same page that shows rows of first table. With this user can not put each print out side by side for view. Is there any way to set option like print each table in new page I mean to say after printing first table, second table print should start at new page. Thanks in advance. Tag: Can i set somehow the package to have the components automaticaly updated?
  - 8
    - All my money in dollars please?? I have a Windows 2003 server, with SQL 2005. How do i change the culture/regional options for the database as on my local test machine (which seems to be exactly the same in terms of windows regional settings and SQL server settings) the currenency fields show with a ¡ê signs as expected, however on my production box they are $. I know this should be simple but its the night before a deadline and my brain is screwed. Please help!! Tag: Can i set somehow the package to have the components automaticaly updated?
  - 9
    - Using Xcopy to get the .mdf file of pubs database to the App_Data folder of a website of VWD Express project Hi all, I have a stand-alone Windows XP Pro PC that has SQL Server Express (SSE) and Visual Web Developer Express (VWDE) programs. The Microsoft "pubs" Database is installed in the SQL Server Management Studio Express (SSMSE). I created a website in my VWDE program. I need the .mdf file of the pubs Database in the App_Data folder of website of my VWDE project. I think that User Instance in my SSE is established. I have studied Xcopy Deployment (SQL Server Express) and User Instance for a quite a while and I still do not know where and how to use Xcopy to get the mdf file of the pubs database into the App_Data folder of the website of my VWDE project. Please help and give me the detailed key steps/instructions about where and how to get the .mdf file of the pubs database into the App_Data folder of the website of my VWDE project via Xcopy. Thanks in advance, Scott Chang Tag: Can i set somehow the package to have the components automaticaly updated?
  - 10
    - error column Hi, There is an error output from one oledb destination which causes error to another which populated a table called tblFailedRows. I have mapped the errorcolumn to the errorcolumn in tblFailedRows. When looking at the errorcolumn in tblFailedRows I see just numbers not the column name. How do I get the column name that causes the error Thanks Tag: Can i set somehow the package to have the components automaticaly updated?
  - 11
    - job failed om the sql server Hi, i have a problem when i schedule an agent on the sql server and i log off the sql server , the agent failed with this msg' in the event viewr : Login failed for user 'sa'. [CLIENT: <local machine>]. the account that run the SQL AGENT is NT AUTHORITY\NETWORKSERVICE. i guess the problem is there but i can't find how to resolve it i'll be happy for any help. 10X. Tag: Can i set somehow the package to have the components automaticaly updated?
  - 12
    - Cannot shut down VS after using report designer Routinely when I use BIDS to work on a report design, I cannot close BIDS because I get a message box that says: Microsoft Visual Studio cannot shut down because a modal dialog is active. Close the active dialog and try again. Of course, there is no visible dialog open. I actually have to terminate the process from task manager. I do not get this problem when using SSIS or SSAS. Only SSRS. Any Ideas Thanks! BobP Tag: Can i set somehow the package to have the components automaticaly updated?
  - 13
    - Report Header woes I am creating a report which consists of data in two columns. I've set the Body section to have 2 columns in it. This works fine until I start working with the report header. I do not want a page header that shows up on every page, I only want a header on the first page, a report header. I first tried to hide the header by placing it in the Page Header section, then putting in the "page > 1" expression in the visibility property. This does what I want, except a large blank space is present at the top of my report (the header is about 1.2 "). This is unacceptable. So my next test was to put the header into the Body section so that it only shows up in the beginning of the report. Because of this, I will need to remove the columns from the Body and make it only 1 column now. I decided to put the multi-column section into a subreport that has 2 columns and add this to the body of my report. But, this failed; the data appears in one column only. I can change the width the ensure it fits and set all other sorts of properties, nothing works. I've researched both issues and found that these are both "bugs" in reporting services, although I cannot find thedocumented bugs. Is there any workaround to putting a header onto only the first page of a multi-column report Other reporting engines are able to handle this with ease, I'm suprised by Reporting Services lack of a "Report Header" section. I am an experienced .NET developer, so if there is a programmatic way through this, I am game. Thanks, Scott Steigerwald Tag: Can i set somehow the package to have the components automaticaly updated?
  - 14
    - Dynamic SQL and sp_executesql Hi I have a SP where i search for values in a column and returns the results. Problem is, if i send in %word% OR body LIKE %word2% i get no results but if i just send in %word% then i get results (i know there are results since i ran a regular query (not SP one) and got the results. The SP looks like this set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[doSearch] -- Add the parameters for the stored procedure here @searchWord nvarchar(4000) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; DECLARE @sql nvarchar(4000); DECLARE @ParmDefinition nvarchar(500); DECLARE @searchTitle nvarchar(500); DECLARE @searchName nvarchar(500); DECLARE @searchPath nvarchar(500); DECLARE @searchBody nvarchar(4000); DECLARE @searchDate DateTime; -- Insert statements for procedure here SELECT @sql = 'SELECT @sTitle = f.title, @sName = f.name, @sPath = f.path, @sBody = c.designBody, @sDate = c.lastModify FROM files AS f INNER JOIN contents AS c ON c.fileId = f.id WHERE (f.status = 2) AND (c.designBody LIKE @sWord) ORDER BY c.lastmodify DESC'; SET @ParmDefinition = N'@sWord nvarchar(4000), @sTitle nvarchar(500) OUTPUT, @sName nvarchar(500) OUTPUT, @sPath nvarchar(500) OUTPUT, @sBody nvarchar(4000) OUTPUT, @sDate DateTime OUTPUT'; EXEC sp_executesql @sql, @ParmDefinition, @sWord = @searchWord, @sTitle = @searchTitle OUTPUT, @sName = @searchName OUTPUT, @sPath = @searchPath OUTPUT, @sBody = @searchBody OUTPUT, @sDate = @searchDate OUTPUT; SELECT @searchTitle AS title, @searchName AS name, @searchPath AS path, @searchBody AS body, @searchDate AS lastmodify; END I am pretty sure that i have messed up somewhere. Thanks for the help in advance! Tag: Can i set somehow the package to have the components automaticaly updated?
  - 15
    - Service Broker "TO service could not be found" Message origin: "Transport" I am trying to send a message between to SQL Server 2005 instances on two different machines. I have checked all my routes and all my objects appear to be setup correctly. However, when running Profiler on the target machine, I receive the "This message has been dropped because the TO service could not be found. Service name: "[tcp://mydomain.com/TARGET/MyService]". Message origin: "Transport". This is my activated stored procedure that is sending the message to the target service. I am using certificate security. Any help appreciated.... CREATE PROCEDURE [usp_ProcessMessage] AS BEGIN SET NOCOUNT ON ; DECLARE @conversation_handle uniqueidentifier DECLARE @message_body AS VARBINARY ( MAX ) WHILE ( 1 = 1 ) BEGIN BEGIN TRANSACTION ; WAITFOR ( RECEIVE TOP ( 1 ) @conversation_handle = conversation_handle , @message_body = message_body FROM [tcp://mydomain.com/INITIATE/MyQueue] ), TIMEOUT 1000 ; IF ( @@ROWCOUNT = 0 ) BEGIN COMMIT ; BREAK ; END END CONVERSATION @conversation_handle IF @message_body IS NOT NULL BEGIN BEGIN DIALOG CONVERSATION @conversation_handle FROM SERVICE [tcp://mydomain.com/INITIATE/MyService] TO SERVICE '[tcp://mydomain.com/TARGET/MyService]' ON CONTRACT [tcp://mydomain.com/INITIATE/MyMessage/v1.0] WITH ENCRYPTION = ON , LIFETIME = 600 ; SEND ON CONVERSATION @conversation_handle MESSAGE TYPE [tcp://mydomain.com/TARGET/VisitMessage] ( @message_body ); END COMMIT ; END END GO My endpoints are created like so: CREATE ENDPOINT MyEndpoint STATE = STARTED AS TCP ( LISTENER_PORT = 4022 ) FOR SERVICE_BROKER ( AUTHENTICATION = CERTIFICATE MasterCertificate ) GO GRANT CONNECT TO CertOwner GRANT CONNECT ON ENDPOINT :: MyEndpoint TO CertOwner GO And my routes like so: GRANT SEND ON SERVICE :: [tcp://mydomain.com/INITIATE/MyService] TO CertOwner GO CREATE REMOTE SERVICE BINDING [MyCertificateBinding] TO SERVICE '[tcp://mydomain.com/TARGET/MyService]' WITH USER = CertOwner , ANONYMOUS = OFF CREATE ROUTE [tcp://mydomain.com/INITIATE/MyRoute] WITH SERVICE_NAME = '[tcp://mydomain.com/TARGET/MyService]' , BROKER_INSTANCE = N 'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx' , ADDRESS = N 'TCP://xxx.xx.xx.xx:4022' GO Tag: Can i set somehow the package to have the components automaticaly updated?
  - 16
    - Where clause in a SET Can you use a WHERE clause in a set statement I want to limit the set I am building to a certain subset of data. SET [Customers] as ORDER ( NONEMPTY ([Dim Customer].[Name].[Name]. members ,[Measures].[Coil Weight]), [Measures].[Coil Weight], BDESC ) MEMBER measures.[Ton Rank] AS RANK ([Dim Customer].[Name]. CurrentMember ,[Customers]) Somewhere I'd like to add "WHERE ([Dim SalesType].[SalesYype] = "Sales")..............or something. Can this be done Thanks. Tag: Can i set somehow the package to have the components automaticaly updated?
- Next
  - 1
    - Table transfer errors Hello, I am trying to transfer a database from one server to another using the Import Export wizard in SSIS and I am consistantly getting this error on 2 different tables so far. - Execute the transfer with the TransferProvider. (Error) Messages * ERROR : errorCode=-1073451000 description=The package contains two objects with the duplicate name of "output column "ErrorCode" (79)" and "output column "ErrorCode" (14)". helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC} (Microsoft.SqlServer.DtsTransferProvider) This error message is beyond cryptic and when I click on the link it sends me to a web page the just tells me that there is no information available for my current issue. I am transfering the tables to an empty database so I do not understand why I am receiving this error. I have to say that I am not impressed with SSIS at all. I know alot of developers think it's the best thing since sliced bread, however either I am doing something wrong or Microsoft needs to come out with a service pack that fixes these bugs... Any help would be appreciated... Thanks, David Tag: Can i set somehow the package to have the components automaticaly updated?
  - 2
    - Query takes more time from user interface or in a network I execute a pretty big sql query which joins multiple tables and I reviewed indexes on all these tables. I am happy with the result when I run the query using SSMS in the server locally i.e., where my SQL Server database is installed. It takes 4 seconds to get around 17000 records. If I run the same query in a network or from my desktop using SSMS i.e., i connect to the above mentioned SQL Server using SSMS, it takes more than 60 seconds. Not sure how to solve this. If someone could help me, it will be of great help. Thanks. Tag: Can i set somehow the package to have the components automaticaly updated?
  - 3
    - Packege success, despite task failure Hello, When I run my package, a task will fail, however, the package will claim that it was successful. Why is this, and how can I trigger a failed package when one task fails Thanks in advance. Tag: Can i set somehow the package to have the components automaticaly updated?
  - 4
    - Can i host a SQL2005 EE DB on SQL2000 engine ? Hi, I'd like to host a small website created using VS2005 EE with a company that offers just SQL2000 DB support. My question, can i use the DB created by VS site manager as a DB to the site, if not, is there any alternatives. Thanks. Tag: Can i set somehow the package to have the components automaticaly updated?
  - 5
    - Incorrect processing order for views I am using SQL 2005 merge replication with SP1 hotfix build 9.00.2227.00. This build is in use rather than SP2 because a fix I need is not yet available for SP2 Essentially the problem is as follows: 1) Initial state is that merge replication of table and views is working fine 2) I then alter one view which reference s a new view in the same publication 3) Synchronization processes the view scripts in the wrong order regardless of the processing order 4) An 'invalid object name' error results as the new view has not arrived at the subscriber when alteration of the first view is attempted The number suffixes on the script filenames in the snapshot folder do, however,appear to be numbered correctly so as to process in the correct order Note that I have tried using the default processing order and have also set the processing order explicitly using sp_changemergearticle - but the problem still occurs I have tried to recreate this problem on a small database with a minimum of articles, but attempts at repro have failed to date with a simple configuration - ie the processing order applied is correct Is there an known problem in this area Any suggestions would be much appreciated aero1 Tag: Can i set somehow the package to have the components automaticaly updated?
  - 6
    - Unable to read local eventlog (the parameter is incorrect) In trying to setup alerts and activating them, an error occurs in the sql agent log of Unable to read local eventlog (the parameter is incorrect) The full messages from the Windows NT Logs shows: Event Type: Error Event Source: SQLSERVERAGENT Event Category: Alert Engine Event ID: 318 Date: 03.11.2005 Time: 17:14:47 User: N/A Computer: RESYSHADOW Description: Unable to read local eventlog (reason: The parameter is incorrect) Does anyone know what could be causing this. I have tried it on Windows XP SP2 with local Admin account and on Windows Server 2003 with Domain Administrator Account and the SQL2005 Server is RTM with the same results. Tag: Can i set somehow the package to have the components automaticaly updated?
  - 7
    - Database Blobs & Performance Hi geniuses, I have a core database question in MS Access and SQL Server. Assume the following table in MS Access or SQL Server: Employees table: EmpID, Name, Hiredate, Photo; and the following query: "SELECT EmpID, Name, Hiredate FROM Employees;" The question is, "does the blob object ( Photo) affect the performance of the query even when not included in the select statement " I mean, will I gain some additional performance when separating the blob fields to another table Thanks for the answer. Tag: Can i set somehow the package to have the components automaticaly updated?
  - 8
    - How to extract domain name from an email address?? Hi do you know incase a script which extracts domain names from an email address like foreg. we have xyz@dmc.com or abce@dmc-int.com should give dmc and dmc-int Tag: Can i set somehow the package to have the components automaticaly updated?
  - 9
    - problem connecting Remote Analysis service 2005 from vb.net 2005 hi mates, following code works fine in the server machine where sql server exists. but this doen't run at client machine. it throws error as " A connection cannot be made. Ensure that the server is running. " help to solve this problem thanks Code Snippet Dim msSvr As New Server Dim db As New Database Try If Not msSvr Is System.DBNull.Value Then msSvr.Disconnect() End If 'both connections r not working msSvr.Connect( "Provider=MSOLAP.9; datasource=http://server/olap/msmdpump.dll;Initial Catalog=testolap;user id=sa;password=sa;" ) msSvr.Connect( "Provider=SQLNCLI.1;Data Source=esERVER;user id=sa;password=sa;" ) If Not db Is System.DBNull.Value Then db.Dispose() End If db = msSvr.Databases.Find( "testdb" ) db.Process(ProcessType.ProcessFull) db.Refresh( True ) Catch ex As Exception Console.WriteLine(ex.Message) Finally db.Dispose() msSvr.Disconnect( True ) End Try Tag: Can i set somehow the package to have the components automaticaly updated?
  - 10
    - select inside update query? Is it possible for me to do something like update table1 SET var1=something,var2=something2 from table1 (SELECT * from table2) as newtable where newtable.field1=acondition Tag: Can i set somehow the package to have the components automaticaly updated?
  - 11
    - SSAS processing Hi, I created IS package for cube processing and if I execute this task , then execute result is successful. But I don't see any update information through BIDS when I browse the cubes. Why it happens and how can I check it Connection string is fine and i've also checked the processing configuration and I don't see any problem. Any kinds of advice would be appreciated. Thanks in advance. Tag: Can i set somehow the package to have the components automaticaly updated?
  - 12
    - Schema (owner) Names Not Visible In Shapes On Diagram When reverse engineering a SQL Server 2005 database (using VS 2007 Professional), I can't figure out a way to display the schema name in front of the table name in the database diagram. For instance, If I have a table named Person.Type, it just comes over as Type. It knows what the schema is because it's in the properties box for that object. It just doesn't appear in the name on the shape itself. Is there a setting somewhere that I'm missing that will display the schema in the name Tag: Can i set somehow the package to have the components automaticaly updated?
  - 13
    - Select Statement Problem? Hi every1, Recently i have this exam about sql statements, it shows that it has 1 table like this one. name telephone1 telephone2 ian 1234567 7654321 test 1111111 2222222 How can we make a select query where the output is this name telephone_numbers ian 1234567 7654321 test 1111111 2222222 Tag: Can i set somehow the package to have the components automaticaly updated?
  - 14
    - MS SQL2005 express ed + SSIS installation problem Hi, I have tried to install SSIS going steps msdn2 using "mssql setup" but my "ssis" option is not available for installation. Pls, help! Tag: Can i set somehow the package to have the components automaticaly updated?
  - 15
    - Problem in MDX query for calculating total sales. hi, can someone help in finding the error in this mdx query for the given problem statement. Query : Sales performance by gender of the customers. - The expected output is 2 values of sales ,one for all male customers and other for all female customers. - The level CustomerID of dimension Customer has attribute GENDER. - I have calculated two sets [Male] and [Female] . - At present i am getting sales value for all the members ,i want one aggregated value for male set and another value for female set.How do i go about doing this Please help. MDX Query : WITH set [Male] AS 'Filter ([Customer].[CustomerID].Members,[Customer].CurrentMember.Properties("GENDER")= "M")' set [Female] AS 'Filter ([Customer].[CustomerID].Members,[Customer].CurrentMember.Properties("GENDER")= "F")' SELECT {[Measures].[SALES($)]} ON AXIS(0), {[Male],[Female]} ON AXIS(1) FROM [cubename] Tag: Can i set somehow the package to have the components automaticaly updated?
  - 16
    - help enabling FTS in multiple database Hi all, We have a remote server which runs SQL server 2000 DEV edition. We have 4 databases running in it. Our application needs the feature of Full Text Search in all the four databases. We have installed the necessary services. The problem is that we are able to create FTS on one database but when we try to run FTS on other databases the MSSearch service stops. on restarting it mssql stops. we are not able to do FTS on more than one database. We had tried the same in our local server but it is working fine. The only difference between the two is that the local machine are member server. Has this to do anything with the FTS Meanwhile the eventviewer doent help much, it just tells that the mssearch engine has stopped unexpectedly and it has done this 'n' time. Please help Thanks Smitha Tag: Can i set somehow the package to have the components automaticaly updated?

dancatalin

Help ... i'm lost

I have one custom dataflow component in assembly A with version 1.1.0.0 used in many packages.

The component is now in assembly A with version 1.2.0.0 but not changed.

There is aniway to have those packaged configured in order to automaticaly be upgrated to use the new version of the component

I tried (in this order):

- set the property "UpdateObjects" to true on package (while version 1.1.0.0 was available in GAC) and saved package.

- unistalled the version 1.1.0.0 from GAC.

- tried to reopen package with "Reload and Upgrade" option.

NO SUCCESS

I know that can be an brute way to do it, meaning replace as text in xml ... but i try to find a solution not this stupid "workaround"

Many thanx for any suggestions!

Catalin

PS: Excuse my english.

Top

Re: Can i set somehow the package to have the components automaticaly updated?

DarrenSQLIS

If you change the assembly version, then you have changed the strong name, which is what SSIS stores as its reference, hence it cannot find it. You can change the XML as you mention, or use a publisher policy which allows you to redirect in effect to the new assembly.

My prefererred method is however to not change the assembly version, because hacking the XML is not really sustainable, and having to install something extra for the redirect just seems messy in the types of scenarios we work in for SSIS.

Personally I use an AsemblyFileVersion to track my versions, even down to build level. I use the DtsPipelineComponentAttribute.CurrentVersion property to track functional changes that may require an upgrade. This is built into the SSIS framework, so is easier I find.

A previous thread that may help also - http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=560603&SiteID=1

Top