Hi

Please check

1. The locale settings for the server, typically happens if you passed date as MM/DD/YYYY and should be DD/MM/YYYY (or vice versa).

2. Nvarchar values are less than 1753-01-01...

Very nice :cool:, but as I see most of us prefer (and me too) 3 definitions of aliases

Thanks

Hi

For unsigned:LEFT( (DT_WSTR, 20) @[User::zonevalue],3)

Regards.

Mike

Hi

Here is very good example of incremental load http://sqlblog.com/blogs/andy_leonard/archive/2007/07/09/ssis-design-pattern-incremental-loads.aspx

As the last step add Execute T-SQL Statement Task to update status_flag = 'D' for rows which are not exist...

Hi Charmer

Regarding the FileSpec Expression. I saw in your PS code that you processing only files with names that contain the value passed

by parameter $FileName, so I did the same...

Hi

Is the another server (where your windows app reside) under same domain as the SQL?

Best regards

Mike

Charmer, You can do that with For Each Loop Container & Script Task instead of Process Task.

1. Add Each Loop Container:

- set Foreach File Enumerator in Collection

- add Expression for...

Hi

Please do the right click on Powershell shortcut and choose 'Run as Administrator'.

Regards

Mike

Don't worry, I'm also not a Master Blaster with PowerShell, I used trivial batches with Process Task over a decade,

I just started using PS this year.

To run PowerShell scripts...

Small example from my ps script:

Start-Process -FilePath "C:\Program Files\7-Zip\7z.exe" -ArgumentList "-wG:\TEMP e dbcopy.tgz" -PassThru -Wait

Regards

Mike

Hi Charmer

Imho it will be better if you change the extension to ps1.

There is another issue with PowerShell and Ssis, when you call any Start-Process

in ps script, add -PassThru -Wait...

Hi

Please try to set in "Arguments" something like that: -ExecutionPolicy ByPass -command ". 'D:\db_r\scripts\wipe.ps1'"and replace D:\db_r\scripts\wipe.ps1 with your path&filename.ps1

Regards

Mike

Hi

Hmm, won't be easier if you simply set *vendor*.csv in Enumerator configuration section

for Foreach File Enumerator?

Bet regards

Mike

That's a quite easy question, it is well-know from SQL Server 2000.

Thanks

Hello Stylez

You can try to set expression on the text box:

=Switch(Fields!GrandTotal.Value < 1000,Format(Fields!GrandTotal.Value, "Yor first Format"),Fields!GrandTotal.Value > 1000,Format(Fields!GrandTotal.Value, "Your second Format"))

Best regards

Mike