Search results for query: *

I have a database that is using the Security.mdw for user login control. What was happening a few weeks ago was that each time the main database was open, the login prompt would appear and usually the username of the user who is opening the database would appear. For some unknown reason, this...

So I've been trying to tackle this procedure and I just don't see where the error is coming from. The error I get is "Numeric or value error: character to number conversion error". I'm a SQL Server guy and this was originally in SQL Server, but this other project I'm on is having me convert...

Ahhh. Figured it out, but don't know exactly why. I put parentheses around the @SQL in the EXEC statement. Thanks for the help.

I just tried the new FROM statement and I still get the same error. Here is the error: Could not locate entry in sysdatabases for database 'SELECT sap_ShipToCustomerID AS ShipToCustomer, sap_BillToCustomerID AS BillToCustomer, sap_InvoiceDate AS InvoiceDate, sap_Amount AS Amount...

I am trying to create a stored procedure that outputs records to a table. Each day the sproc is run, I would like it to output it to a table name and concatenate the current date to the table name. This is what I wrote, but the error I'm getting is when it's building the SQL select statement...

Sorry if this is common sense, but I'm new to DTS here. I was wondering how do you go about backing up all the local packages that I've created? I can easily backup the databases I have, but seeing that packages are outside the database area, how can they be archived? In case SQL Server...

I have an ActiveX Script task that uses recordset to open up a table within a database. To facilitate not having to go to all my packages and edit the connection strings, I want to use a UDL file that stores the connection string...this way I only have to change the UDL file when going to...

I was thinking of just using an INSERT statement, but again, I need to insert 127 fields. Can an SQL statement be that long? In other words, my INSERT statement would look like: INSERT INTO TableB (FieldName1, FieldName2, FieldName3...FieldName127) SELECT SUBSTRING(FieldName1,2,6)...

I'm attempting to parse out a column of data in a table(Table A) into another table(TableB) that has all the fields. In total there are 127 fields that are going to be populated. Can I use a standard SQL INSERT statement to do this or will I reach a max limit on the size of my SQL statement...

Okay, I was able to get it into a staging table using bulk insert and all the data actually placed through into a text datatype. Now I think my problem is parsing it out into the 187 fields I need it to be in. I'm not sure I can use such a large SQL statement to do this. Any thoughts on this...

I have a fixed length text file in which 1 rec has many fields that stretch to a column length of about 10,000. The DTS wizard bugs out at about the 3700 position number and it doesn't allow me to designate a field beyond that; nor can I remove one of the automated field designators. Also, I...

Ah yes it worked. I figured out why it didn't work before...I didn't have "GO" at the end of each command. Thanks!!

Sorry, forgot to also mention that I am trying to alter the columns to not allow null before I assign the columns as a composite key. I just can't seem to get the right coding for it to do that. There are no null values in my existing column so I don't have to worry about updating any values.

I have an existing table in which I want 2 fields to make a composite key. Both fields are set to "allow null". When I use the "alter table" and add a primary key constraint, I keep getting the error - "can't create primary key on nullable column. Any suggestions? Thanks

thanks stew, it worked. Funny how I use that transfertext method quite a bit, but never knew it had the acLinkDelim. I guess I just overlook it all the time. Thanks again!!! Rye

Stew, The coding you have is if I wanted to import a text file into Access. Instead I just want to create a linked table. It's easy to do using the wizard - File, Get External Data, Linked Tables, select my text file, and tada, I have a link to my text file. I want to do what the wizard...

How do I programmatically create a link to a delimited text file using a defined file schema?