One or more of your data that you're trying to enter doesn't fit into your target table... I would setup an SSIS job for this and have it spit out...

make sure you're running in the same process (SPID). Put the set Identity_Insert statement somewhere before your insert statement...

set identity_insert tblTransactions ON;

GO

Insert into tblTransactions (...)

select ... from xyz

Are you sure you're running under the right database context?

try it with the [DBName].[dbo].[tblTransactions]

bugg (11/29/2012)

---

Hi All,

I have created an SSIS package that grabs data from an external suppliers mySQL database and then imports into our database.

To get this to work i need to...

make sure the table actually exists. the user you're running it under needs the alter permission on the table. your sys admin can grant that right...

GRANT ALTER ON [dbo].[tblTransactions] TO...

I'm fairly new to XML myself and could use a lot more practice... the code below seems to work but your XML structure has 2 nodes that are named the...

The WHERE statement is invalid... you can't resolve the query to a boolean...

not really clear on why you want this in the where statement... you can put it in the...

I think this is what you mean by quote/speech marks... this works for me in SSRS textbox... either the """" or the chr function works for me...

="Parameter value selected is...

We have schema's owned by local DB users without logins to control access to specific schema objects. From my understanding loginless users work like application roles but we can...

Jeff Moden (11/14/2012)

---

Want a cool sig (11/13/2012)

---

Wow Jeff that is wicked fast... thanks a lot... the time for returning 2600 rows really shows how much faster your method is...

Jeff's...

Wow Jeff that is wicked fast... thanks a lot... the time for returning 2600 rows really shows how much faster your method is...

Jeff's wicked fast script

SQL Server Execution...

Thanks Jeff I'll give it a try tomorrow, I'm not very familiar with cross apply very much. 🙂

GSquared (11/12/2012)

---

What you have there is a spreadsheet, not a database table. Rows in a database table don't have a sequence to them, so there's no way for the...

Backup and restore mostly but some detaching. revlogin works pretty good for orphans but I've had times when some SQL logins passwords didn't come over properly.

Modify the config file on both nodes so that they point to the same instances/packages/file store...

I did this for my previous employer in a 2 node cluster and it worked...