Answer Questions

• YT Creating...Connecting... i'm missing something...

  I'm creating a data storage program in VB 2005 Express. it works perfectly, and installs and everything, but it stores the database in an obscure data file in the user's local settings folder as an mdf file. once that's created, i want to create an access front-end to view the data, but can't get it to work... when i try to create linked tables, i establish the connection to sql server (2005 express) through the wizards, but the database i want ...Show All

• AllyJarrett Huge issue with the Lookup problem

  Hi, I have Script Component in the Transformation phase that returns me values like NO, OTH, OWN (comma separated string coded value) Now I want to use the Lookup component (preferably or any other task really) to get the description by looking up a table in another database. So eventually my string needs to look something like this None, Other, Owned (comma separated string decoded value) I tried using the Script component again to do this, but ...Show All

• Chad C. exec statement

  Hi all I used the create procedure proc1 as begin try exec ( begin try 'select * from '+@tablename1 if @@rowcount=0 raiseerror("hello",16,1) 'select * from '+@tablename2 end try begin catch select error_message() end catch) end try begin catch end catch in my stored procedure beacause the name of tables not specified for me now my questions: 1. Is there beter way than using ...Show All

• jbassmanp SSIS will not start after SQL Server 2005 SP1 upgrade

  Hi guys, I have experienced a problem with a SQL Server 2005 SP1 upgrade, where hotfix.exe reported an error during the SSIS component upgrade, and then the SSIS service would not start back up. I have since attempted an additional SP1 upgrade on the server, which completed successfully, however the SSIS service still will not start. The server is running Windows Server 2003 Standard Edition SP1 with SQL Server 2005 Standard Edition (x86), wh ...Show All

• Shiamak How to Store System Variables in DB?

  Hi, I want to store the System::StartTime in my Integration Table Log. Please guide how can I use this in my Execute SQL Task Block. I write this SQL Statement: INSERT INTO CMN_tblIntegration VALUES ('HRM_tblParty', ) Which the is for the parameter. I go to parameter mapping tab and map the System::SatrTime to parameter0, but the package fails to run. I also changed the to @IntDate and also changed the parameter name but the error was the ...Show All

• swaroop.m How to join a decendent Table on Parent Table Row?

  I have one main Table "MainTable" which I want to relate with "subTable1, subTable2, ..." in such a way that: "ith subTable" have to be related/joind on "ith row" of the "MainTable", "jth subTable" have to be related/joined on "jth row" of the "MainTable" and so on... What I want Actually I want that when ever I delete a Record in the "MainTable ...Show All

• lode Move data from backroom to frontroom

  I need to know the quickest way of moving/copying data from a backroom/import/qualitycheck database to the production environment. The databases reside on the same server instance, the tablestructure is identical and I'd preferably like to use T-SQL procedures, rather than DTS/ETL. Can I make use of bulk loading, openrowset or ... from one table to another Hi Eric & Robert, there are ways of using transac ...Show All

• advind Question on Integration of SSRS 2005 Graphs into Sharepoint

  I have been assigned to work on a dashboard (see jpg below) which will hook into our Intranet on SharePoint 2003.  I have a few questions as in teh approach and what is possible by creating charts through SSRS 2005 report(s): http://photopizzaz.biz/dashboard.jpg 1) what technique to use to show all 4 graphs simultaneously on the same page in SharePoint Webparts   Is WebParts the best way here to accomplish this 2) Ev ...Show All

• corndish Change an Access Database to SQL Server

  I designed a database that works well in Access and I want to get it to run in SQL Server. How do I learn how and what to do to change over to SQL Server This is most likely to be either a security issue (invalid security settings used when trying to connect to SQL Server), or a client/server connectivity issue (related to network connectivity, but probaby not in your case, as you are using Shared ...Show All

• Compound_G "product level is insufficient" message during flat file import

  I'm using the import wizard to create a new table from a flat file source.  The table gets created but no data gets copied.  What's wrong   Here's the report: Operation stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection (Success) - Validating (Error)    &nbs ...Show All

• MickBenner temporary table not dropped after user disconnected (SQL2005)

  Hello all, We are developing some stored procedures on the SQL2005 server. All of them use local temporary tables to store temp data. Due to some errors in the procedures, run-time errors are produced and the procedure stopped. But after user disconnected, these temp tables are still exist in the tempdb and cannot be deleted. We can only view these objects using SA account in tempdb.sys.objects view. I would like to ask if there is any meth ...Show All

• sjimmerson No grouping?

  Hi to all! To count(something), it is usually required to use a group by function, however, that is not applicable in this case: I would like to select records that have similar values for 'col2' and 'col3', given a certain 'col1', and how many records each 'col1' returns. The following example hopefully makes it clear. The table: Col1 Col2 Col3 ------------------------ s1 A B s1 C D s2 A B s2 C D The result should ...Show All

• roastSpud Stored Procedure

  Hi, im doing a stored procedure, it's for changing the data type of several columns, specifically the number of decimals, so i want to pass this as a parameter, but i cant use this in the alter column command, example, im doing this create procedure XYZ @decimals int as alter table XYZ alter column XYZ decimal(18, @decimals) go any idea how to make this work you have to use dynamic SQl create procedure X ...Show All

• Maksim7858 function to display the numbers 1-12 in detail of table

  I have a table and in the table detail section it will never have more than 12 rows;therefore, I want to have the numbers 1-12 listed sequentially on each row.  For instance: Row   Data 1         record1 2         record2 3         record3 .............................through 12.  Any help i ...Show All

• nietzche SQL Express user permissions?

  I'm trying to build a web application using SQL2005 Express and Visual Studio Express.  It all works OK on the local machine, but gives an error "Login failed for user xxxx\ASPNET" when used remotely.  I can't find where I can set login permissions for SQLServer 2005 Expresss - can anyone help, please Thanks John You seem to be getting two errors: Error 4064 is "Cannot open user default database. L ...Show All