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

SSIS merge join giving null results while adding more columns to one of the sources

I am trying to use the merge join in ssis; however, when i am putting in two columns on basis of which i am joining it is giving me correct results. But as soon as I add more columns in one of the sources, it gives me matches with nulls only.
user2438237
  • 315
  • 2
  • 4
  • 16
0
votes
0 answers

Is there any limitation for RETURN Function in SSIS Script Task Using Vb.net

I wrote more than 15 validation steps in script task using vb.net. Find the below sample scripts .If this condition passed more than 50K records continously my package itself getting hanged up. If (Row.Code.ToString <> "-1" And Row.Code.ToString <>…
Dinesh
  • 303
  • 2
  • 6
  • 19
0
votes
1 answer

Using user variable in condition split SSIS

I am using a DFT that pulls the records from DB where ErrorInd is 1. I want the error records to be placed in a flat file, and if there are no errors I do not want to create any file. To to this, first I created a variable @RecordCount and this…
Harsha
  • 113
  • 9
0
votes
0 answers

Read header values from excel to variable in ssis

I have to read the header from the excel file and compare with DB structure just to ensure file format is correct before loading. I created a Excel Source plus and unchecked "First row has columns" and I am reading only 1 row from excel. Now I have…
Harsha
  • 113
  • 9
0
votes
0 answers

Install SSIS on my system without sql server

I want to install SSIS on my system so that I can check a package execution without sql server. Can anybody tell me is it possible? and if it is possible can you guys please share the link from where I can get the setup of SSIS. I don't want to…
Kapil Dhawan
  • 101
  • 1
  • 2
  • 11
0
votes
1 answer

using ssis 2008 to read cell of fixed format excel file

I have many excel files with fixed format. I want to read these files and insert the data into SQL server using SSIS 2008. excel sheet format excel sheet I want to load only the yellow cells in SQL server. in the format: name col1 col2 col3 …
shdb
  • 1
0
votes
0 answers

how to dynamically add columns in SSIS

suppose, I have a flat file as a source in SSIS which contains 3 columns and its keep on changing a b c 1 2 3 2 3 4 now I need that if the flat file is changed (suppose two new columns are added) then the destination file (table in SQL)…
Aishwarya Mishra
  • 43
  • 6
0
votes
1 answer

Dynamically connect to the server a package is deployed on

I have a package that needs to be run in different environments (different server\instance, same database name) for example: server: live-db01\live db: Campaign server: dev-db01\livedebug db: Campaign The package itself is identical for each…
Marco Fatica
  • 937
  • 7
  • 12
0
votes
2 answers

Best Approach on MS CRM Data Migration

I have to migrate data from CRM 4.0 to MS CRM Online & customer has around 35GB data now my question is which would be the best way to migrate the data? A: Using CRM 4.0 Data Migration Manager to export the data & then using import the data using…
Deep
  • 101
  • 9
0
votes
1 answer

Not able to see script (VB code) from SSIS script task

I have one already developed SSIS application using SQL Server 2005. I'm trying to view the script like below: Right click -> Edit -> Script -> Design script [normally instade of "Design script" it should come "Edit script". I think, due to SSIS…
AskMe
  • 2,495
  • 8
  • 49
  • 102
0
votes
2 answers

SSIS avoid changing derived column expression manually

I have an SSIS package which needs to run every first day of the week, source is from excel file and the destination is SQL table. The current process is to replace the null value to 0 of excel file manually, (it takes a lot of time), so I have…
r-r
  • 307
  • 2
  • 15
0
votes
0 answers

Adding multiple evaluation expression in For Loop SSIS

Is it possible to add multiple evaluation expression in for loop container. Background: I have a file, in the file the value of a field will be Y/N, If the value is N then I have to keep reading this file until the value is Y then exit for loop. To…
Harsha
  • 113
  • 9
0
votes
1 answer

write variable in Execute SQL Task

Based on few conditions I want to set a variable to true or false in Execute SQL Task. This is my query If ? <> 0 BEGIN If CAST( ? as DATE) <> (select MAX(cast(Date as DATE)) from ) begin set ? OUTPUT = 'True' …
Harsha
  • 113
  • 9
0
votes
1 answer

SSIS Foreachloop container inquiry

I have searched for this question everywhere and can't seem to find it so here we go. I set up a Foreachloop container which is using the "Foreach File Enumerator" and in the Files section where you're naming the format of the file as well as a…
Claudio
  • 230
  • 1
  • 2
  • 10
0
votes
1 answer

How to find the Flat file which is currently updating record into it

In SSIS In a folder there are many flat files and by using for each loop container we are processing it one by one. If any new file is placed in the folder and it is still in copying mode. Then, We should not take it for continue process. We should…
Sankar M
  • 71
  • 6
1 2 3
…
29 30