Ok so you have a data flow that uses a flat file as the input and a table (with date column) as the output, is that right?

If so just drag...

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

We currently send data to a third party via a web service.

I used a script component in the data flow and added a web reference (URL) which points to their...

Jeff Moden

Ok, that makes sense from the TSQL side, the file operations we do are secondary to the primary process and since we already have all the variables and such...

Jeff where are putting this command? In an Exec Process task or cmd shell in...

I was able to get this to work:

using System.IO;
namespace ST_adc7961e6d564b959438804fe590a5a4
{

[Microsoft.SqlServer.Dts.Tasks.ScriptTask.SSISScriptTaskEntryPointAttribute]
public partial class ScriptMain : Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase
{

        public void...

A recent script that I used to move and rename. This uses a local variable that was set from a for each file loop and the Archive dir which comes...

You need to have a full file path for both.

• From connection: C:\temp\MyFile.csv
• To connection: C:\archive\MyProcessedFile.csv

Note: When you do a move you can also do a rename at the same...

• This reply was modified 3 years, 6 months ago by  TangoVictor. Reason: spelling... apparently l can't spell today, TGIF

Grant, that would be great, thank you.

Thank you Grant, actually if you have the power you can just delete that, I didn't redact parts of the screenshot I should have. Reporting it was the only I...

You can actually setup an alert for blocking and then you can have that alert call a stored procedure to get some amplifying information, record that information in a...

You need to target the correct version. So I suggest you install VS2019 and also make sure you get the latest SSIS through the Extensions Menu (after you upgrade to...

• This reply was modified 3 years, 8 months ago by  TangoVictor.

Yeah you can do that. Picture attached for how I configured the exec process task.

There are various methods for writing to SQL from PS, look at this link for more...

OK yeah I did some searching yesterday and found thousands of different GIS downloads, it was overwhelming but I'll try more narrow searches such as the one you stated.

And yeah...

Well that was a roundabout way to do it but yeah it worked.

I updated my nickname then it appeared in the dropdown

Then I updated my nickname back to what it...