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 Year() function incorrect for end of year?

In my OLE DB Source, I have a query that uses a parameter: AND x.plan_year = YEAR(?) The parameter is a date value, set to a variable I control. For most dates this returns the correct database values, but I noticed that 12/30/2012 and 12/31/2012…
gfrizzle
  • 12,419
  • 19
  • 78
  • 104
-1
votes
1 answer

Regex to extract SSIS formulas in Notepad++

I have a long list of formulas in Microsoft SSIS that I have to translate into SQL queries. All the formulas of my list are basically made with the following rules: PART_1 ? PART_2 : PART_3 means if PART_1 (test) is true then PART_2, if false then…
Nicolaesse
  • 2,554
  • 12
  • 46
  • 71
-1
votes
1 answer

How to load Multiple different structured CSV files into one table using SSIS?

I am trying to load a set of different structured CSV files into a single table using SSIS. I don't want to create a connection for each CSV file. Can anyone suggest how to load a different set of structured CSV files into single table. For Example,…
arvind gova
  • 46
  • 6
-1
votes
1 answer

How to delete an existing csv file and create new one in ssis?

I am new to ssis. I want to schedule a job to create a csv file daily. So each day, the existing file should be deleted and I want to create a new csv file. Could you please help me with this?
Sharon
  • 3
  • 1
-1
votes
1 answer

SSIS convert source table into multiple data flow tasks that insert into same destination table

I have to migrate data from informix database to sql-server database. I'm using ssis packages for that transformation. Informix database have tables that contain million of records.So, when i execute the ssis package that do transformation , it…
Arslan Aslam
  • 121
  • 1
  • 10
-1
votes
2 answers

Bucket analysis in SSIS Derived column

I have a do a bucket analysis of some days calculation in SSIS staging please help me in fixing this DAYS <=90 = 0-3 Months DAYS >=91 && DAYS <=180 = 3-6 Months else > 6 Months which I tried to frame like below but not working, and i am very new…
Manoj
  • 1
  • 4
-1
votes
3 answers

SSIS 2008 R2 - Can I set a variable to the name of the current scope?

This seems ridiculously easy, but I can't find it anywhere... I have a VERY simple sequence container with two tasks: Truncate a SQL table, and repopulate it from production. But this container will be repeated for about 50 tables. The container's…
user1916006
  • 31
  • 1
  • 4
-1
votes
1 answer

SSIS Transformation for flat file

This is my Table in SQL Server: Country varchar(50) varchar(50) Int and i have a flat file data ------------Flat file---------- Output: Can you please suggest me the process, how to perform this task and what all tranformation should i use…
Bright Junis
  • 11
  • 5
-1
votes
1 answer

Where is the "UserKey" stored used in "EncryptSensitiveWithUserKey"?

Where Can I find the userkey where the SSIS packages uses for protection EncryptSensitiveWithUserKey. 1.Is it Editable? if I create a new SSIS Project with my new profile, can I copy the "UserKey" from the new Project into my old Projects to allow…
Abhijit Kaware
  • 9
  • 1
  • 5
-1
votes
1 answer

Excel connection manager failed with error code 0xC0202009

I have ssis packages made in Microsoft vs2008, for generating reports in excel formats. For excel connection manager version excel version used is 'Microsoft Excel 97-2003. Till day before yesterday it was working fine. But from yesterday it was…
user8456080
  • 1
  • 1
-1
votes
1 answer

SSIS Conditional Split to Flat File Destinations

I've got a data flow task which has a conditional split which then leads to two different flat file destination. The thing that is puzzling me, is why do I have different 'available destination columns' in the flat file editor's mappings tab than I…
Graham Reavey
  • 25
  • 1
  • 6
-1
votes
1 answer

How to import data from multiple files with different columns to multiple destination in SSIS?

Objective: Load data from flat files which has different headers to it's each corresponding table.The files can be differentiated by it's filename as it contains the name of the table. What I've tried: Used a foreach loop container to loop multiple…
kurozakura
  • 2,339
  • 8
  • 28
  • 41
-1
votes
2 answers

SSIS- SQL AGENT Sending Mail for Each hour

i have designed a SSIS Package which will load some data to table from the file available in a folder. once data got loaded file move to archieve. Client requested to have mail trigger at the end of process, so i implement it through send mail…
akhrot
  • 415
  • 2
  • 7
  • 18
-1
votes
1 answer

SSIS Design pattern for Multiple XLSB File sheets to multiple tables

There are xlsxb files and each of these consists of varying number of sheets (consists of upto 9 sheets) .All the sheets are of different structure.The requirement is to laoad a specific named sheet data into corresponding table.The specific named…
user1254579
  • 3,901
  • 21
  • 65
  • 104
-1
votes
1 answer

How to insert the records in child table when records are inserted into parents table in SSIS?

I am stuck with a scenario in SSIS. I have two table both maintain the referential integrity means one is parent table and another is child. When I insert the some records in parent table then those new records should be insert into child…
Ankit
  • 13
  • 1
  • 7
1 2 3
…
29
30