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
0 answers

Corrupted SSRS report rendered when generated from SSIS

I have an SSIS 2008 package that is reading data from multiple excel files, performing transformation and generating output in an excel file. I'm then using that output excel file as data source to call an SSRS 2008 report hosted on localhost…
Romanshu Goel
  • 103
  • 3
  • 9
0
votes
1 answer

SSIS - Create Batch File to Run Package

*****Update*** Also, I have tested utilizing the same database. (extract from one table into another in the same database and it was successful) New error: Code 0xc029303 Source: Package Connection Manager "Rpt" Description: The request OLEDB…
John
  • 109
  • 1
  • 5
  • 12
0
votes
2 answers

How can I insert in table list of file available in a folder

As the title I would like to insert in a SQL table the list of file available in a folder using C#. All the Files are CSV. At the moment at the end of the script I can not find any record into the table but I don't have any error code. I would…
power83
  • 69
  • 8
0
votes
1 answer

SSIS is running extremely slow in designer view

First, thank you for your time and consideration. Let me start by providing some context to my problem. I'm working on an ETL package which contains some data flows. One of those have 47 elements as described in the picture: I need to change the…
Nambu14
  • 380
  • 1
  • 7
  • 20
0
votes
1 answer

Sending mail to 100 users using SSIS mail task

I have to send mails to 100 people by using SSIS send mail task. but in SSIS mail box To address text box is having 255 characters limit where it's not allowing me to do. So could you please suggest the best way to achieve this..?
P.S. Rao
  • 47
  • 1
  • 9
0
votes
2 answers

Creating Source Assistant in SSIS Throws Error

Hello Every One ..!! I am trying to Create Basic ssis package which read text File and Transfer data to another database but when I am creating New source assistant In Data Flow tab From SSIS Tool Box I got Above Error . As per Error I…
Dhaval
  • 2,341
  • 1
  • 13
  • 16
0
votes
2 answers

Find tables/stored procedures in a list of SSIS packages

I have set of complex packages (.dtsx) in a particular folder. There are few issues needs to be addressed. I have to search few tables and stored procedures. For now I manually open the package and scroll all the tasks in control flow to know where…
StackUser
  • 5,370
  • 2
  • 24
  • 44
0
votes
0 answers

SSIS Event handling with Script task

I have a script task for Event handler on OnPreexecute for Data Flow Task(executable). Basically doing a data export to a flat file. Script has MessageBox.Show ("Everthing good") SSIS package executes fine but it doesn't display the msg. I was…
user1810575
  • 823
  • 3
  • 24
  • 45
0
votes
1 answer

SSIS package hang up at OLE DB Destination

I have a scheduled SSIS job, before it was executed w/o any problems. Today it stuck at OLE DB Destination, which is trying to populate records to the table on production server. I tried to change the connection which connects to our development…
LONG
  • 4,490
  • 2
  • 17
  • 35
0
votes
0 answers

How do I merge data from one table on one server to another table (same table name) located on another SQL server

I need to merge a table say table1 located on server1 to table1 (same table) located on server2. Actually I am asked to do this via ssis package
user7540144
  • 1
  • 1
0
votes
1 answer

SSIS Row Count Not Populating

quick question: I am having an issue with trying to get a row count in a data flow task. I have tried both a Row Count transform as well as a script task custom count and both are yielding the same result. I have a variable called "ETLRowCount"…
user3494110
  • 417
  • 2
  • 9
  • 25
0
votes
1 answer

Alternate of cursor for row by row operation

Stored procedure 1 has a select query returning a record set, dates to be specific. I am using a cursor to go through that record set and for each row another stored procedure is called. Stored procedure 2 inserts about 20K rows into a table for…
user1175126
  • 179
  • 1
  • 9
  • 21
0
votes
2 answers

Accidentally oped 2008 SSIS solution file in new version of Visual Studio. Cannot open any 2008 SSIS package anymore

I accidentally oped 2008 SSIS solution file in a new 2012 version of Visual Studio. Cannot open the any 2008 SSIS package anymore. I've tried creating a new solution but is still gives the error shown below. Please advise. The point is that I do…
Data Engineer
  • 795
  • 16
  • 41
0
votes
1 answer

SSIS - How to create a parameter for parameterized complex multi-statement script in OLE DB Source and join by this parameter with another source

I'm stuck with the following SSIS issue. I need to create a complex parameterized script for OLE DB Source in Data Flow component (SQL Server 2008). In addition to that, I need to join it with another OLE DB source by the script parameter. The…
Leo Dan
  • 23
  • 6
0
votes
3 answers

How I can create a column using script component in SSIS?

I have the follow situation: I need create a project in SSIS to import some datas from csv to our system but for to do this I must read some columns, and one of this columns is "group" of values. Are values of planning horizon and this horizon can…
Gabriel Castro Fernandes
  • 11
  • 4
1 2 3
…
29 30