Recent content by bschmitz

Thanks for the help dodge20. I thought that might be the case but hoped I was wrong.

I still get a syntax error. BOL uses the keyword alter.

That gave me an incorrct syntax error also.

I was able to make it work using the Microsoft Data Link. Thanks again!

I have an integer field with data that I am trying to change to the Identity field without losing any data. I have to do this using the osql utility. When I run the statement "Alter table table_name alter column column_name int identity", I get the following error "Incorrect...

per my last reply - I was wrong. I could not create the package because SQL could not recognize the servername of the server where I need to run the package, as they are not connected. I will continue to research.

Thanks nowayout,tbroadbent. I created the DTS in my EM. Copied it to the server where I needed to run it. Ran it from the command prompt. Worked like a fullback draw on a prevent defense.

Can anyone point me in a direction as to how to import data from either a text file or a spreadsheet into an existing SQL table using the osql utility. Thanks in advance!

FYI - I had to copy the .dat file to the c drive of the server that houses our SQL DBs. I was trying to do it across a network.

Thanks garyd1 for the help. A colleague of mine has shown me the light.

It opens up as a lot of square boxes and symbols.

I was sent a .dat file and have tried to open it with EM using both the Import data wizard and the restore DB wizard but neither wizard gives me a source option of .dat. Is this possible? Am I doing something wrong? Thanks in advance for your help.

Thanks squslan! I was able to use CHARINDEX and SUBSTRING to accomplish my task.

This would definitely work for all data that I knew the number of characters I wanted. This data is space delimited but the lengths can vary. Thanks!

I have a 1000 character field in a table. I need to pull out different parts of the string from each record and insert them into different columns in a new table. I was thinking that I would create a DTS package to do this. I am new to SQL and find myself struggling with this. Thanks for the...