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 Execute Multiple SSIS packages at a single time in production

I have 20 SSIS packages and want to put all packages in a single package to run as a single package with same destination table.Is that possible? If possible Can anyone help me how?
chanti
  • 9
  • 4
-1
votes
1 answer

How do i connect to database after i installed SSIS 2012?

I am trying to connect to database from Integration Service project from Microsoft visual studio. How do I create a database from SQL SERVER 2012.
Mathu
  • 9
-1
votes
1 answer

Read .dat file using SSIS and store the data in various tables

I need to read the .dat file (each row contains different columns) and insert into SQL Server Database Tables (insert parent (2nd row and few more rows based on first column value) and then remaining child records). Please suggest the solution.…
Mohan
  • 19
  • 3
-1
votes
1 answer

Error while using Stored Procedure with dynamic sql in SSIS OLE-DB source

I have a SSIS package which uses a stored procedure with dynamic SQL as OLEDB source. When I execute the package, I get this error Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "The metadata could not be…
bmsqldev
  • 2,627
  • 10
  • 31
  • 65
-1
votes
2 answers

SSIS File System task didn't copy files from the source server location when scheduled

I'm new to SSIS and stuck with a problem and hope some of them would have already gone through any of this. Task: Copying files from a remote server to a local machine folder using File System task and For each loop container. Problem: The job…
Santosh Gadhave
  • 37
  • 1
  • 6
-1
votes
1 answer

Checking files exists using wild card in SQL Server 2014

I will have daily 3 files coming into my C: drive with timestamps in YYMMDDhhmm format. for ex. TotalSale1611160037 means 2016-11-16 12:37 am TotalSale1611160037 RegionSale1611160037 Statesale1611160037 I have scheduled a job in SQL Server Agent…
Please
  • 41
  • 1
  • 7
-1
votes
2 answers

Execute SSIS SQL Task based on condition

Here I've two sql task namely TotalCount_Quest_HF and TotalCount_Quest_HF_Table. These 2 sql task would return total count from 2 tables into variable 'v_TotalCount_Quest_HF' and 'v_TotalCount_Quest_HF_Table'. Now I want execute 'Preparation SQL…
user1902849
  • 1,113
  • 6
  • 23
  • 33
-1
votes
1 answer

Create a txt file with SSIS showing File Movements

I need to create a .txt file every time and SSIS job runs and in that file I need to put the name of the files that I am transmitting. I have a foreach container but I am not sure on how to create the file and then write to it as each file is being…
mhodges
  • 37
  • 1
  • 11
-1
votes
1 answer

Detecting an empty flat file with SSIS script task

I am looking for a script task which identifies a zero KB file in a folder and outputs the same in a mail or text file. Thanks in advance. Let me know for any questions.
MGM
  • 57
  • 1
  • 7
-1
votes
1 answer

SSIS expression builder error casting date

whats wrong with this syntax, I got this piece of expression: (DT_I4)((DT_WSTR,4)YEAR(GETDATE()) + RIGHT(“0” + (DT_WSTR,2)MONTH(GETDATE()),2) + RIGHT(“0” + (DT_WSTR,2)DAY(GETDATE()),2)) The above was taken from this…
abs786123
  • 581
  • 2
  • 11
  • 24
-1
votes
3 answers

Processing Multiple files in multiple folders and archiving the folders using SSIS

I need to process the .txt files present in the below folder structure. I need to load all the *.txt files to a table. I have achieved that by using the SSIS foreach loop and checking "Traverse Subfolders" has loaded all the files to the table. But…
user3255656
  • 45
  • 1
  • 9
-1
votes
2 answers

SSIS- SQL AGENT Sending Mail for Each hour

i have designed a SSIS Package which will load some data to table from the file available in a folder. once data got loaded file move to archieve. Client requested to have mail trigger at the end of process, so i implement it through send mail…
akhrot
  • 415
  • 2
  • 7
  • 18
-1
votes
1 answer

SSIS Design pattern for Multiple XLSB File sheets to multiple tables

There are xlsxb files and each of these consists of varying number of sheets (consists of upto 9 sheets) .All the sheets are of different structure.The requirement is to laoad a specific named sheet data into corresponding table.The specific named…
user1254579
  • 3,901
  • 21
  • 65
  • 104
-1
votes
1 answer

How to insert the records in child table when records are inserted into parents table in SSIS?

I am stuck with a scenario in SSIS. I have two table both maintain the referential integrity means one is parent table and another is child. When I insert the some records in parent table then those new records should be insert into child…
Ankit
  • 13
  • 1
  • 7
-1
votes
1 answer

SQL Server 2012 SSIS :environment properties sensitive check box is not showing

New to SSIS and when following through coursework I find that the sensitive check box is missing when I clicking on the Variables tab of the Environment Properties. I first suspected that this was a display problem so changed the display down to…
MarcW
  • 1
  • 3
1 2 3
…
91 92