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
-1
votes
1 answer

How to fetch the Excel file path connection dynamically through a variable in the Excel Source?

How to fetch the Excel file path connection dynamically through a variable in the Excel Source? Inside my Foreach Loop Container, I have Excel Source which has Excel Connection String. I am using the variable to map the Incoming folder path. I set…
goofyui
  • 3,362
  • 20
  • 72
  • 128
-1
votes
3 answers

Bring correct date format in SSIS

I need date format in American Format i.e. 9/30/2018; 8/31/2018; 7/31/2018.. so on and so forth in SSIS. I have written the code in the format as LEFT((DT_STR,50,1252)DATEADD("d",-DAY(GETDATE()),GETDATE()),10) This is bringing date in 2018-09-30…
xorpower
  • 17,975
  • 51
  • 129
  • 180
-1
votes
1 answer

SSIS Connection manager

I have created two projects with same connection manager names. Though the names are same, they point to two different environments. I was assuming that if I add package from one project to other I should not face the connection manager related…
Kedar Puranik
  • 13
  • 2
-1
votes
1 answer

Import multiple PDF's from Multiple folders, into a SQL table.

I need to upload multiple PDF files from Multiple Folders (a shared directory) into a SQL table. what is the best way to complete this task and have it automated? The DB Table structure looks like this> DB table format the file list is the full…
highstride
  • 61
  • 8
-1
votes
2 answers

CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER when running .dtsx from server

I have an SSIS project that seems to work properly when ran from local machine, but when I deploy it to the server, and run it I get the following errors: Package:Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code:…
Xyzk
  • 1,332
  • 2
  • 21
  • 36
-1
votes
1 answer

How to Add csv file data into multiple Table in SSIS Package

I have data in .CSV file and I want to insert that data into multiple Table in SQL SERVER using Single SSIS Package. I tried Multicast option but not come up with the solution... if you have any idea how to do this please share the solution.....
Akshay Bhole
  • 1
  • 2
-1
votes
1 answer

SSIS Transformation for flat file

This is my Table in SQL Server: Country varchar(50) varchar(50) Int and i have a flat file data ------------Flat file---------- Output: Can you please suggest me the process, how to perform this task and what all tranformation should i use…
Bright Junis
  • 11
  • 5
-1
votes
1 answer

Where is the "UserKey" stored used in "EncryptSensitiveWithUserKey"?

Where Can I find the userkey where the SSIS packages uses for protection EncryptSensitiveWithUserKey. 1.Is it Editable? if I create a new SSIS Project with my new profile, can I copy the "UserKey" from the new Project into my old Projects to allow…
Abhijit Kaware
  • 9
  • 1
  • 5
-1
votes
4 answers

Import excel to sql server Executing Error (SSIS)

I was trying to import excel file to sql server for the first time and I get this error. Could you please help me? No idea what's going on :| Operation stopped... Initializing Data Flow Task (Success) Initializing Connections (Success) Setting SQL…
Rocket128
  • 123
  • 3
  • 13
-1
votes
1 answer

Issue with XML Source

I am trying to load data from XML file to SQL Server table Using SSIS package, but it keeps on getting me this error while executing it and XML source in Data flow. If I execute it in different PC with same XML file, I get any error messages but…
nish
  • 1
  • 2
-1
votes
2 answers

Run multiple .dtsx files together

I have three different .dtsx packages under a single ssis package. How to execute all three together with a single click without having to open each dtsx file and execute them separately
katy89
  • 161
  • 2
  • 13
-1
votes
1 answer

How to export data with duplicate column names using SQL Server Import Export Wizard

I have one scenario in which I am getting a lot of employee data like address, qualification, work experience, etc from different tables into a new table. In the required result set there are a few columns which have same(duplicate) name. For…
Vashisht Varun
  • 1
  • 2
-1
votes
1 answer

Script Task throwing error when reading 700MB flat text file

I'm trying to read a 700 MB flat text file. I'm using a script task for it. The data is getting stored in a DataTable. When I'm running the package in my local machine, its running fine. But when I deploy the package to SSISDB, it runs for some…
Prashant Yadav
  • 531
  • 2
  • 9
  • 25
-1
votes
1 answer

Export SQL table containing XML data type from SQL to SQL using SSIS

G'day all. We have a very large table in SQL 2005 containing over 200m records and one of the column is a XML data type. We are upgrading that database to SQL 2012 and hence the data need to be transferred across. For large db's (> 500 GB) we have…
JSK
  • 1
-1
votes
1 answer

Get FileName in SSIS

I'm new to SSIS, how can I get the Excel FileName that I'm trying to upload and assign it to a variable for later usage? I've tried to do some research but I didn't get anything helpful.
John Doe
  • 37
  • 3
1 2 3
…
91 92