Search results for query: *

Hi Alex, Firstly, thanks for your help. Now I can see the file and select, but when I click on the transform button it says: Microsoft Jet Database Engine could not find the object and Error calling OpenRowSet on the provider. Any suggestions?

Hi Everyone, This may be an easy question, but I'm trying to load a .dbf file into a SQL Server Table and when I try to import it using the wizard it's asking for a DSN. I usually import text files or Excel spreadsheets (which is usually what I open this file with but this time it exceeds the...

Hello, I have a DTS package that was set up to import data into a table. Well, the table structure was modified and an identity column was added. Now I get an error when running the package that says that a null value cannot be inserted into that field. I know the identity field is supposed...

Hello Everyone, I have a user set up with a SQL Authentication login and she has forgotten her password. Is it necessary for me to reset it (if so how do I do that) or can she just go in and change it by double clicking on her login name and typing it in?

I think I've figured out what I need to do. Thanks!

Hello Everyone, I have the following while loop that is taking several hours to run. Does anyone have any suggestions as to how to optimize the query so it will run faster? Currently, I have an index on the #test_data table based on the [ID] field. Any suggestions would be GREATLY...

Well, it's not an access database, but another SQL Server and I am logged in as myself with System Administrator permissions. I can add the linked server with no problem, but there are no tables and views and when I try to query that server from the one I'm linking it to (using the correct...

I do have permissions, and I'm getting an Error: 7399

Hi, I'm trying to add a linked server and when I add it using Enterprise Manager, it adds okay, but there are no tables are views listed under the server. Does anyone know how to correct this?

Thanks Rhys666. I didn't know how to parse the string in order to "make" it look like a date. That works! Thanks for your help.

SQLDenis when you say change it to string, what do you mean? I don't understand why I don't need to use the Date String function? Also is there a way I can use a function in VBScript to change the source column from yyyymmdd (not a date) to yyyy-mm-dd to go into the datetime field? Please...

I'm not sure I understand. How do I make sure that as it's loading it doesn't put in the 00000000 and that it recognizes 20041011 as a date field? If I don't tell it how to handle these things as it's loading I noticed I got errors in both those cases.

Hello Everyone, I am trying to load data from a text file into a datetime field in a table in SQL Server. The text file contains values in the format yyyymmdd so I know I can use a Date String function in order to load them in the format yyyy-mm-dd. The problem is that I have some values in...

Thanks SQLDenis

Hello, Does anyone know how to pass values from a table as parameters to a stored procedure? For instance I have a stored procedure: sp_Test_data(@db_name, @clientcode) Then I have a table called Values that looks like the following: DB Client DB1 Client1 When I execute the...

Hi Everyone, Is there anyway to have data from a table be automatically exported after another action takes place. For example I have a trigger that updates one table when another table is inserted into. After the table is updated, I want that data to automatically be exported to a csv file...

I am VERY new to SAS, and I need to run some descriptive statistics on a data set. I have a column that contains different drugs and a colum that contains the dosage of these drugs. So my data looks like: Drug Dosage Tylenol 5 BC 6 and I need to know stats about the dosage by...

You could create a stored procedure for the script and then create a job that runs that stored procedure and schedule it to run at whatever time of the month you would like.

Hi All, I have a table with a field called 'Insert_UserId' and I want it to be automatically populated depending on who is currently inserting something into the table. Is this possible?

Thanks Gez. Now I've specified my DSN, but how do I get to the file I'm trying to import?