Stack Overflow
Stack Overflow

Questions tagged [dataflowtask]

113 questions
0
votes
0 answers

How to increase Data flow task to handle more than 50 million records in SSIS

I am facing a challenge when I try to load more tha 6 million of records. I am getting the below exception after 3 million records. The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020. The input source is a text…
user416
  • 516
  • 3
  • 12
  • 34
0
votes
3 answers

How to pass Multiple Input for SSIS Script Component

I have a Custom Source DataFlow Component whose O/P will differ every time, I need to Insert those records in to a Destination table. Problem:- Can't Specify the Input columns at Design time for Destination Component.. as in actual for every call to…
manas das
  • 64
  • 12
0
votes
0 answers

SSIS: Violation of Primary Key

I am troubleshooting a following error for another user. The other user has a very simple SSIS package. His package contains a source and a destination. The Source is a different database. Lets say A and destination is a different database. Lets…
Ranjeet Choudhary
  • 1
  • 2
0
votes
1 answer

How to pass table variable data into a data flow in ssis

I wrote a code like this in execute sql task Declare @tmpHistoricDriveSpace Table ( Servername varchar(255), MachineName varchar(255), Drive char(2), FreeSpace_MB int) insert into @tmpHistoricDriveSpace (Drive, FreeSpace_MB) exec…
Prav54
  • 3
  • 4
0
votes
1 answer

How to connect two data flow tasks in SSIS package programmatically?

I am working on a console application which generates SSIS package. I have two data flow tasks which I need to connect in a certain order. How can the tasks be connected? I guess there must be something like a path between data flow task components…
Karen Gumerov
  • 13
  • 4
0
votes
1 answer

Multi-threading in custom SSIS transformation data flow task

I have an SSIS package which does this: 1. Read records from flat file source 2. Transform by calling webservice which adds additional response column to buffer 3. Output all input records and response column into destination file. 2 is a custom…
kouri
  • 167
  • 1
  • 3
  • 13
0
votes
2 answers

SSIS Package returning less rows with MDX query

I'm trying to extract data from a cube using MDX, when I run the query in SSMS I get 500K rows (same result I get when I use excel to connect to the cube), however, when I put the query into a SSIS package and execute it I get only 100k rows. The…
user1112251
  • 119
  • 1
  • 4
  • 13
0
votes
1 answer

The version of component "x" is not compatible with this version of the DataFlow

Getting this error trying to run an SSIS Package on a 64 bit install of SS2K5 Enterprise Edition SP3. Package was developed using 32 bit BIDS, and deployed successfully to 64 bit SS2K5 Enterprise Edition SP2, and 64 bit SS2K5 Developer Edition…
user201917
0
votes
2 answers

How to get last two numbers from year in a variable expression for ssis package?

I am dynamically generating the date for ssis tranformation using variable expression. My below expression generates the output like: 02102014.csv Expression : +RIGHT("0" + (DT_WSTR, 2) MONTH(dateadd("d", -1, getdate())), 2) +RIGHT("0" + (DT_WSTR,…
user3203331
  • 429
  • 2
  • 7
  • 23
0
votes
0 answers

Data conversion and loss data errors in SSIS 2012

Report.csv Date Website Emp EmpID EmployeeHireDate Skill ATTEMP1(secs) ATTEMP2(secs) 2/4/2014 0:00 Chicago TV 767373 8/18/2013 0:00 DANCE 1858.166667 …
user3203331
  • 429
  • 2
  • 7
  • 23
0
votes
2 answers

How to call a web service with multiple input (in a Script Component) in SSIS?

I need to use a Web Service that allows me to perform a special calculation. To perform this I used a Web Service Task, but the problem is that I only know how to call the Web Service once (1 input value), and I need to perform the calculation for…
Tassisto
  • 9,877
  • 28
  • 100
  • 157
0
votes
0 answers

Batch data flow task edit in SQL Server Data Tools (SSIS)

I have a database with several thousand tables. Now I need to import some of that tables to another database (names and columns are identical). I have created SSIS package and with "SSIS Import and Export Wizard" created about 300 data flow tasks to…
Alexander Kuzin
  • 463
  • 4
  • 13
0
votes
1 answer

To read Xml file from variable in XML Source in SSIS

I am getting the result in variable through web Service Task as shown in below image, Then I have used XML task to remove the excess namespace and stored the processed result in another variable in strProcessedResult Variable as shown in below…
Reshma
  • 864
  • 5
  • 20
  • 38
0
votes
1 answer

Getting Avalilable lookup columns in Loookup transformation into Lookup not match output path in ssis?

Can anyone suggest how to get Available lookup columns in Loookup transformation into Lookup No match ouput path? please suggest me any way how can I get those columns in Available lookup columns into Lookup No match ouput path? Thanks in…
praveen
  • 93
  • 1
  • 3
  • 6
0
votes
1 answer

How to get Avalilable lookup columns in Loookup transformation into Lookup not match output path in ssis?

Can anyone suggest how to get Available lookup columns in Loookup transformation into Lookup No match ouput path? please suggest me any way how can I get those columns in Available lookup columns into Lookup No match ouput path? Thanks in…
praveen
  • 93
  • 1
  • 3
  • 6
1 2 3 4 5 6
7
8