if it's sql agent job, then make sure the service account that is starting the SQL Agent service has the proper permissions.  Also, try putting in a try/catch block to...

you can always use SSIS, but you'll need to install the ODBC drive (Microsoft.ACE.OLEDB)

Without DDL, we don't know what EntityID is.

Try insert into config.entities (ListColumnNamesHere)

select .......

• This reply was modified 3 years, 4 months ago by  Mike01.

All you need to do is check the Column Names in first data row box.  I created a new SSIS package to test it.  Created both source and destination connections...

This will explain why SQL is returning only 6 decimal places.  If you change @weight to this declare @weight decimal(15,13), ten it will return the value

https://docs.microsoft.com/en-us/sql/t-sql/data-types/precision-scale-and-length-transact-sql?view=sql-server-ver15

Jeff,

I don't have a script ready, but this script looks like it does what you want it to do

https://dba.stackexchange.com/questions/106004/moving-a-partition-of-partitioned-table-to-other-file-group-sql-server

Are you running the bcp command as you show it (i.e. spread over 2 lines)? Try to put it all on one line to see if it makes a...

There are a few things wrong with you query. You need to use queryout to get that to work, but remember, that xp_CmdShell is actually shelling out to a...

you can just add row_number() to the select.  Not sure about the global temp table and not knowing the columns though. Do you know how many columns, datatypes, etc???

Great example except for the last paragraph.  No need for that.

you changed the data in your second post. You get 4 rows for Dual Task because you are only joining TaskNameA to TaskNameB. There are 2 rows in...

The error tells you exactly what the issue is.  You are trying to insert a record that already exists in the table.

What version of SQL are you using?  I thought they were both available from 2016 forward.  I copied and pasted my code above and stepped on a couple of fields.  I...

Try this, but I'm not going to guarantee any performance, but at least it flattens it out.   The Code that was here was not copied correctly.  Here is the updated...

• This reply was modified 3 years, 10 months ago by  Mike01.
• This reply was modified 3 years, 10 months ago by  Mike01.
• This reply was modified 3 years, 10 months ago by  Mike01.

With DDL and sample data, I can only guess at using row_number over/partition clause