Tags » SSIS

SSISDB Error "The version number of the package is not valid"

The full message will also contain “The version number cannot be greater than the current version number”.

Behaviour

I have an SSIS package installed in an SSISDB which is on a server that run SQL Server 2012 (server A) and it needed to be copied to another 2012 instance (server B). 260 more words

SSIS

SSIS: Run a batch file as administrator using command line

Open command prompt as administrator:

c:\windows\system32\cmd.exe–> runas /user:domain_name\admin_user_name cmd.exe

SSIS–>Execute Process Task–>Process tab–>

  1. Executable: C:\Windows\System32\cmd.exe
  2. Arguments: /C runas /user:domain_name\admin_user_name cmd.exe

Run the bat file:

Execute Process Task is used to execute the external application in SSIS. 301 more words

SSIS

Programmatically emailing of SSRS reports

Recently I was tasked with creating a process to email SSRS reports out to users.

Ordinarily I would suggest using the built in subscription manager, however in this case we needed to be able to increment any date parameters in any report, and we have 300 of them. 902 more words

SSIS

C#: Create an Excel file without Excel already installed on the machine

Scenario:

How can I create an Excel Spreadsheet with C# without requiring Excel to be installed on the machine that’s running the code?

Solution… 374 more words

SSIS

C#: Save SQL query result as Excel file with Column Headers

Scenario:

I want to write SQL SELECT query in c# pages then save the query result in excel file with column headers

Solution:

Add the following #namespaces… 281 more words

SSIS

C#: Create new excel workbook and save as csv file

Scenario:

I need to create an csv file programmatically.

Solution:

Add the following #namespaces

/* extra name spaces
*add Microsoft.CSharp
*add a COM reference in your project to the “Microsoft Excel 11.0 Object Library” 379 more words

SSIS

C#: Insert a worksheet in existing excel file

Scenario:

I have an input csv file. I have to insert an worksheet into that csv file.

Solution:

Add the following #namespaces

/* extra name spaces… 394 more words

SSIS