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
-1
votes
1 answer

SSIS Expression

SELECT CAST(Count(1) as VARCHAR(30)) AS SourceRowCount FROM table where countryid= '" +@[User::Id] +"'"+ " "+" AND locationid ="'+@[User::ID1]+'" Expected output SELECT CAST(Count(1) as VARCHAR(30)) AS SourceRowCount FROM table where…
jes
  • 1
-1
votes
2 answers

how can i continue for-each loop in SSIS when a task into for-each loop failed?

I have package SSIS package and i work with SSIS 2008. I have start package which call other package i want to read files in daily folder on WEB_DAV folder and insert records in tables and update some table and move this file to backup folder, …
sara Sodagari
  • 423
  • 1
  • 9
  • 23
-2
votes
1 answer

How to merge two excel sheets in SSIS?

I want to join two sheets .data like city, postal_code, state, state_code from one table with city, state_code, state, country from another table. When I am using Merge It just allow me to take either column of 1st input or columns of 2nd input but…
Palak
  • 55
  • 1
  • 10
-2
votes
2 answers

How to zip a Folder using SSIS 2008 without using any third party s/w?

I have a scenario where i would like to compress my folder due to presence of large number of files present in them using SSIS 2008. Consider it like i have one Source Folder and one Target Folder and while moving files from "SRC" to "TGT" the…
P Kernel
  • 217
  • 4
  • 13
-2
votes
2 answers

Identifying duplicate files based on data content in SSIS

I get files to a shared location . Every file has different meta ie. file name, date created. I have to extract the data using SSIS if and only if file content is different than previously processed files.
sandeep rawat
  • 4,797
  • 1
  • 18
  • 36
-2
votes
1 answer

How to seperate out ERROR FILE from Correct file using SSIS and archive them

I have a scenario where there are two source file ABC.txt and DEF.txt. i want to make sure that if any files are present in that folder with naming convention as ABC.txt, it has to be moved to the different folder prior to loading to the SQL server,…
user255826
  • 41
  • 8
-2
votes
1 answer

Copying audio files having length more than 5 minutes in SSIS

We have a call recordings for a particular client loaded everyday on to our local server from third party FTP. Now client wants to send the recording files which are more than 5 minutes to their internal FTP.Is there a way in SSIS where i can…
SqlLearner
  • 763
  • 8
  • 23
  • 37
-2
votes
4 answers

How to fail a SSIS Script Task (using C#, 2008)

I have seen many codes lying around but apparently they don't help. Here is the logic I have to follow: I have a file getting read which has an amount field. This amount field can have negatives. I have to move the file and fail the package if I…
DURTAYY
  • 21
  • 1
  • 1
  • 6
-3
votes
2 answers

SSIS to get the particular file from multiple files and copy to different folder

my question is how we will create SSIS package to get the particular file from multiple files and copy to different folder Need Help
user10540455
  • 11
  • 2
-3
votes
2 answers

Importing tables from Salesforce to SQl server

Is it possible to Extract all tables of sales force into SQL server Like import in SQL server or SSIS
sonu kumar
  • 13
  • 2
-4
votes
1 answer

Passing 50000+ parameters in WHERE clause using SSIS package

I have a query to extract data from server. The server contains millions of data and I need to filter out only 56000 of Doc IDs out of those. Could anyone help me build an SSIS? I cannot use Merge here since I would ave to extract the entire data…
Prasanna V
  • 1
-4
votes
1 answer

Get Email whenever SSIS task fails

I have one SSIS packages that has many of SQL Execute task. I want to know whether a particular task has passed or not. Is it possible for me to get email for all the tasks, to trace whether the package has failed or has passed? It would be also…
xorpower
  • 17,975
  • 51
  • 129
  • 180
-7
votes
1 answer

SSIS and SQL Server

I have created ssis package which import data from a .csv file into sql server table. It is working fine but now i want to give condition that package should only run when date and time is changed or csv file is modified (Or new csv comes in)
Prasad
  • 21
  • 3
1 2 3
…
29
30