I need help on how to append data in an excel spreadsheet to a sql server 2005 datatable.
Thanks
I created one SSIS package in the following location "C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\AmbulkMigration\AmbulkMigration\Package.dtsx. When i run ...
Hi, I am successfully able to set report parameters and use them in the data parameters on a main report I want to pass all the values now to the drilldown report. I went to the properties of ...
Update statement in T-SQL
I have a table TransactionTable which has six columns,
ID - this is the primary key,
Region
RegionValue
Code
Date
Area
I have another table Translation
...
I need to build an aspx page to allow uploading an excel file and import the data into SQL server 2005.
I hear SSIS package is the best way to do the job. Since I am new to SSIS I have some q...
I'm installing SQL 2005 standard edition under server 2008 standard 64-bit.
However right in the beginning I get following warning messages:
1. - IIS Feature Requirement (Warning)
* Mic...
I could change the default database file location to other drive (not c: drive) for user databases. But how to change the default database file location to other drive for system databases dur...
Hi,
I have a query regarding the permissions. I dont want to allow delete, drop and alter for a user, but he can insert and read the data at the same time he should be able to execute store...
The production DB is on a SQL Server 2000 box, but all this was done on a backup that I restored to a SQL Server 2005 box.
I have a table that stores images (we'll call it img_table) that s...
I am attempting to design an SQL query (for SQL Server 2005) which will return all the records from a table of customers where there have been no activities logged in the last three months.
...
I've installed report server but can't open the page in a browser. I get the following error:
Cannot connect to the configuration database. For tips on troubleshooting this error, search fo...
I have one table - categories. This table has a CategoryID and a parentID. The parentID denotes the parent of a a category (which is also a category). Of course this parent can have another pa...
I am moving my sql database from one server to another at a different hosting company.
In order to connect, I had to change the owner of the tables, functions and stored procedures from
oldo...
Hello Experts,
Can some provide me the T-SQL I would need to copy a particula Table in one database into another. It needs to only copy the table schema, not any row data.
I don't want to ...
Hi experts - found a weird thing today and need to know why this is happening.
Have an environment that has 2 instances of SQL Server (1 SQL 2000 and 1 SQL 205). Have placed a copy of the ...
Hi
I've got a really irritating problem that I just can't seem to trace. I'm new to SSIS, as we've just moved from SQL 2000 to 2005.
I have a pipe-deliminated flat file I want to import...
Hello:
I've this line and I want to capitalize the first letters in the returns in the column X
"SELECT X FROM form_lists WHERE form_name='pres' AND sec='ps' AND form_field='site' ORDER ...
Hi, thanks for clicking...
I have 2 computers:
My primary computer is a desktop with Windows XP on it, which has SQL Server 2005 Developer Edition on it. This computer has a SQL databas...
I am trying to run the dtexec command in the command prompt and keep getting a failure message.
It looks like it is running part of the SSIS but when it comes to the import it fails.
Any id...
Hello,
What I am attempting to do is allow a client to select a group of entities and submit a percentage for a price increase. I have attempted to do this with a case statement and cursor b...
Hi,
I have a number databases.I donot want the ldf file to grow.Usualy i attach and detach them to reduce the log file size.Once the new log file is created i delete the older one.While att...
Hi Experts
I need some help writing a t-sql statement.
I have two tabels sentmessages and missingsentmessages,
they both contains three fields, orderid as int, seqno as int and createdat...
Trying to compare two date fields.
Field01 is a smalldatetime type with '2008-03-24 00:00:00' as an example.
Field02 is a datetime type with 'Apr 23 2008 1:15PM' as an example.
When t...
I'm using an FTP Task to Receive all of the files from an FTP Site and transfer them into a Working Folder.
Everything is working fine, however is there a way to determine how many files we...
I'm trying to create a linked server to Active Directory in SQL Server 2005 but I seem to be missing something in the sntax that is preventing the OPENQUERY from working.
This is my script ...
