Thanks for taking the time to write the article. Given the alternatives I strongly prefer employing a SQLCLR for implementing file system access from T-SQL. However, in this case a...

The database will not enforce it but your data supports the ideas of using rpt_id as a unique key.

So, just keep track of the rpt_id values you have already processed...

preethi.kaliyamoorthy (5/14/2015)

---

Hi,

Here is the DDL of the table.

CREATE TABLE [dbo].[t_adr_rpt_doc](

[rpt_id] [bigint] NULL,

[rpt_doc_tx] [varbinary](max) NULL,

[lst_upd_ts] [datetime] NOT NULL,

[lst_upd_user_id] [char](8) NOT NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Index:

CREATE CLUSTERED INDEX [idx_adr_rpt_doc_01] ON [dbo].[t_adr_rpt_doc]

(

[rpt_id] ASC

)WITH...

If you setup Step 6 the same as Step 5 where it is a call to PowerShell.exe passing a script location on disk instead of a PowerShell step type with...

Can you script the entire job out and post it here?

Post the DDL for the source table including the key and index definitions.

IsTransferred is not...

When you run in a job it uses a service account to run the commands. Ensure your service account can access all the resources needed by your script.

Stephanie Giovannini (5/6/2015)

---

CREATE TABLE test_numeric_parent (

thekey NUMERIC(10,0) NOT NULL PRIMARY KEY

);

CREATE TABLE test_decimal_parent (

thekey DECIMAL(10,0) NOT NULL PRIMARY KEY

);

CREATE TABLE test_numeric_child (

thekey NUMERIC(10,0) NOT NULL,

x INT NOT NULL PRIMARY KEY

);

CREATE...

paul.knibbs (5/6/2015)

---

Orlando Colamatteo (5/5/2015)

---

The ANSI SQL standard defines NUMERIC and DECIMAL separately and there is a distinction in how each might behave different from one another however that is not...

Stephanie Giovannini (5/5/2015)

---

While decimal and numeric are functionally equivalent, they are not the same type. There are six types in the question.

The system_type_id for decimal and numeric is not the...

From the article:

SQL Server treats n as one of two possible values. If 1<=n<=24, n is treated as 24. If...

Thanks Steve.

Jeff Moden (5/5/2015)

---

Orlando Colamatteo (5/5/2015)

---

Jeff Moden (5/4/2015)

---

I don't understand why anyone would need to do this through PowerShell. Can someone who actually had such a need please explain? ...

Jeff Moden (5/4/2015)

---

I don't understand why anyone would need to do this through PowerShell. Can someone who actually had such a need please explain? I'm looking for someone...