Deploy and Execute SSIS Packages using Stored Procedures

Step by step of executing SSIS 2012 package through stored procedure

Great. If you have any question on those technologies, don't hesitate to ask.

(I'll answer the SSIS ones :-D)

It should work when you create the SQL statement in a string variable and use that variable as the source for your SQL statement in the OLE DB source.

Make sure...

You cannot "store" values in a view.

I don't think you can use the IF...ELSE construct in a view.

You'll need a stored procedure for that.

The error might have given this away:

Msg 156, Level 15, State 1, Procedure...

It might.

Hard to tell without knowing actual table DDLs and their indexes and the actual query plan.

About how many rows are we talking here?

How long is "lots of time"?

Also, with...

There's a DTS package migration wizard:

Using the DTS Package Migration Wizard

There's also a 3rd party tool that can help you with the migration:

DTS xChange

If it is that mission critical, the...

I guess CboValuesTranslations.cboValueTranslationName is not used in certain rows as it is inside an ISNULL function. If CboValuesTranslations.cboValueTranslationName is NULL, another column is used.

I would simply select CboValuesTranslations.cboValueTranslationName and CboValues.cboValueName...

Too easy 🙂

If the database servers have SQL Server authentication and TCP/IP enabled, you could use SSIS to transfer the data.

If it's SSIS 2012, you can very easily start SSIS packages with parameters using stored procedures, so I would look into that route. I believe you can also run the...

Did you write Report.exe yourself?

alex_2356 (10/16/2013)

---

I have an application that generates barcode in image format and it is read by some devices and fails in others. The problem now that the barcode image is...

This seems to be some sort of running total.

You can solve this without a cursor and without a recursive CTE.

Read the following (long and advanced) article by Jeff Moden on...

churlbut (10/15/2013)

---

Here is one I was discussing with a colleague a few days ago. When we get home how much do we actually talk about our work, I don't...