Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [ssis]

SQL Server Integration Services, an ETL tool sold by Microsoft and bundled with SQL Server versions since SQL Server 2005.

SQL Server Integration Services (SSIS) is an ETL processing tool made by Microsoft and sold with SQL Server since version 2005. It is only available bundled with SQL Server and cannot be purchased separately.

SSIS replaces Data Transformation Services, which Microsoft introduced with SQL Server 7.0.

1127 questions
11
votes
1 answer

Can't use Fuzzy Lookup in BIDS

A coworker of mine was having an issue with BIDS. He's doing a simple fuzzy lookup and is only looking against two rows (For Testing Purposes). The weird thing is that when he tries to execute a command line prompt appears then vanishes and then the…
Zane
  • 3,511
  • 3
  • 24
  • 45
11
votes
7 answers

How to change a script task version in SSIS?

I added a script task to an SSIS project in VS2015. When I deployed to SQL Server 2016 I got an error message that the version 15.0 script is not supported. Where does this version 15 come from? Reading other, similar questions on Stack Overflow I…
Zach Smith
  • 2,360
  • 12
  • 32
  • 61
9
votes
2 answers

SSIS Data Flow data access mode - what's the point of 'table or view' vs fast load?

Using the SQL Server Business Intelligence Development Studio, I do a lot of flat file to OLE DB destination data flows to import data to my SQL Server tables. Under "Data access mode" in in the OLE DB destination editor, it defaults to "table or…
coburne
  • 333
  • 2
  • 3
  • 8
7
votes
1 answer

moving data from one db to another using SSIS

I am very new to SSIS and need to work out how to setup a transfer from table A database A to table B database B. table A contains many more fields than I need in table B, so the process needs SQL so I can specify fields to take. (I cant just lift…
bruceiow
5
votes
2 answers

SSIS Data Flow Error Output runs all the time

I've a SSIS Data Flow Task. Within which i've souce flat file and OLEDB destination. I've an error output sent to redirect row on OLEDB Destination. The problem is that the redirect row always run even though there's no error. Is this a bug with…
flybyte
  • 381
  • 2
  • 6
  • 9
5
votes
2 answers

SSIS flat file manager - skips the last record

I've a a flat file which is pipe delimited as shown below: header|header2 abc|abcdef abc|abcdef When I create a package on a 64 bit machine it always drops the last record. But on preview it shows both records. Update: If I do this it…
flybyte
  • 381
  • 2
  • 6
  • 9
5
votes
5 answers

SSIS Package Truncation may occur due to inserting data from data flow column

I've a dataflow in SSIS 2008. It reads the data from flat file and inserts in to database. The flat file is CSV. For some reason, all the fields in flat file connection manager seems to have 50 OutPutColumnWidth. Could someone please suggest how to…
flybyte
  • 381
  • 2
  • 6
  • 9
4
votes
2 answers

How do I set up a Derived Column Transformation to get row number in SSIS 2014?

I am trying to import a ragged right flat file. I am wanting to import the file as one column and used Derive Column Transform to add a row number to each row. I would like to end up with a column called RowNum and a column called EntireRow. How do…
gaktheknife
  • 123
  • 2
  • 4
  • 16
4
votes
1 answer

Conditional data flow task in SSIS

Brief Architecture: I am creating a SSIS package to generate Excel reports. There are different types of reports, So I have created a table to track each user request for report generation and tracking the status of request. A Sql job picks each…
CodeTody
  • 41
  • 1
  • 2
  • 5
4
votes
2 answers

SSIS Row Count: Getting a null variable error where there is clearly a selected variable

Validation error. Build Files Count VIE [245]: The variable "(null)" specified by VariableName property is not a valid variable. Need a valid variable name to write to. From what I can tell, this error is thrown when a variable is not assigned to…
Davenport
  • 327
  • 1
  • 3
  • 9
4
votes
2 answers

SSIS Package Error when called from SQL Agent Job

We have SSIS running on its own server under account 'ourserviceaccount'. We then have SQL Agent running on a separate server under the same account. I have set up a job that calls an SSIS package, which in turn calls a number of child…
K09
  • 1,394
  • 13
  • 36
  • 59
3
votes
1 answer

Logging Questions for SSIS 70-463

I have been looking at sample questions on logging for 70-463 exam. For the below, the answers given do not make sense to me. The first answer given does not even say how to implement logging. I would have selected C as the answer. The second answer…
K09
  • 1,394
  • 13
  • 36
  • 59
3
votes
3 answers

Can I downgrade SSIS packages to run on older version of SQL

We have some new SQL 2008 SSIS jobs that were recently developed, mostly to do some simple flat-file loading and targeting a set of tables on a 2008 server. As it turns out, they may have to run on a SQL 2005 server for both the SSIS and target…
sdg
  • 195
  • 1
  • 1
  • 6
3
votes
1 answer

How does one select the histogram / scatterplot / etc. Data Viewers in SSIS 2012

I have a data flow task in SSIS 2012 and have created a flat file source and an OLE DB connection destination. I can select the data flow path between them as in earlier versions of SSIS and I can right click and select the Data Flow Path…
Thronk
  • 1,388
  • 3
  • 19
  • 38
3
votes
1 answer

Simplest way to constrain an SSIS Execute Process Task

We have some complex SSIS packages, currently in SSIS 2005, that use Execute Process Task in order to call out to do some business logic. Some of these called programs are not as stable as one could wish for. What is the simplest way, therefore, to…
sdg
  • 195
  • 1
  • 1
  • 6
1
2 3 4 5