In general, I don't like calling web services (especially synchronous calls) from an SSIS box, because that ties the performance of the SSIS box to that of the client (the...

Before we go down the SSIS path, I just want to verify that Data Driven Subscriptions are not an option for you, because it seems like that should be your...

You didn't mention where in your pipeline you were trying to accomplish this. If you are in a Script Task, you could do something simple like:

string checkString = "0z700";

while (checkString.StartsWith("0"))...

I think this is what you are looking for: Working with Variables Programmatically. You will be able to read and write to the variables collection.

Which part are you having problems with, gathering the data with PoSh or pushing it back in SQL?

Just eyeballing that string, two things that I would try:

1. put a space before the 2nd /SET

2. lose the trailing \ in "C:\Users\mydir\Documents\SRM_IS\IS\ETL\". I seem to recall seeing DTEXEC having...

Try not to use SQL Server's resources for this type of thing. Do it on the client side, something like this:

//This assumes you have already populated a DataTable named

//dataTableFromSQL, and...

My advice would be to look at TFS no differently than a share out on a file server. Think about each database as a folder. Its subfolders will be tables,...

The first thing I would check is the Package ProtectionLevel. The appropriate setting for you will be specific to the environment you are running in, but it sounds like you...

Using the OUTPUT clause is a common pattern for something like this.

My favorite way to get rid of dupes is with a Common Table Expression (CTE).

WITH GroupedDupes AS

(SELECT RowNumber = ROW_NUMBER() OVER (PARTITION BY FirstName ORDER...

For upgrades, it can depend on how you use it, and if you are currently using Database Projects. One example, if you have leveraged Database Unit Tests, the current version...

So, are you saying if you select a line in SSMS and press CTRL + K, C it doesn't comment the line (which doesn't match your subject)? If that doesn't...

Do you mean CTRL + K, C ?

I've seen that error when the text qualifier gets modified. Check out this blog post from @JamieT.