Answer Questions

• pompoko Connection string from outside

  Hi there!! I want to make a package and pass connection string from outside say through .ini file, so that I can put package on any system and use some external source to pass connection string. How do we do this in SSIS Rahul Kumar, Software Engineer, India When you go through the Package Configurations Wizard choose the ConnectionString property of the ConnectionManager you want to configure. At runtime it will try and configure that property for you. You don't have to manually set it. Hi Suresh Yeah this is fine,we can assign configuration settings but still I am scratching my head how to change connection string in connection manager If you de ...Show All

• REspawn Multiple table update

  Hi There I am using tsql in Sql Server 2005. Is it possible/how do i update multiple tables in a single update statement. I want to do something like this. UPDATE A, B, C, D SET A.Col1 = , B.Col2 = , C.Col3 = , D.Col4 = FROM TableA AS A JOIN TABLEB AS B ON B.ID = A.ID JOIN TABLEC AS C ON C.ID = A.ID JOIN TABLED AS D ON D.ID = A.ID Basically all the tables are related, i want to update values in all the tables in a single update but i just cannot seem to get the syntax correct, BOL also has no example of multiple table update so i am not even sure if this is possible. Thanx you can not update multiple tables in single update statement . what u can do is put all these differe ...Show All

• Blast Getting SQL result in a variable

  Hi there I have a global variable say cnt in SSIS package, now I want to get total number of rows from a table say emp in that variable cnt. how do we achieve that thanks and regards Rahul Kuamr Hello, found this post and am hoping that you can help with assigning a variable with an Execute SQL Task. My task runs, but the variable doesn't get a value, stays blank. I'm trying to retrieve a string value from a SQL table called tblSys_Config. There's only one row in the table. The column I want is called is an nvarchar(3) field called Config_Code. I've defined a user variable called TestVar with type as string. I've set up my Execute SQL Task with a SingleRow result set, and the SQL ...Show All

• Kevin Rodgers SQL Express Replication and problems accessing data after replication

  Hi, I have a VB.net app that access a SQL Express database. I have transactional repliaction set up on a SQL 2000 database (the publisher) and a pull subscription from the VB.net app. I use RMO in the VB app to connect to the publisher. My problem is I am getting some strange behaviour as follows - if I run the app and invoke the pull subscription it works fine. If I then close my app and go back in, I can access my data without any problem - If I run the app and try to access data in my SQL Express database it works fine. I can then close the app, reopen it and run the pull subscription it works fine however....... - if I run the app, invoke the pull subscription (which runs fine), and then try to access data in my local SQ ...Show All

• AShukri Multiple selects on PArameter drop down

  I have a parameter dropdown as USERID. I want a functionality that the user can selct multiple userid's to show more than one record as output for comparison purpose. How can i achieve this multiple select (i.e cntrl+click) within parameter dropdown. Thanks, Kiran. This did not work for me. I shifted to 2005 and implemented it. Thanks Hmmm... You could try changing the parameter type to string and make your data query use 'IN', then have the user type a comma delimited list. I haven't tried it, but you might be able to get it to work. Jarret Sorry, I had assumed that you were running RS 2005. In Reporting Service ...Show All

• Kevin Stephens Error Locating Server/Instance Specified

  I am having a problem connecting to my sql server express instance from a remote computer. I continue to get the above mentioned error. If I connect for the localhost everything works fine however when I try to connect from a different computer on the LAN it gives me this error. I have turned on remote access and still no luck. Any ideas Any help would be appreciated. Hi, Ensure their is no network congesion between PCs you are connecting, are they on same network segment ! do you get ping acknoledgement when you ping your sql express from remote pc i would suggest you to refer http://support.microsoft.com/kb/905618/en-us also. Hemantgiri S. Goswami Odds are you haven't created exc ...Show All

• HopeDreamsComeTrue Strange Replication / Registry error. Need help.

  Hello, I am trying to sync (using SQL Server 2005) and have set the Interactive Conflict Resolver to be used, however when I sync it fails with this error: The merge process failed to get correct information about the Interactive Resolver component from the registry. Verify that the registry exists and that the path is correct Anyone ever see this before and know how to resolve it I've looked all over. Thanks guys, Chris Hello! Yes, I do have it installed and running. Thanks, Chris Do you have Windows Synchronization Manager installed and running Iteractive Conflict Resolver requires it. From BOL: Note:  Interactive Resolution requires Win ...Show All

