Answer Questions

• MrNielsen Take Id-s From returned rows, and make a new SELECT

  Hello, I have a question on sql stored procedures. I have such a procedure, which returnes me rows with ID-s. Then in my asp.net page I make from that Id-s a string like SELECT * FROM [eai.Documents] WHERE CategoryId=11 OR CategoryId=16 OR CategoryId=18. My question is: Can I do the same in my stored procedure (without sending it to page) Here is it: CTE is the WITH construct: ;WITH CTEname as ( <select query> ) select * fro ...Show All

• GrkEngnr deleting sql server 2005 deployed packages?

  Hi there This is probably a dead easy question. I have deployed 3 SSIS packages to sql server, but now i cannot find any option anywhere to delete them How do i delete SSIS packages from the SQL Server instance they were deployed to Thanx   KirkHaselden wrote: Oh, and, you're welcome for the post too Sean. :) Oi, I'm claiming all the credit for this one :) Sean, Kirk has posted on this: http://www.sqljunkies.com/WebL ...Show All

• BBB Evaluation to full Licences

  I have just installed MSSQL 2005 enterprise evaluation, I would like to start storing data on it, but I do not want to loose what I store. So when I do license this database product, is the data simply transferable from the evaluation edition to the Licensed MSSQL 2005 enterprise edition Thank you in advance. Yes, you can either upgrade to a licensed SKU during the 180 day trial period, or if the Evaluation Edition expires before y ...Show All

• Brice PRUNIER Cross Package Configuration Files

  Configuration files are working great for me when I run a package "stand-alone". However, when one package executes another package I am having problems. Assume the following two packages (each having connection info in a config file): foo (with connection A - contained in foo.config) bar (with connection B - contained in bar.config) The package foo executes package bar. Where would I have to modify the connection information for connection B, s ...Show All

• Lina María Villa Data Comparison Question

  I am not sure if this is the correct forum for my question but I will give it a shot. I want to be able to create a dataset from an ODBC datasource and compare it to existing data in my SQL DB. If there are changes (inserts/updates/deletes) I want to raise seperate events for each row state. Is this possible to do with SSIS/DTS or am I on the wrong track with what I am trying to do The article I linked to shou ...Show All

• kiagenwa Triggers

  Hi, i an new here. I just started with Sql Server 2005 Express. But my problem is not in technical issues, but programming. Now, to problem. I have few tables, Meas, Analog, Discrete, Acc and Terminal. Meas is main, have some field of it's own, one primary index key, and on foreign key. Foreign key is coming from Terminal table. Terminal table is stand alone, cause it has no other connections to any other table in this model. Analog, Discrete ...Show All

• Ricky Vega send mail task error

  Hi All, I am trying to use Send Mail Task to send mails within my package and I get the following error. "The server response was: 5.7.1 Unable to relay for test@mail.com". Can anyone help me on this Thanks Thanks for all the help Darren, I dont know If I fully understood what u said but I think what I was looking for. Thanks a Lot Talk to the perso ...Show All

• TLJohnson SSIS remote connection failing ... local connection OK

  I'm getting "Access denied" error when I try to connect to SSIS from my desktop (Database Engine is fine). I'm a member of sysadmin within SQL, as well as an administrator on the server. I don't have any problem when I log on to the server directly via Remote Desktop and open SSIS. I went into the surface area config tool, and I see that Database Engine and Analysis Services both expand and have a sub tabs to enable Services and Re ...Show All

• ALepage SSIS on it's own server vs. running on same server with SQL.

  Does anyone have a feel for the pros/cons of running SSIS on it's own server vs on the same machice with your data warehouse We have a very large number of VB routines, DTS packages and SP's that parse and load daily sales data from 3000 stores to our primary data warehouse, which is running on a fairly beefy box connected to a SAN.  This data gets pushed to other SQL boxes for end user access.  Due to the complexity o ...Show All

• Bill M creating a database, tables, records, and fields in a Sql server 2005 express

  I am at my wits end as to how to do this. I have downloaded Sql server management Studio and tried to create a database but I can't figure it out. There is an almost nonexistant help file so I am lost as to how to start. I have succeeded in looking at some system databases but that is about the extent of it. Can someone show me the proper procedure Am I using the wrong tool Thanks, Paul Thanks, Steve. That was ...Show All

• Dan Spalding How do create table from Excel (based on Excel column name) and import data from it?

  l've the following situation, l've some excel files controlled by Vendor which changing frequently. The only thing does not change is the header name of each column. So my question is, is there any way to create a new table based on the excel file selected including the column name in SSIS So that l can use the data reader as source to select those columns l am interested on and start the integration. Thanks. Regards, Yong Boon, Lim p/s : The ...Show All

• mafc Deployment error -- Incorrect ImpersonationInfo object

  Hi, I'm new to SSAS 2005 and I'm walking through the Analysis Services tutorial in the online documentation.  So far so good until when I wanted to deploy the project.  The error is Error 1 Parser: The syntax for the ImpersonationInfo object is incorrect. If the ImpersonateAccount value is used for ImpersonationInfo, then the Account property cannot be empty.  0 0  I don't know why it asked for Impersonati ...Show All

• jamvir Connection string for SqlCeConnection

  Which format is assumed for connection string for SqlCeConnection In help topics there are only examples like this:  ... Data Source = 'SalesData.sdf'; ... But this example is intended for SQL Server 2005 Mobile database located on desktop computer... I need to custom data load from desktop to device and vice versa, so I did this: string SqlMobileConnString = "Persist Security Info = False; Data Source = Mobile Device\CF Card\mBase.sdf ...Show All

• Thanh Nguyen Subreport error is been displayed in Browser

  Hi, I have a Parent report with two sub reports. The Parent report returns generic invoice information and sub reports take the invoice number from the parent as a parameter and return coding lines for the invoice and location information (who has recently updated the invoice). If the invoice contains coding lines and location information the sub reports display fine. If the invoice does not have coding lines/location information then I get ...Show All

• dalek9 Mapping bigint variables

  Someone asked this earlier, but the answer did'nt seem to be right (anymore). I am having some trouble in mapping a bigint result from an ADO.NET resultset to a variable in SSIS. Whatever variable data type I tried, except for the Object type, I get the following error message: Error: The type of the value being assigned to variable "User::<variable name>" differs from the current variable type. Variables may not change type during execut ...Show All