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

SSIS 2008 sequence number

I have a requirement where the output file needs to be saved(dynamically) with the naming convention as FileName_YYY-MM-DD_FileNumber where file number is the sequence number. For example:- ABC_2009-01-01_001 ABC_2009-01-01_002 …
mehtat_90
  • 586
  • 9
  • 29
0
votes
0 answers

Running an SSIS 2008R2 Package from a SQL Server 2012 Job

I have an SSIS Package that was created in SQL Server 2008 R2. When I attempt to execute the package using the SQL Server 2008 R2 execute package utility, I receive no errors. When I try the same with the SQL Server 2012 execute package utility, I…
cdun2
  • 1
  • 1
  • 3
0
votes
1 answer

Passing DTS variable inside python script in ssis

I am trying to using a python script using the "Execute Task" tool in ssis.However, i am not sure if i will be able to use one of the runtime variable inside the python script. Eg: #inputval.py inputval =…
Christopher Rajendran
  • 17
  • 1
  • 2
  • 8
0
votes
0 answers

SSIS error 2008R2

I am encountering a weird error when I execute a SSIS packages through SQL Agent. Error encountered is:- The step did not generate any output. The return value was unknown. The process exit code was -1073741819. The step failed. But when I…
mehtat_90
  • 586
  • 9
  • 29
0
votes
1 answer

RecordSetDestination SSIS

What is the major use of recordset destination in SSIS?I heard that it is an in-memory,so the variable which is holding the data is it in raw format? Can someone explain the explain me the real time project use of Recordset destination?
N.Dinesh.Reddy
  • 522
  • 2
  • 7
  • 15
0
votes
2 answers

Remove duplicate in SSIS package with preference over a column data

I have duplicate rows in data coming from excel sheet. In the SSIS package, I am using Sort transformation where sorting is done in ascending order by the primary key column ID. But before removing the duplicates I want to see if the email column…
Sangam Uprety
  • 1,482
  • 2
  • 20
  • 38
0
votes
1 answer

Looping Through Columns in SSIS Script Component

I have a BIDS project set-up to upload data from several flat files to a SQL Server 2008 database. The data is provided by another organization. A lot of the data has trailing or leading spaces. This is enough of a problem that it would require me…
indigochild
  • 350
  • 1
  • 5
  • 21
0
votes
1 answer

2008 R2 - SSIS Script Component Output - Variable Column Length

Using SQL Server 2008 R2, BIDS, to create a SSIS package. I'm trying to use a variable to define the length for one of my script component outputs in my data flow. Obviously this doesn't work. I'm wondering if there is a workaround so I don't have…
Ben Y
  • 291
  • 6
  • 14
0
votes
0 answers

Adding new column and inserting values to an exisitng excelsheet using SSIS/SSRS

I have an existing excel template as like below : DATE 7/28/2016 7/29/2016 July MTD YTD Call Activity IB_Calls_Offered 22 29 52 52 52 IB_Calls_Answered 22 …
tapas kumar
  • 21
  • 1
  • 2
  • 10
0
votes
2 answers

How to read multiple flat files dynamic in nature at one go in SSIS

I have a folder which contains files like: A_ddmmyyyy, b_ddmmyyyy and c_ddmmyyyy. I need to read all these files for a date and again all these files for the next date present in the same folder. Also the number of files present in the folder…
atul bathla
  • 1
  • 1
0
votes
1 answer

How to write SSIS expression to append Previous week Monday to filename

I am trying to rename the file appending previous Monday date to the filename.I am using the following expression for appending today's date @[Dest_Dir] + "\\" + @[Dest_File] + "_" + (DT_WSTR,4)DatePart("yyyy", GetDate()) + RIGHT("0" +…
SqlLearner
  • 763
  • 8
  • 23
  • 37
0
votes
0 answers

"Error converting data type nvarchar to int."

Using SQL 2008, i was trying to setup an ETL and i run into the error below while running my dtsx package. Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source:…
jgpadilla04
  • 95
  • 8
0
votes
3 answers

Integration services : Implement onSuccess event in ssis. How to ?

I have a sequence container with multiple Execute package tasks in it. For each task what I want is to update a record in SQL table if the package executes successfully. I looked into event handling but there is no OnSuccess event in SSIS. I have…
programmie
  • 41
  • 3
0
votes
0 answers

DSV file import to SQL using SSIS

I have a .dsv file and I need to import into sql database. I tried converting into text and csv file format but I am unable to import them properly. The file is "|" delimited and it is unable to discover "|". Any help is highly appreciated.
Illuminati
  • 555
  • 2
  • 7
  • 34
0
votes
2 answers

execute sql task error

An execute sql task has been defined as below.the parameter mapping is system:Username input varchar 0 -1 System:packagename input varchar 1 -1 DECLARE @DataLoaderUsername VARCHAR(100) DECLARE @PackageName VARCHAR(100) DECLARE @Code…
user1254579
  • 3,901
  • 21
  • 65
  • 104
1 2 3
…
29 30