• DanBaumbach Improving conversion performance

  I have a varchar(max) field that is on its way to a Term Lookup task, so it requires conversion to DT_NTEXT before it gets there. The conversion is taking a really, really, really long time. In my current example I have about 400 rows. Granted the length of the varchar(max) if I 'select max(len(myColumn))' is approximately 14,000,000 so I understand that I'm moving a lot of data. But I'm on a x64 machine with 4 dual core processors and watching Task Manager I can see that I'm only using 1 core out of 8. Anything I'm missing that can speed this up Thanks, Frank Have you tried doing the conversion in the SQL, rather than SSIS. How slow is it running you might have a bug. If you can produce a r ...Show All

• kcchesnut Breakpoints in script component

  Does anybody know if the breakpoints are supported in the script component I've got a script that I want to debug and make sure it's doing what it should be but everytime I set a breakpoint it loses them when I click ok on the script editor. I've tried setting precompile to false but thats not working. What do I need to do to be able to use breakpoints Saitham8 Saitham8 wrote: why The usual time/resources limitations - did not have time to implement them. why if breakpoints in script components are disabled how are we supposed to debug our code Nope, breakpoints in script components are not supported in this version. Only script tasks support bre ...Show All

• Tibia Rules Connection woos

  Just the other day I have not been able to connect to SQL Server 2005 Express Edition. NOTHING has changed. All I have noticed is that in the Surface Area Configurator the Local Connections only radio button it selected. So I try selecting the Remote radio button and Apply and Ok and then exit the Surface Area Configurator program and then come back in again and the Local Only is selected. Is this normal behavior Is Remote connections allowed or not How verify Thanks. hi, Expressman wrote: I installed the MS SSEUtil program. 'sseutil - listsrv' command *without quotes' doesn't show any server running. lolol Yet my program can access the database using the 'computername and instan ...Show All

• scottt40 Link with an AD

  Hi, I'm looking for a way to catch Active Directory's logs (Security, Application and System) in a SQL Server 2005 Database. How to create this link with my AD Thanks a lot Pascal (Sorry for my english) ...Show All

• Bill Cumming Sum Buildin function is not considering negative numbers!

  Hi! i am using the SUM buildin function of AS2005. it is not considering the negative numbers. There are some settings am I forgetting I am just adding, under measures, a new measure with aggrergateFunction=SUM and the database field "AMOUNT". In the db the amount is negative as well.... Thx mcrisf Mcrisf, SQL Server 2000 is where I have seen this issue. The data entered the table using an Oracle ODBC driver. You can test by executing the following query (replace "value" with your column name): select value, 1*value, cast(value as VARBINARY) from table An example follows: select top 5 quantity, 'Times1' = 1 * quantity, 'Varbinary' = ...Show All

• Cezary Error during merge web sync

  Hello,    We have 5 subscribers trying to replicate via web synchronization. Two of the subscribers get the following message and the other three are fine. Any ideas on what the problem is or where to troubleshoot Thanks in advance. John Error on client output: The format of a message during Web synchronization was invalid. Ensure that replication components are properly configured at the Web server.   Mahesh, This is a web server box that only has two virtual directories. Both are used for replication. One for sqlexpress replication and the other for WM 5.0 devices. We get successes from both sqlexpressurl/replisapi.dll diag and wm50url/sqlcesa30.dll diag, with the ex ...Show All

• Adhvika SSIS, BIDS and Temporary files

  Why are some SSIS files, generated by the Import/Export Data wizard put into the local users temp folder Why are these not compiled with the package when the solution is built Is there some setting I am missing This architecture is kind of silly, as the server always needs access to the temp folder on the local machine to run. How can I get these temp files packaged with the rest of the package and deployed to the server so the server can run independent of the machine I develop the package on Thanks, Jeff I think Jon is right. The reason they're put into c:\temp is because they're temporary. -Jamie Update: It appears that this temporary file behavior only happens when th ...Show All

• asalcedo Configure Report services

  HI, I am having SQL Server 2005 express edition, how can i configure report services VSB, Take a look at this document from Microsoft. http://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/UsingSSRSwithSQLExpress.doc Hope this helps. Jarret This thread has been moved to RS forum (originally posted in SSIS) Try the Reporting Services forum. http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=82&SiteID=1 ...Show All