Here is something that might work:

param (
[parameter(mandatory = $false, ValueFromPipelineByPropertyName = $true)][string]$Sender = "038962429",
[parameter(mandatory = $false, ValueFromPipelineByPropertyName = $true)][datetime]$FileDate = "2021-03-09",
[parameter(mandatory = $false, ValueFromPipelineByPropertyName = $true)][string]$RecordType =...

• This reply was modified 4 years, 9 months ago by Jeffrey Williams.

Not really - if you can provide sample data from several different files, include the first 3 or 4 segments for each file - I can put something together to...

Can you provide some sample data?  The first 3 or 4 segments from several files - without any protected/private information?

You could change the $date parameter to a datetime data type - then create a separate variable for the string format:

[parameter(mandatory = $true, ValueFromPipelineByPropertyName = $true)][datetime]$date,

$stringDate =...

Thanks for the feedack, Jeffrey...

I totally agree that trying to fully parse EDI files in SQL Server is a bit crazy and even I probably wouldn't go there, especially...

Let me answer your question with other question... What are you doing for logging of the file receipt and copy/move (whatever) and what are you using to schedule this...

You don't need a cmd or bat file - that is what powershell replaces and you don't need to look to a position in the file because the record is...

If I am reading the documentation correctly - switching to OCC in DynamicsAX changes the UPDLOCK to NOLOCK.  If that is the case, then I wouldn't make that switch -...

SO there is a default format for inbound files

Position 36 of the record contains 1st parm and has a length of 15 Position 71 of record contains 2nd parm...

What's stopping you from reading the first two rows using Bulk...

This would be much easier using a Calendar table or function.  We can get those counts by generating the list of dates - then counting the dates that are weekends,...

The files appear to be EDI files - which might lead to a problem.  EDI files may not have CR\LF as record terminator - the EDI documentation will show the...

Setting up the parameters as mandatory will also prompt the user.  Try it..

To setup parameters in a script - you can use something like this:

param (
[parameter(mandatory = $true, ValueFromPipelineByPropertyName = $true)][string]$hdr,
[parameter(mandatory = $true, ValueFromPipelineByPropertyName = $true)][datetime]$date,
[parameter(mandatory = $true, ValueFromPipelineByPropertyName...

When copying the files - you can use Robocopy with appropriate switched to copy the files and folders with permissions.  I just recently did this on a server where the...