Stack Overflow
Stack Overflow

Questions tagged [ssis-2005]

Microsoft SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformations solutions. SSIS 2005 is a part of SQL Server 2005 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

35 questions
1
vote
2 answers

Assign value to SSIS Script Component new Output Column

I'm sure this is a simple issue, but I'm trying to combine 2 columns into a new output column, but have not had any luck with it. Each time I get an 'Object reference not set to an instance of an object.' error Here is my code: Imports…
JFV
  • 1,803
  • 6
  • 24
  • 38
1
vote
3 answers

Loading Comma Separated csv file to table in SSIS

I have a csv file with below formatted data. File: Sample.csv Id,Name,Address 1,Abcd,street1,3rdcross,xxxx 2,Cfre,2ndmain,3rdstreet,yyy 3,Asdf,4thmain,1stcross,zzz Need to load the data to table like below. Table: Sample Id Name Address 1 …
Naveen Kumar
  • 582
  • 2
  • 8
  • 25
1
vote
2 answers

Get previous day in an Expression

Just need help on this as I am new at SSIS. I got an expression but I want yesterday, not today. "Daily "+ (RIGHT("0" + (DT_STR,4,1252) DatePart("yyyy",getdate()),4))+(RIGHT("0" + (DT_STR,4,1252) DatePart("mm",getdate()),2))+(RIGHT("0" +…
YJG
  • 123
  • 2
  • 12
1
vote
1 answer

Default Buffer Max Size and Default Buffer Size in SSIS

Is there any relationship between Default Buffer Max rows and Default Buffer Size in SSIS. How to supply values to these property parameters? I mean is there any propossionality in between these ?If I double the buffer size double then can i also…
user1254579
  • 3,901
  • 21
  • 65
  • 104
1
vote
2 answers

Creating centralized DB

I have 2 databases(A) with same name in different servers( B & C). Both the databases have same schema. (sql server 2008 r2) Task 1: Copy(transfer) both the databases into 3rd server (D) with the names (A_B and A_C). Task 2: Merge both the databases…
Ritesh
  • 401
  • 4
  • 11
  • 19
1
vote
2 answers

SSIS migration from 2005 to 2008? Just opening in BIDS 2008 (which will do conversions) and then deploying in 2008 enviorment work?

I have been given a task to migrate 2005 packages to 2008, I was looking for discontinued features by SSIS 2008 on http://technet.microsoft.com/en-us/library/bb500429(v=sql.100).aspx It seems VSA is discontinued and replace by VSTA. As I am doing…
Pritesh
  • 1,938
  • 7
  • 32
  • 46
0
votes
1 answer

SSIS: DT_NUMERIC is unsigned int with a "separate sign". Is it signed or not?

Here are two slightly different definitions of DT_NUMERIC from msdn An exact numeric value with a fixed precision and scale. This data type is a 16-byte unsigned integer with a separate sign, a scale of 0 - 38, and a maximum precision of 38. An…
adolf garlic
  • 3,034
  • 7
  • 39
  • 54
0
votes
1 answer

Passing a Date from an SSIS Package to a "Add Date Suffix to File Name" batch file routine

I have an SSIS Package that passes a date param from a Package variable to a Batch file as a parameter. The intent of the Batch file is to rename a predetermine file in an predetermined location such a date suffix is added to the file name where teh…
Chad
  • 23,658
  • 51
  • 191
  • 321
0
votes
1 answer

How pass data from SQL Server to mysql with the Microsoft tool SSIS 2005?

I'm using the Microsoft SSIS tool in version 2005 to generate ETL I want to perform an ETL that takes care of passing data from a database I have in SQL Server to MySQL, and manages to migrate data from MySQL to SQL Server. In the data target I…
Luis Primo
  • 25
  • 4
0
votes
1 answer

SSIS package fails with only OnPreValidate in logs when run from a .NET app

I've created a SSIS package which runs smoothly when launched from SQL Server Data Tools (I use SSDT 2015 with SQL Server 2005 Developer Edition on my PC), but fails with only the following line in logs when I run it from a .NET app: Fields:…
Maxim
  • 972
  • 2
  • 10
  • 18
0
votes
1 answer

Difference between ssis upgradation and migration

I am migrating ssis 2005 packages to ssis 2012.Just wondering what is the difference 1) If I manually attach the 2005 packages to ssis 2012 project and modified all the objects according the new environment 2) Using the upgradation Wizard to…
user1254579
  • 3,901
  • 21
  • 65
  • 104
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
1 answer

Parent child SSIS 2005 deployment with SQL Server 2008

I have one master package and 29 child packages. I execute these 29 child packages from parent master package using an Execute Package task inside a for each loop container dynamically. My concern is how can I deploy them in live? Should I create…
Anil
  • 136
  • 1
  • 12
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