Index DDL

CREATE NONCLUSTERED INDEX [IX_Agehoh2] ON [dbo].[Targus_201412_V7]

(

[AGEHOH2] ASC

)

INCLUDE ( [AgeHOH]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB =...

Table DDL

CREATE TABLE [dbo].[Targus_201412_V7](

[PrimaryPhone] [varchar](10) NULL,

[CensusBlock] [varchar](15) NULL,

[City] [varchar](50)...

Thanks Gail!

Thanks everyone that worked.

Thanks

I didn't want to add any other logic to the script just have the job step fail if the file is present. Someone suggested just using the Get-item by...

Thanks Grant will do.

Hi Grant

I changed the code to:

Set-ExecutionPolicy RemoteSigned -ErrorAction SilentlyContinue

$today = (get-date).Date

$file1 = "CRAADDET"

$file2 = "CRACRDTL"

$file3 = "CRACRDDB"

$file4 = "CRACON"

$file5 = "CRACONDB"

$file6 = "CRAAAD"

$file7 = "CRAAPPDB"

$files8 =...

I have to thank everyone so much. These are all good solutions and I have learned a few thing. One last thing...Any suggestions on articles or powershell script libraries you...

I am finding that my options are limited in standard edition.

Thanks

Thank you so much for the reply. I need to mention that the tables application.app_key and apdoc.user1 exist on separate databases (db1.application.app_key and db2.apdoc.user1.). I am running the query from...

The third subscriber is for reporting so it has to be synchronized.

Thanks

Thanks Sean that worked. I also found that substring worked too.

update XDDDepositor

SET XDDdepositor.WBeneName = Vendor.RemitName,

XDDDepositor.WBeneAddr = SUBSTRING( Vendor.RemitAddr1,0, 35),

XDDDepositor.WBeneAddr2 = SUBSTRING( Vendor.RemitAddr2, 0 , 35),

XDDDepositor.WBeneCity = Vendor.RemitCity,

XDDDepositor.WBeneState = Vendor.RemitState,

XDDDepositor.WBeneZipPostal =...

Thanks Sean that worked. I also found that substring worked too.

update XDDDepositor

SET XDDdepositor.WBeneName = Vendor.RemitName,

XDDDepositor.WBeneAddr = SUBSTRING( Vendor.RemitAddr1,0, 35),

XDDDepositor.WBeneAddr2 = SUBSTRING( Vendor.RemitAddr2, 0 , 35),

XDDDepositor.WBeneCity = Vendor.RemitCity,

XDDDepositor.WBeneState = Vendor.RemitState,

XDDDepositor.WBeneZipPostal =...

Found the problem. I missed the mapping for the input column for the one showing the null values.

Will do thanks again!

Doug