Can DTS automatically create primary key values upon export?

I have two practice tables I have created and want to export the values of one into the source table. I want to know if I can export into a table and have the destination table automatically give a primary key value to a record? I haven't been able to figure this out even after fiddling with the "Enable identity insert" checkbox under the Column Mappings tab. I have created source tables with and without primary keys and neither works because of the fact that I need to have a value for a primary key in order to INSERT into the destination.

Do I have to copy the source records into a staging table and assign the PK values myself by hand? This can't be the answer.

ddaveyou have to clear the enable identity insert checkbox if you want to allow the identity values to be poped by you
adding a check indicates that you want to programmatically provide the identity values
try clearing it and setting your identity on the column|||Thanks. I did do as you mention but I also had to create the destination table with a Primary Key with an identity field that incremented automatically by 1. I also had to create a source table that had NO primary key field. I then imported the source into the destination and the incoming rows were assigned Primary Key values in sequence.

ddave

you have to clear the enable identity insert checkbox if you want to allow the identity values to be poped by you
adding a check indicates that you want to programmatically provide the identity values
try clearing it and setting your identity on the column

Can create login but cannot connect (sa doesn't even work also)

Hi,

Please direct me to the right forum if this is not the right one.

Upon installation of SQL Server 2005, I opened the SQL Server Management Studio, connected using Windows Authentication and went to the security node in the tree. I created a log in called "TestLogin". I restarted my server just to make sure everything took and when I tried to log in using TestLogin via SQL Server Authentication, I get the below error. I have mixed mode enabled as well as named pipes. I am not sure what the issue is or what to try next. I even get the same error when trying to use "sa".

Thanks,

- Joel

TITLE: Connect to Server

Cannot connect to TestServer.

ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

BUTTONS:

OK

Can you check the SQL Server errorlog and copy the last errors reported there?

Thanks
Laurentiu

|||Hi. I had the same problem. Username is case sensitiv and the error message is odd...

Can create login but cannot connect (sa doesn't even work also)

Hi,

Please direct me to the right forum if this is not the right one.

Upon installation of SQL Server 2005, I opened the SQL Server Management Studio, connected using Windows Authentication and went to the security node in the tree. I created a log in called "TestLogin". I restarted my server just to make sure everything took and when I tried to log in using TestLogin via SQL Server Authentication, I get the below error. I have mixed mode enabled as well as named pipes. I am not sure what the issue is or what to try next. I even get the same error when trying to use "sa".

Thanks,

- Joel

TITLE: Connect to Server

Cannot connect to TestServer.

ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

BUTTONS:

OK

Can you check the SQL Server errorlog and copy the last errors reported there?

Thanks
Laurentiu

|||Hi. I had the same problem. Username is case sensitiv and the error message is odd...

Can a job trigger itself upon receipt of an email?

Hi all,
I have a SQL Server Job that I would like to run when I receive an email saying "Data is now ready to be imported to SQL Server" ?
Is there a way to accomplish this.
- Vivekgot a mapi compliant mail server laying around. you might be able to do this with sqlmail.

OR

i have never written too much VBA for outlook (mostly access and excel) but you maybe able to write a rule that drops this email in a certain folder. Then, and I am not sure if there is an event for new mail but there probably is, you can probably make a db call in that event. you would have to leave your mail client open and your computer on.|||Check out xp_readmail in SQL BOL. Basically, you would need to put this inside a SQL Job that executes periodically and then use xp_readmail to "answer" the inbox and trigger your job.

Having said all that, I will say that SQL mail only ever caused me grief and heartache. Go Database Mail (SQL 2004)!

Regards,

hmscott