Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [ssis-2014]

SSIS 2014 is Microsoft SQL Server Integration Services 2014, and is part of SQL Server 2014. SSIS allows SQL Server to interact with other technologies, including import and export of data to and from other formats, or ETL, and data warehousing. Please add the SSIS tag.

52 questions
20
votes
4 answers

how to query SSISDB to find out the errors in the packages?

I have seen this question SSIS 2012 - How to Query Currently Running Packages in T-SQL? It gives me the following script: SELECT E.execution_id , E.folder_name , E.project_name , E.package_name , E.reference_id , E.reference_type , …
Marcello Miorelli
  • 17,274
  • 53
  • 180
  • 320
14
votes
1 answer

Executing SSIS Package from a stored procedure with different user privileges

I'm having issues with allowing my users to execute SSIS Packages in a reasonable manner due to varying levels of privilege required. The scenario: we've created a data warehouse, with two different SSIS packages responsible for loading it with…
Wokket
  • 161
  • 1
  • 6
9
votes
3 answers

sql server max memory includes SSIS?

I have installed 2 instances of sql server plus SSIS on the following server. Note the amount of RAM is nearly 384 GB And this is the max and min memory settings that I have applied to my 2 instances. I assume that both instances will use equal…
Marcello Miorelli
  • 17,274
  • 53
  • 180
  • 320
7
votes
2 answers

SQL Server 2014 SSIS Package Ignores Script Task when running as AGENT

Alright, so here's what I have going on. SSIS Package that queries data from our production system and drops them into CSVs. Have a VB script task that uploads them to a third party. Needed a multi-post HTTP post with authentication and a couple…
bvankampen
  • 171
  • 1
  • 4
5
votes
1 answer

Passing NULL to SSIS variables

I'm building a package to execute a procedure with parameters from a configuration table. I've built two Execute SQL Task boxes. One populates SSIS variables from the configuration table. The second executes the procedure with those variables. I'm…
Michael Cherevko
  • 742
  • 6
  • 16
5
votes
1 answer

Best Practice for SQL Server data validation

I have CSV files that I would like to import into SQL Server 2014. Each record in the files has around 20 columns, each of them should be validated for data type compliance as well as some other checks per column (min/max ranges, null/not null…
nojetlag
  • 2,927
  • 9
  • 34
  • 42
5
votes
2 answers

How to install SSIS on SQL Server 2014?

I am installing SQL Server 2014, including SSIS, on a Windows Server 2012 R2 machine. From this link: https://msdn.microsoft.com/en-us/library/ms137861(v=sql.120).aspx ssis uses port 135 which should be opened on the firewall(s). I Create a domain…
Marcello Miorelli
  • 17,274
  • 53
  • 180
  • 320
4
votes
1 answer

Apply settings to multiple output columns in SSIS flat file source

Is there an easier way to apply property settings to multiple output columns in a SSIS flat file source, rather than manually applying to each output column? (SQL Server 2014.) I am attempting to export data from a large text file source to an…
lintunen
  • 81
  • 1
  • 3
4
votes
1 answer

Error Updating SSIS package to 2014 due to script component

I am trying to update a SSIS package that contains script component. The script component just gets the error description as described here. I am using the update wizard in SSDT 2015 which should be compatible with SQL Server 2014. (ssdt) After the…
Bob Klimes
  • 3,400
  • 1
  • 19
  • 31
4
votes
1 answer

Can I create a random number in an SSIS derived column

I have a task where I am trying to assign a random PIN to an account. I have SQL code that will generate a random integer between 1000 and 9999. I was wondering if I could put that in a Derived Column task in SSIS and not do it in the source data? …
Chris The DBA
  • 43
  • 1
  • 4
4
votes
1 answer

SSIS Script Task doesn't appear to run when scheduled

I have a script task inside SSIS which does not appear to run when the job is triggered from SQL Server Agent. I say does not appear to run because I don't know if it's the SQL Script task or some task preceding it. The basic goal of this part of…
Clive Strong
  • 180
  • 1
  • 7
4
votes
2 answers

How to resolve COM server application local activation permission for machine account

I am trying to enable SSIS package logging to event logs. When an attempt is made to write to the event log the following error appears in the system event logs: The application-specific permission settings do not grant Local Activation…
lintunen
  • 81
  • 1
  • 3
3
votes
1 answer

CAST SUBSTRING to NUMERIC SSIS

I have a fixed width text file that I am bringing in through SSIS. As part of the input into SQL Server I am grabbing a string of characters and trying to CAST them as numeric in a derived column. The data looks like this: 02 …
gaktheknife
  • 123
  • 2
  • 4
  • 16
3
votes
1 answer

Automatic ETL between similar tables

I have 43 tables on 2 different servers which I have to sync regularly. Because of our network policy and IG reasons, we can't have link server object between these two servers. Standard procedure so far is to create a SSIS package that will do the…
mouliin
  • 530
  • 1
  • 4
  • 15
3
votes
2 answers

What could cause "lagging" in SSIS execute SQL task?

Recently I noticed that the part of my ETL process loading the data into the staging area sometimes takes longer and sometimes shorter. With the following query (executed in the integration services catalogs database) I was comparing two different…
tombom
  • 3,208
  • 1
  • 22
  • 28
1
2 3 4