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
33
votes
6 answers

SSIS Package not wanting to fetch metadata of temporary table

I have an SSIS Package, which contains multiple flows. Each flow is responsible for creating a "staging" table, which gets filled up after creation. These tables are global temporary tables. I added 1 extra flow (I did not make the package) which…
Mortana
  • 1,332
  • 3
  • 15
  • 29
21
votes
2 answers

SSIS - How to loop through files in folder and get path+file names and finally execute stored Procedure with parameter as Path + Filename

Any help is much appreciated. I am trying to create an SSIS package to loop through files in the folder and get the Path + filename and finally execute the stored proc with parameter as path+filename. I am not sure how to get the path+filename and…
Sai
  • 221
  • 1
  • 3
  • 10
19
votes
3 answers

Is it possible to deploy SSIS 2012 package on SQL Server 2008

I have a package that is developed in SSIS 2012 using Visual Studio 2010. Is it possible to deploy/attach this package on SQL Server 2008 If it is possible, does the licence of the sql server matter
Thea
  • 7,879
  • 6
  • 28
  • 40
18
votes
2 answers

Reading project parameters in Script Task

This is what I'm trying to do in a script task: long lngMaxRowsToPull = Convert.ToInt64(Dts.Variables["Project::MaxRowsPerPull"].Value); I get an error message that the variable does not exist. Yet Its defined as a ReadOnlyVariable to the script…
Metaphor
  • 6,157
  • 10
  • 54
  • 77
17
votes
6 answers

ssis Package validation error ole db source failed

I am getting the following error when I try and run my package. I am new to ssis. Any suggestions. Tahnks =================================== Package Validation Error (Package Validation Error) =================================== Error at Data…
john french
  • 379
  • 2
  • 5
  • 8
14
votes
3 answers

Automate Version number Retrieval from .Dtsx files

Is there a way or query by which I can find the version number of SSIS packages (*.dtsx files)? I have the *.dtsx files in my Team Foundation Server for which I wanted to know. The manual way is to do a mouse right-click on the package and click…
saurabh sharma
  • 183
  • 1
  • 13
13
votes
1 answer

How to Map Input and Output Columns dynamically in SSIS?

I Have to Upload Data in SQL Server from .dbf Files through SSIS. My Output Column is fixed but the input column is not fixed because the files come from the client and the client may have updated data by his own style. there may be some unused…
Shahab Haidar
  • 625
  • 3
  • 11
  • 25
13
votes
2 answers

SSIS Expressions setting two variables

I'm trying to use an "Expression Task" within SSIS to simply initialize/set two variables. This seemingly simple task has driven me nuts because I don't know how to separate the statements: @[User::testVariable]="1" @[User::testVar2]=3 That…
LearnByReading
  • 1,813
  • 4
  • 21
  • 43
13
votes
3 answers

Why is "Use environment variable" option disabled/grayed out in SSIS2012 catalog configuration?

This may sound like an easy question but the answers on the net all point to the basics of setting up an environment and referencing it in the project/package. The scenario that I have encountered was never mentioned anywhere so I thought it would…
Louie Bao
  • 1,632
  • 2
  • 16
  • 23
12
votes
2 answers

Anyway to deploy a SSIS 2012 project built in VS 2013?

First, I'm loving the very clearly delineated versioning of the SSIS tools. >:( I installed SSDT BI for Visual Studio 2013 and built a nice little project in it to generate test data. Within VS 2013, I ran this thing hundreds of times. I can deploy…
Greg McGuffey
  • 3,116
  • 3
  • 38
  • 58
11
votes
5 answers

SSIS File System Task Error while copying files between servers

I can copy files between two servers say Server A and Server B manually and I have permissions to folders on either side. I am using File System Task to Copy files. When my Source and Destination are within the Server the Package works fine in…
Manoj Nayak
  • 2,449
  • 9
  • 31
  • 53
11
votes
3 answers

Is there any releavance for "ROW PER BATCH" AND "MAX INSERT COMMIT SIZE" IN SSIS PACKAGES?

I've have SSIS Package that is exporting 2.5 GB OF DATA containing 10 million records into Sql Server Database which has 10 partitions including PRIMARY FILE GROUP. Before Changing default Max Insert Commit size i.e."2147483647" and Row per…
Harsimranjeet Singh
  • 514
  • 2
  • 6
  • 19
10
votes
5 answers

Query a database based on result of query from another database

I am using SSIS in VS 2013. I need to get a list of IDs from 1 database, and with that list of IDs, I want to query another database, ie SELECT ... from MySecondDB WHERE ID IN ({list of IDs from MyFirstDB}).
faujong
  • 949
  • 4
  • 24
  • 40
10
votes
6 answers

SSIS 2012 Method not found: void

I recently got this error in every SSIS package (using Visual Studio 2012), when I want to open a OLE DB source component: =================================== Method not found: 'Void…
DenStudent
  • 906
  • 1
  • 13
  • 37
10
votes
2 answers

SSIS Package Not Running as 32bit in SQL Server 2012

I have a package that I developed in VS2012 (using the SQL Data Tools component) which collects data from a DBF file using the VFPOLEDB provider, and puts it into a database on a SQL Server 2012 X64 server. The project containing the package has the…
Adam H
  • 193
  • 1
  • 4
  • 16
1
2 3
…
91 92