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

Create a folder in SSISDB using powershell

I need to create a folder in a existing SSISDB catalog using powershell. I don't want to delete the catalog but need the connection.
Sravani Annepu
  • 118
  • 1
  • 13
0
votes
1 answer

Call a Stored Procedure in SSIS Data Source

I am trying to call a stored procedure in SSIS OLE- DB DataSource (My Datasource would be SQL Server 2012). I tried a procedure call SQL statement under SQL Command option but when I click the preview button I am getting an error. Please guide me…
StackUser
  • 5,370
  • 2
  • 24
  • 44
0
votes
1 answer

Last row is a blank row in flat file destination SSIS Package

An SSIS package exporting data to the flat file text. The exporting work fine, except for the blank row at the end of file. Is there a simple way to get rid of the blank row? Ragged Right in Source and Destination Flat File Connection 9 Columns…
Balaji
  • 47
  • 1
  • 9
0
votes
1 answer

SSIS parallel execution of same package which is depend on one parameter

Please see the attached picture for better understanding of my question.
Avijit Das
  • 52
  • 4
0
votes
0 answers

SSIS Package Level deployment

In SSIS Package Level deployment child package parallel execution is happening. In one execution point there is three execution record that also needs to execute parallel. If I put debug point on 2nd then it's working as expected otherwise it's…
Avijit Das
  • 52
  • 4
0
votes
1 answer

The process cannot access the DTSX file - SSIS installation

I'm trying to deploy SSIS package using "Integration Service Deployment Menufast" I have around 12 packages. Error is showing for pakage3. Getting one error: The process cannot access the file 'E:\LOC\3Pkg.dtsx' because its being used by another…
AskMe
  • 2,495
  • 8
  • 49
  • 102
0
votes
0 answers

Checklist for deployed web applications & SSRS and SSIS services hosted if the IP changes for windows server

We have windows server which is being shifted to another location due to which the IP would change for it. It is a physical server with 2 virtual servers created on it-one being used as web and the other as DB. Both of them appropriate ports opened…
Richa
  • 407
  • 1
  • 10
  • 22
0
votes
1 answer

SSIS Report Format Issue

I want to generate a csv report with the following format in SSIS - Some Static Text - 1 Data from SQL Some Static Text - 2 Data From SQL I was thinking to create a report with these static texts in my report and generate the SQL data at runtime.…
Abhijith Nayak
  • 448
  • 7
  • 21
0
votes
1 answer

Saving Date based in flat file into variable (SSIS)

I've a flat file with many columns, one of which is Date. Format is as following '25.01.2016'. I've many rows, and for each row date is the same ('25.01.2016'). Flat file is rewritten every day, so date changes every day. I have created a dataflow…
rakamakafo
  • 1,144
  • 5
  • 21
  • 44
0
votes
1 answer

SSIS: Export to Dynamic Excel File

I am trying to create a project that will produce a separate excel file for every account in a specific table. The first steps to pull the data into a temp file and load an array variable with the accounts for the loop, this is working fine. I am…
Holmes IV
  • 1,673
  • 2
  • 23
  • 47
0
votes
1 answer

Implementing condition in SSIS

I'm importing data from txt to Sql Server table. That part works good. Everyday this txt file is being deleted and new txt file is formed (i.e. yesterday there was data for 3 February, today for 4 February (column Date)). When I run package, I want…
rakamakafo
  • 1,144
  • 5
  • 21
  • 44
0
votes
0 answers

SSIS ScriptTask Issue

I am building a SSIS package in Sql Server 2008R2. I need to add a Script Task to this package but I have run into a strange issue. I create the Script Task and select edit script. I can see all the files I need are there and can edit the…
franburr
  • 51
  • 1
  • 7
0
votes
1 answer

Customised Output Filename In SSIS

there are two files, old and new and those are dropped respectively to old and new folder via FTP Task . i am bulkloading the file and do some calculation, and output file again need to drop in output folder but how can i name the output file same…
Rajee Kasthuri
  • 159
  • 7
0
votes
0 answers

SSIS Send Email Time out Error

I am sending one 15 MB file via Send Email Task in SSIS. The task ran fine until today where the Send email task threw an error saying "The operation has time out". I did some googling and found out that we can use Script Task to forcefully include…
xorpower
  • 17,975
  • 51
  • 129
  • 180
0
votes
0 answers

SQL Server Configuration not able to retrieve password from the table

I have SSIS package which i connecting to a oracle server and truncate a table. If I configure the package using XML configuration my package is succeeding. I want to utilize SQL server configurations for my package. If I set that up, I'm not able…
RMu
  • 817
  • 2
  • 17
  • 41
1 2 3
…
29 30