SQL SSIS imports fail if any of the rows are misformatted. Access simply logs the rows it cannot import and skips them. SQL Management Studio fails the whole operation.
Is there any way...
I need a function build that returns whatever yesterday was, with the timestamp of 00:00:00.000
i.e. Set @variable = CONVERT(datetime, getdate(), 101), with time 00:00:00.000 instead of 15...
Hi There,
I am using SQL Server Reporting Services 2000 and need to create a parameter that will allow a user to enter values separated by a comma (Ex, 12345,6789,54321....). How can this b...
Hi!
I will be migrating a Windows 2003 Std / SQL 2005 Virtual Machine to a SQL 2005 Multi-Node Physical Cluster over the next couple weeks. The two new nodes will be running Windows Server...
I am trying to import a CSV file into a SQL Server database. The name of the file I am trying to import is called BulkImport.csv (in my previous question the file was acutally named DBase_Edit...
SQL 2005 database. Using webform to populate data. Was working not today. Putting in May 30 verses June 9. If i enter a record directly in the database it works fine. From web form not wo...
I receive the above code when I attempt to install the software either from Automatic Updates or Microsoft Updates. I have search all over and have been unable to locate a solution.
I'm a new IT consultant looking for a sound way to streamline my business process- trouble tickets into invoices. I'm thinking of MS CRM 4 with Accounting 2008. Is there a tool or consultants...
Hello Experts,
i got a huge dabatase where its mdf file is about 22G of size!! I need to reduce this size. I was thinking of shrinking the database, it seems that the admin who left set a s...
I'm still not clear on when and why to use multiple primary keys on a table. And, what are the benefits of having multiple primary keys on a table?
I understand the foreign key relationshi...
Hi all,
I'm using a ForEach file loop object to import text files from a directory.
1) how do i parse a filename, extension removed eg (c:\data\Datafile1.txt should return DataFile1)
2) H...
I have this sql 2000 DTS package created years ago by the original developer. The package has been running fine for years but recently the job executing the package has been playing up for unk...
I am trying to run a dtsx package with xp_cmdshell. The account trying to execute the Stored Proc isn't in the fixed admin group.
I have go through and tried to create a proxy account to...
Hello,
I have an old SQL Server database where all dates are saved as CHAR(10) (yyyy-MM-dd). The main benefit of this is that I never had a problem with SQL or the web site confusing the da...
I am trying t o use Foreach Loop container (Foreach Item Enumerator) to do some tasks with each table on the list. I entered the list of all table names I want to work with. I created the vari...
Hi
I am passing a store procedure two integers month and CurrentYear
e.g. 7 = 'July' and 2008
How can i use this as a valid date in SQL?
SQL SERVER 2005 & Reporting Services
Hi, I have a requirement to pass multiple values to a stored procedure. As I have found out there is no array type in T-SQL. Having googled it, the...
Hi,
This question is a carry over from an earlier question on how to update mulitple databases at once. I was told by an expert (simonet) that a trigger would work but I need help with the ...
SELECT movies.movie.value('movie_id[1]', 'int') movie_id
, movies.movie.value('title[1]', 'varchar(max)') title
FROM cs_imovies_raw
Cross apply xml_data.nodes('//movie') as movies (movie)
...
Hi
I am trying to query a linked DB2 server on Sql server 2005 directly but get the following error.
The OLE DB provider "DB2OLEDB" for linked server "MylinkedServer" does not contain the ...
Hi
I've been getting an error when doing a simple select on a table, so i tired deleting the data and i'm getting the same issue
the error is:
any ideas on how to fix?
-----------...
Need to export Excel data to Sql server via VB .
I shall be able to select Excel File and sheet via vb and i want to export to sql table
Hello, I would like some assistance on importing a delimited file that has a header and data section. After reading a few posts on EE, I believe importing the data into a 1 column table and t...
Hi All,
I have to store Images related to customer . Now I am confused which way should I follow. either I store it on the hard disk and save the path in database or I directly store it...
Good Day
Experts:
I am interested in setting the column width of a column in a SQL query. For example:
Select TestTitle as 'Test Number' from Order
Is it possible to specifiy a co...
