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

How to fail SSIS Execute Process Task on failure of SQL Server BCP IN to transfer record(S)?

I have a SSIS Execute Process Task which calls a .bat file which calls SQL Server BCP IN to move data from a file to SQL Server. Now even if BCP IN fails to transfer some records (due to data type mismatch) Execute Process Task does not fail. We…
Pritesh
  • 1,938
  • 7
  • 32
  • 46
0
votes
1 answer

Variable Mappings in SSIS ForEach Loop

I'm populating an ado net dataset in SSIS 2008 with a stored procedure. The resultset contains 21 columns. When using a For Each loop in SSIS, it appears that if I want the first two columns, then the 20th column I can't use index 0,1, 19. It…
user1408685
0
votes
1 answer

Unlock Variable in SSIS

I have already ask this question and I thought I found a solution but I am stuck yet again. I am having issues with unlock variables. I'm running a SQL Server Agent Job which has a script task with Microsoft Visual C# 2008 which is below. I…
Djbril
  • 745
  • 6
  • 26
  • 48
0
votes
1 answer

Conditional text replace visual studio

I have a csv that gets imported into SQL server using BIDS\SSIS. One of the columns is called callerid which is just a phone number. The corresponding sql db column is numeric. Occasionally the callerid field is filled in as 'UNKNOWN' causing my…
d90
  • 767
  • 2
  • 10
  • 28
0
votes
2 answers

Dynamic connection string not working in SSIS package 2008R2

I am using SSIS package for Import data from excel sheet to SQL DB. In the configuration file I'm using following variables. Name scope DataType Value ---------------------------------------------------- DBName …
Gurunathan
  • 97
  • 4
  • 19
0
votes
2 answers

SSIS TPT Import error

When i try to load data from excel source to the teradata with ssis and using microsoft connector for teradata by attunity 1.2 i got below error, what am i missing? [Teradata Destination [23]] Error: TPT Import error encountered during Initiate…
kerem
  • 15
  • 7
0
votes
1 answer

SSIS Lookup join and SQL join

Joining 2 tables using the ssis lookup would result only the first matching output,rather than all the matching output in SQL.Is there any way to code SSIS ,to result out all the matching out put. Table…
user1254579
  • 3,901
  • 21
  • 65
  • 104
0
votes
1 answer

ADO.NET Execution Task - Parameter Mapping Failure (Teradata)

Recently the server that houses all of my SSIS packages was upgraded. This has caused a need for all of our existing packages that utalize an OLE DB connection to be migrated to an ADO.NET connection. One of the issues I am running into is that…
Freddy
  • 2,249
  • 1
  • 22
  • 31
0
votes
0 answers

Export storedprocedure(SQL Server 2008 r2) data to excel 2010(more than 255 columns) using ssis 2008

I want to export output of a stored-procedure(SQL Server 2008 r2) to excel 2010 file(.xlsx) using SSIS 2008. The output of the stored-procedure generates more than 255 columns (e.g. 300 columns). When I use excel destination in SSIS 2008 I see only…
Praful Ravindra
  • 43
  • 1
  • 3
  • 8
0
votes
1 answer

Connection Managers don't work once I change the Protection Level

Using SSIS 2008 currently, my package ProtectionLevel is set to: EncryptSensitiveWithUserKey. I recently tried changing it to DontSaveSensitive but my package fails after making that change with the following error: SSIS package…
Juc
  • 217
  • 1
  • 3
  • 9
0
votes
1 answer

The ForEach Loop Enumerator is Empty - SSIS Error when executing through CMD via VBA

I am currently working on a SSIS package that is to be triggered through CMD via VBA (Access). All that the package does is read a bunch of files from a folder and upload them into a table in SQL Server. The tricky part comes is that this folder…
potluri
  • 25
  • 9
0
votes
0 answers

SSIS Excel Export changes Fonts 5 rows in

I am in the process of creating an excel export from SSIS. I have everything working perfectly however on some of the columns it increases font size 5 rows in. So for example the text in F3 is Font size 10, as it is for F4 but then in F5 it jumps to…
GPH
  • 1,817
  • 3
  • 29
  • 50
0
votes
0 answers

SSIS EXECUTE SQL TASK BULK INSERT ERROR

when trying to import a small text file into a table using ssis package(EXECUTE SQL TASK) got the below mentioned error [Execute SQL Task] Error: Executing the query "sp_import_pkg2010 ?,?,?" failed with the following error: "Could not bulk insert…
user1254579
  • 3,901
  • 21
  • 65
  • 104
0
votes
1 answer

How to calculate the OLEDB Destination Rowsperbatch and MaximuminsertCommitSize to get maximum Performance

In SSIS ,If we select the FAST LOAD Option then we have to set the 2 properties OLEDB Destination Rowsperbatch and MaximuminsertCommitSize Normally ,we go with default values ;but it has been understood that it gives a maximum performance if…
user1254579
  • 3,901
  • 21
  • 65
  • 104
0
votes
1 answer

Check Points in SSIS

I got question from interview!!! How to achieve Check point functionality in SSIS with out using check point. If package fails it has to be re-run from the point that it failed instead of rerunning the entire package.without using check point.
Rajashekhar
  • 75
  • 11
1 2 3
…
29 30