Questions tagged [ssis]

9

votes

3

answers

How to get total of top 10 sales in SSRS 2012

asked 2013-06-24T12:14:51.453

23

votes

2

answers

Conditional Split fails if value is NULL in SSIS

ssis

asked 2013-05-21T15:58:34.277

63

votes

3

answers

How to fix the embedded text qualifier issue while exporting data to CSV flat file?

sql-server ssis sql-server-2000 sql-server-2012

asked 2013-02-11T15:45:16.560

10

votes

3

answers

How can I set an expression to the FileSpec property on Foreach File enumerator?

ssis sql-server-2012

asked 2012-11-06T17:16:24.300

10

votes

2

answers

Why does a NULL aggregate warning in an SQL query causes the SSIS package to fail?

sql-server-2005 ssis

asked 2012-10-31T12:03:15.910

8

votes

2

answers

SSIS importing datetime column into SQL Server 2008

sql ssis dts

asked 2012-08-10T09:58:06.587

32

votes

2

answers

SSIS - the value cannot be converted because of a potential loss of data

sql-server oracle-database ssis etl

asked 2012-07-31T14:31:52.547

9

votes

2

answers

Stored procedure vs embedded SQL in SSIS performance

sql-server t-sql stored-procedures ssis

asked 2012-07-06T09:10:18.747

9

votes

1

answers

Casting String to Money Value in SQL Server

sql sql-server t-sql casting ssis

asked 2012-05-14T20:05:06.087

32

votes

3

answers

Update Rows in SSIS OLEDB Destination

sql-server-2008 ssis

asked 2012-05-11T17:14:30.423

12

votes

5

answers

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER error

ssis

asked 2012-05-08T05:45:54.350

8

votes

1

answers

dtexec error - setting multiple variables

ssis dtexec

asked 2012-03-08T03:25:24.840

11

votes

10

answers

SSIS issue Failed to decrypt protected XML node

sql sql-server sql-server-2008 ssis

asked 2012-02-15T16:17:21.727

11

votes

5

answers

Oracle client and networking components were not found

sql oracle-database ssis

asked 2012-01-25T12:16:45.577

10

votes

3

answers

How to execute dtsx packages through command line

visual-studio-2010 sql-server-2008 ssis

asked 2012-01-09T10:29:36.847

13

votes

1

answers

How to stop SSIS from "Phoning Home"

ssis vsta

asked 2011-12-20T02:44:49.777

11

votes

1

answers

Executing the same SSIS Package with different parameters at different time

sql-server-2008 parameters ssis sql-server-agent

asked 2011-12-05T11:50:20.013

11

votes

1

answers

How to move a text file after importing the data using SSIS package?

sql-server sql-server-2008 ssis

asked 2011-11-22T17:45:15.757

9

votes

1

answers

Trying to call a T-SQL Stored Procedure which selects data from linked server in SSIS package

sql-server stored-procedures ssis linked-server

asked 2011-11-08T00:38:34.093

9

votes

6

answers

How to overwrite Excel destination in SSIS?

ssis

asked 2011-11-05T06:09:17.040

33

votes

3

answers

How to loop through Excel files and load them into a database using SSIS package?

excel ssis

asked 2011-09-14T05:39:41.007

12

votes

2

answers

SSIS - Delete rows

ssis insert delete-row sql-delete

asked 2011-08-31T07:54:43.673

12

votes

2

answers

Dynamically create table in SSIS data flow

ssis

asked 2011-08-29T18:25:46.047

41

votes

7

answers

What are the differences between Merge Join and Lookup transformations in SSIS?

sql-server ssis

asked 2011-07-18T15:57:10.240

11

votes

2

answers

How do I import MS Access data into SQL Server using SSIS package?

ssis

asked 2011-07-15T15:44:14.810

11

votes

6

answers

Is there a way to escape a double quote within a text qualified string on a SSIS Csv import?

sql-server sql-server-2005 ssis

asked 2011-07-07T21:17:01.990

10

votes

3

answers

SSIS is dropping a record on flat file source import

sql-server-2008 ssis record flat-file

asked 2011-05-27T05:11:08.753

11

votes

5

answers

How can I load a large flat file into a database table using SSIS?

sql-server-2008 ssis

asked 2011-05-19T15:28:18.737

11

votes

5

answers

How do I merge SSIS package files?

version-control merge dvcs ssis

asked 2011-03-29T05:10:36.293

23

votes

1

answers

SSIS Foreach Loop Folder as variable

sql-server-2008 ssis foreach-loop-container

asked 2011-03-29T00:21:24.553

12

votes

1

answers

"The selected data source is on remote computer" error when creating an SSIS job

sql-server-2005 ssis import flat-file dataflowtask

asked 2011-02-08T22:41:10.263

25

votes

2

answers

How do I fix 'Setup project with custom action file not found' exception?

windows-services setup-project custom-action ssis

asked 2010-12-23T05:55:00.997

15

votes

4

answers

SSIS: Why is this not logging?

ssis

asked 2010-12-03T18:08:41.813

15

votes

1

answers

SSIS Flat Files with Variable Column Numbers

file ssis flat

asked 2010-11-25T22:21:14.133

12

votes

2

answers

sp_who2 BlkBy Sleeping Process Awaiting Command

sql-server ssis sp-who2

asked 2010-11-18T19:29:18.880

10

votes

2

answers

How do I prompt for input from an SSIS package?

sql ssis

asked 2010-11-05T15:20:21.287

21

votes

3

answers

SSIS set variable at runtime

variables ssis

asked 2010-10-29T14:39:17.623

12

votes

2

answers

What should I have in mind when building OLAP solution from scratch?

sql-server ssis data-warehouse olap business-intelligence

asked 2010-09-13T22:53:55.350

13

votes

1

answers

how to use list collection for "foreach" in SSIS

ssis

asked 2010-09-09T06:47:12.367

18

votes

4

answers

SSIS 2005: "Append rows to the destination table" is greyed out. Why?

sql-server-2005 ssis import append dts

asked 2010-08-06T16:45:21.350

10

votes

8

answers

"Failed to lock variable" SSIS error

sql-server ssis

asked 2010-06-24T06:49:44.757

11

votes

4

answers

SSIS 2008 Rows per batch and Maximum insert commit size

ssis

asked 2010-04-29T17:09:48.467

9

votes

1

answers

What is .database file used for in SSIS solution

.net ssis

asked 2010-03-23T08:10:17.973

10

votes

2

answers

SSIS : Conversion DT_NTEXT to DT_WSTR

ssis

asked 2010-01-07T21:51:34.467

46

votes

7

answers

SSIS SQL Task - "Parameter name is unrecognized"

ssis

asked 2010-01-05T19:36:45.950

38

votes

10

answers

SSIS Connection Manager Not Storing SQL Password

sql-server sql-server-2005 ssis

asked 2009-08-13T19:27:08.357

25

votes

13

answers

AcquireConnection method call to the connection manager <Excel Connection Manager> failed with error code 0xC0202009

sql-server excel ssis oledb

asked 2009-04-14T15:27:50.540

24

votes

2

answers

How do you call a Stored Procedure in SSIS?

sql-server sql-server-2005 stored-procedures ssis parameters

asked 2009-04-13T20:13:46.197

12

votes

4

answers

Problem using SQL Agent to run SSIS Packages - fails with "DTSER_FAILURE(1)"

sql-server sql-server-2005 ssis sql-server-agent

asked 2009-04-09T08:37:43.837

66

votes

14

answers

.Net vs SSIS: What should SSIS be used for?

.net sql-server ssis

asked 2009-03-27T15:03:15.163

Questions tagged ssis