Stack Overflow
Stack Overflow

Questions tagged [ssis-2012]

Microsoft SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformations solutions. SSIS 2012 is a part of SQL Server 2012 Data Tools

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks.

SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. wikipedia

1375 questions
4
votes
1 answer

Installer for ISDeploymentWizard.exe

Is anyone aware of an installer (msi or otherwise) that drops the SSIS Deployment Wizard executable (ISDeploymentWizard.exe) onto a server (generally found in C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn). We have a web server (we use…
Travis Ingram
  • 387
  • 5
  • 21
4
votes
3 answers

Running SSIS 2008 package on a SQL2012 instance

I'm upgrading our ETL solution and databases to SQL server 2012. I have tested this upgrade but we have a debate about running an SSIS 2008 package with the Job on the SQL 2012 instance. I understand that the 2008 R2 instance job runs: Message…
Frank Goortani
  • 1,407
  • 17
  • 26
4
votes
1 answer

SSIS 2012: How do I change the project's environment variables?

I want to change 2 date project variables, StartDateTime and EndDateTime. I have another variable called RunType. Very simply, I want to read the value RunType first. If it is set to "Incremental" I want to change the StartDate from whatever it is…
plditallo
  • 701
  • 2
  • 13
  • 31
4
votes
3 answers

SSIS package template location

Can we change the default location for package templates? Or at least add more locations? I would like to create some templates and add them to the source control but I'm not very keen on adding a file on the C:\Program Files (x86)\Microsoft Visual…
Diego
  • 34,802
  • 21
  • 91
  • 134
3
votes
1 answer

SSIS, query Oracle table using ID's from SQL Server?

Here's the basic idea of what I want to do in SSIS: I have a large query against a production Oracle database, and I need the following where clause that brings in a long list of ids from SQL Server. From there, the results are sent…
ColinMac
  • 620
  • 2
  • 9
  • 18
3
votes
1 answer

Cannot save custom property from a custom component into a DTSX file

I'm trying to create my first SSIS custom source component but I can't get it to save the custom properties into the .dtsx file. According to…
MLeblanc
  • 1,816
  • 12
  • 21
3
votes
1 answer

Dtexec ISSERVER returns is not a valid server package path

I am executing a SSIS package via master..xp_cmdshell from a stored procedure and I am always getting the error "Description: '\SSISDB\Main\Projects\ProjectName\Packages\PackageName.dtsx' is not a valid server package path." I tried various…
Arvindakshan
  • 61
  • 6
3
votes
1 answer

Deal with commas in comma delimited file when importing flat file as a source to SQL Server in SSIS

I have a flat file that with comma as a delimiter. In one address column I have . My issue is that one of the fields in my file contains "," (commas), so when the file is created it creates new columns because the field is "," comma delimited on the…
Nadeem Ahmed
  • 31
  • 2
3
votes
2 answers

How can I get all matching rows from lookup using full cache mode?

I need to make a lookup between two tables T1(A,B,C) and T2(A,B,C,D,E) on column C to get all column B values that are matching : T1 : T2 : When I choose Full cache Mode I get only the first matching row (I'm only interested by column B values):…
MedEc
  • 169
  • 1
  • 14
3
votes
1 answer

Execute SQL Task output parameter vs ResultSet

We have parameter direction as output in parameter binding and at the same time we do have result binding. So if we are having output variable or return type variable which will be available at output, so why do we need Result binding then.
Kashish Aneja
  • 41
  • 1
  • 6
3
votes
2 answers

Find first day and last day of previous week in SSIS expression

I have checked in SQL and get values of first day and last day of previous week, but I want in SSIS expression. I tried in SQL script SELECT CAST(DATEADD(wk,DATEDIFF(wk,7,GETDATE()),0) AS DATE) --First day of previous week SELECT…
hardik rawal
  • 117
  • 1
  • 2
  • 18
3
votes
1 answer

SSIS SQL Executation Task error: unable to run some sql queries

I'm working to make some fact tables (taking some data from some resources, doing some transformations and putting them in a table). My main dilemma is that I can't run any SQL query other than select, update, and insertion. As soon as i try: exec…
AliRa
  • 51
  • 6
3
votes
1 answer

Dynamically Creating Excel table through SSIS

Using Execute SQL Task in SSIS - created Excel file- contains multiple columns and different data types.The issue here is INT/Money columns are displaying as a text columns in Excel even though excel table is created with Int/Money datatype I have…
Koti Raavi
  • 300
  • 2
  • 13
3
votes
2 answers

Not able to recognize a table variable in ssis sp

I have created a variable in ssis called Vpop_summary_table. I have used this variable in a sql statement. my variable Vpop_summary_table is expected to give value [dbo].[2019-02-02_pop_table] It is fine in ssis. DECLARE @Vpop_summary_table…
prabhu prasad
  • 39
  • 8
3
votes
1 answer

SSIS - What is the difference between Task grouping and Sequence Task?

Task grouping and Sequence task both allow to club tasks together as one unit. What is the difference between them? Task grouping - Refer to 4- Sql Server 2012 Implement Data Warehouse - Exam 70-463 - at 4:28 see last line in the video
variable
  • 8,262
  • 9
  • 95
  • 215
1 2 3
…
91 92