Stack Overflow
Stack Overflow

Questions tagged [ssis-2008]

Microsoft SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformations solutions. SSIS 2008 is a part of SQL Server 2008 business intelligence platform.

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

448 questions
0
votes
1 answer

Package Error At Execution Timing

I have 10 package in SQL server integration service. When I was trying to execute them out of them 5 are executed correctly, then 6, 7 are giving error and 8, 9, 10 are executed correctly... So how we can handle it?
Rohit Mohanty RJ
  • 1
0
votes
1 answer

SSIS- Dynamically name the excel file with the same name as the text file

I have some text files and I want to import those text files one by one to my database and then apply some updates and extract the files again one by one in .csv format. I want to achieve this using for each loop.. How do I do this? Please help!!
Ruchi
  • 146
  • 1
  • 8
0
votes
0 answers

Decimal parameter error in Execute SQL TASK in SSIS 2014

I am working on SSIS 2014. I need to pass a decimal parameter in SQL Execute task in SSIS. Getting the below error: [Execute SQL Task] Error: Executing the query failed with the following error: "The type is not supported.DBTYPE_DECIMAL". I…
Anu
  • 11
  • 1
  • 2
0
votes
1 answer

Design pattern recommendation for the below mentioned ssis data flow

we need to refresh a table from the csv file.The source file columns are of text type.instead of using a derived column to convert the data type we use flat file source editor to change the data type as per the target. The idea is to avoid un…
user1254579
  • 3,901
  • 21
  • 65
  • 104
0
votes
1 answer

What ssis design pattern is good for flat file to table load

Planning to import 1000s of text file to sql server tables. All these files are having different structures and it goes to corresponding new tables in SQl. Different methods coming in mind is using of Biml /creating ssis packages with number of…
user1254579
  • 3,901
  • 21
  • 65
  • 104
0
votes
1 answer

Difference between ssis upgradation and migration

I am migrating ssis 2005 packages to ssis 2012.Just wondering what is the difference 1) If I manually attach the 2005 packages to ssis 2012 project and modified all the objects according the new environment 2) Using the upgradation Wizard to…
user1254579
  • 3,901
  • 21
  • 65
  • 104
0
votes
0 answers

ssis package on catalog and on sql agent job(The sql agent job Error)

An ssis (2012) package contains vb script to read a file is running fine and succeded on the catalog.When created as a part of a sql job it has been running for a while not giving any updates.It seems a file reading problem when running using…
user1254579
  • 3,901
  • 21
  • 65
  • 104
0
votes
1 answer

SSIS_Get count of rows from source and load to destination

I have two OLEDB sources such as DB Source1= select count(*) from A DB Source2= select count(*) from B Now, I need to get the count of Records uploaded DB Source1 -DB Source2 for eg, DBSource1 = 9 ;DBSource2= 1 then record uploaded will…
Aiswarya
  • 37
  • 7
0
votes
2 answers

SSIS - Continue further process , on processing multiple files, if any one of the file errored out

I've to load data from multiple files in to a table thorough for each loop container in SSIS. If any one of the file got error-ed out then the package stops execution. Now, i've to move the error-ed file to a different path and continue to process…
Bharath
  • 31
  • 1
  • 4
0
votes
0 answers

Timeout expired. SSIS

I am getting this error randomly: Timeout expired. "Error: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed…
SQLSERVERDAWG
  • 57
  • 2
  • 10
0
votes
1 answer

passing parameters in ado.net source

I wanted to pass a parameterized query in ado.net source and i rea don this post that only way to do this is to use expressions. So here is my expression "SELECT LEDGER_YR_MO, LOCATION, FDR_FND_NO, FDR_INVST_POOL_CD, …
SQLSERVERDAWG
  • 57
  • 2
  • 10
0
votes
1 answer

load file with csv extension in ssis

I have to load file with csv extension from one particular folder to data base in ssis. file name is not known but folder and extension is fixed.
John
  • 1
0
votes
0 answers

Parallel Data Flow Task in SSIS

I am facing a problem for data flow task for parallel execution to insert rows into a single table e.g TABLE_DESTINATION from a source Table e.g TABLE_SOURCE.I do not directly insert the row into the table "TABLE_DESTINATION" . I use a stored…
Supriyo Bhattacherjee
  • 547
  • 1
  • 5
  • 26
0
votes
2 answers

SSIS Execute SQL Task error no rows returned

I am a bit new to SSIS and given a task to send mail to particular stores based on Purchase Orders -> PONumber. The steps should be as follows: 1)Take a XML file from a particular folder 2)Get the PONumber from that file 3)Write a query to fetch…
Shivang
  • 231
  • 1
  • 5
  • 17
0
votes
1 answer

SSIS Execute SQL Task calls a stored procedure. How to get count of records returned by SP

My SSIS has Execute SQL Tasks which just calls a stored procedure. How to get count of records returned by the stored procedure?
AnandMaharana
  • 3
  • 4
1 2 3
…
29 30