The dbatools module is becoming a popular tool to use. [Caveat as I'm a major contributor to that module.]

Your need to script out things for a...

That is NOT the same. Calling...

kpmandani (1/2/2017)

---

Hi Shawn, I didn't just copy paste as it is. I did add my own email address, file path and other details. The error was still the same. In...

kpmandani (11/30/2016)

---

I tried running your code on Windows Powershell ISE and it gives me following error:

Send-MailMessage : Unable to read data from the transport connection: net_io_connectionclosed.

At line:3 char:17

+ Send-MailMessage <<<<...

Is that expression exactly like you have it in SSIS?

I wrote an article last year on how to call SSIS in the execute process task[/url] and provided an example of...

Picky picky...it was just an example of how the portal worked that was basic enough to illustrate.

Ben Miller has the Stairway Series that is beginner level.[/url]

Most of my blog post for my company are on PowerShell. I did a series on PS that goes through the...

Why would you not use it in production? I know many clients that...

frederico_fonseca (6/11/2016)

---

And I have to query why you wish to remove the newline - in many cases that I have seen people wanted to remove them only because the file...

If you want True package completion message you would have to enable a logging provider at the package level...or depends on how you are calling the package.

Alternative would be...

You can try and use OPENROWSET to the Excel spreadsheet. I have had different results in it but should work.

Alternatives would be to just export data via script to CSV...

You can see my answer over on AskSSC for an example of how you create a credential object.

What you would need to do is use the -Credential parameter that accompanies...